|
Home > Archive > MS SQL Server Tools > March 2005 > Question About MS SQL
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Question About MS SQL
|
|
| Soner MUS 2005-03-31, 8:03 pm |
| 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.
| |
| Hari Prasad 2005-03-31, 8:03 pm |
| 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.
| |
| Tibor Karaszi 2005-03-31, 8:03 pm |
| 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.
| |
| Soner MUS 2005-03-31, 8:03 pm |
| 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.
|
|
|
|
|