Mar 24, 2014

Query not allowed in Waitfor sql server


If we will execute following sql query in sql server:

WAITFOR (SELECT GETDATE())

We will get error message:

Query not allowed in Waitfor Sql server.

Cause: We cannot write query in WAITFOR. It is syntax error

Solution:

Valid syntax is:

1. WAITFOR DELAY '2:40'
2. WAITFOR TIME '5:30'

No comments:

Post a Comment