Sleep for 1 min in SQL SERVER 2005

We just want to delay our query for one min.

To achieve that one we need write the below script

print getdate()
waitfor delay '00:01'
print getdate()


Output:

Mar 19 2010  6:37PM
Mar 19 2010  6:38PM



Happy Querying