Wednesday, 3 August 2016

Add Delay (wait) between two SQL statements

SELECT GETDATE() CurrentTime --First Statement
WAITFOR DELAY '00:00:05' ---- 5 Second Delay
SELECT GETDATE() CurrentTime -- Second Statement
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

SQL Table : Change Row As Column and Group Them... ( Setting column values as column names in the SQL query result )

Setting column values as column names in the SQL query result Problem Statement : id col1 col2 1 Pending 30 1 Resolved 48 ...