Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to delay stored procedure execution in sql server

How to delay the execution of the stored procedure in SQL SERVER
The code below will delay the execution for 2hrs.

BEGIN  
    WAITFOR DELAY '02:00';  
    EXECUTE sp_helpdb;  
END;  
GO 
Comment

PREVIOUS NEXT
Code Example
Sql :: find column name in database 
Sql :: get columns number sql 
Sql :: sql pick random row 
Sql :: pip install mysqlclient error 
Sql :: raw query must include primary key 
Sql :: Unit mysql.service could not be found. 
Sql :: sql drop multiple columns if exists 
Sql :: how to delete columns in sql 
Sql :: delete a view sql 
Sql :: what is meant by trigger in dbms 
Sql :: metasploit start postgresql 
Sql :: t-sql find object by name 
Sql :: postgres remove foreign key constraint 
Sql :: get the rows from two tables whose relation is in 3rd table 
Sql :: select from one table where not on the other 
Sql :: mysql bidirectional composite primary key 
Sql :: oracle get trigger ddl 
Sql :: mysql between start date and end date 
Sql :: oracle apex prevent initial load 
Sql :: day of week postgresql 
Sql :: rows to comma separated values in mssql 
Sql :: split first name and last name in sql 
Sql :: how to install mysql server on centos 7 
Sql :: Failed to connect to localhost:1433 - self signed certificate 
Sql :: select from array in psql 
Sql :: What is localhost IP and MySql default port no. 
Sql :: how to add not null constraint in sql 
Sql :: sql server delete top 1000 
Sql :: postgresql fill fake data 
Sql :: psql client write to bash variable 
ADD CONTENT
Topic
Content
Source link
Name
6+5 =