Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pausing a script
Message
From
02/03/2008 16:19:43
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01298052
Message ID:
01298070
Views:
26
>It does if you copy it to the url. This is a UT limitation, it doesn't handle links with () correctly.
>
>Samples from this link:
>
>BEGIN
>   WAITFOR TIME '22:20'
>   EXECUTE update_all_stats
>END
>
>This example shows how a local variable can be used with the WAITFOR DELAY option. A stored procedure is created to wait for a variable amount of time and then returns information to the user as to the number of hours, minutes, and seconds that have elapsed.
>
>CREATE PROCEDURE time_delay @@DELAYLENGTH char(9)
>AS
>DECLARE @@RETURNINFO varchar(255)
>BEGIN
>   WAITFOR DELAY @@DELAYLENGTH
>   SELECT @@RETURNINFO = 'A total time of ' +
>                  SUBSTRING(@@DELAYLENGTH, 1, 3) +
>                  ' hours, ' +
>                  SUBSTRING(@@DELAYLENGTH, 5, 2) +
>                  ' minutes, and ' +
>                  SUBSTRING(@@DELAYLENGTH, 8, 2) +
>                  ' seconds, ' +
>                  'has elapsed! Your time is up.'
>   PRINT @@RETURNINFO
>END
>GO
>-- This next statement executes the time_delay procedure.
>EXEC time_delay '000:00:10'
>GO
>
Ok, thanks for all that, but, I meant to be able to pause it manually when desired.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform