I had a chance to execute dynamic query in sql server.
1. Declared a variable
2. Assign a query to the variable inside single quotes
3. Execute the variable.
On executing the statements, I got a strange query "Could not find stored procedure 'variable string' ". I am bit worried to see this error.
Solution:
Execute statement should have variable inside the brackets .
Why microsoft have given such a strange error message. They are not specifying the error message properly. Let me post this to Microsoft.
Thanks and Regards,
Venkatesan Prabu .J
No comments:
Post a Comment