Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pausing a script
Message
De
02/03/2008 16:19:43
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01298052
Message ID:
01298070
Vues:
27
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform