Question About MS SQL

Hi There,
I want to ask a question about Stored Procedures,User Defined Functions.
Can we make sleep or anything else that doesnot spend any system
resource and makes small gaps between steps.
Best Regards.
Hi,
Look into WAITFOR { DELAY 'time' | TIME 'time' } command in SQL server Books
online.
Thanks
Hari
SQL Server MVP
"Soner MUS" <gazsobasi@.yahoo.com> wrote in message
news:%23QYyR7fNFHA.3336@.TK2MSFTNGP10.phx.gbl...
> Hi There,
> I want to ask a question about Stored Procedures,User Defined Functions.
> Can we make sleep or anything else that doesnot spend any system resource
> and makes small gaps between steps.
> Best Regards.
|||Yes. Use the WAITFOR command. Not that I understand why you would want to do that...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Soner MUS" <gazsobasi@.yahoo.com> wrote in message news:%23QYyR7fNFHA.3336@.TK2MSFTNGP10.phx.gbl...
> Hi There,
> I want to ask a question about Stored Procedures,User Defined Functions.
> Can we make sleep or anything else that doesnot spend any system resource and makes small gaps
> between steps.
> Best Regards.
|||Thanks For All. This is what I Want.
Best Regards
Soner MUS wrote:
> Hi There,
> I want to ask a question about Stored Procedures,User Defined Functions.
> Can we make sleep or anything else that doesnot spend any system
> resource and makes small gaps between steps.
> Best Regards.