tag:blogger.com,1999:blog-2496415891665263000.post7476380156074465244..comments2023-10-12T13:08:57.828+02:00Comments on For the Love of Software: How to check query syntax programmaticallyHesham A. Aminhttp://www.blogger.com/profile/00063404912692423973noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-2496415891665263000.post-11574616867156423302012-02-15T10:40:56.990+02:002012-02-15T10:40:56.990+02:00ya...exactly..does it possible?ya...exactly..does it possible?nitinhttps://www.blogger.com/profile/07578841127147534740noreply@blogger.comtag:blogger.com,1999:blog-2496415891665263000.post-49683895647608323822012-02-15T09:42:59.248+02:002012-02-15T09:42:59.248+02:00@nitin: Do you want to make a stored procedure tha...@nitin: Do you want to make a stored procedure that checks the syntax of a query?Hesham A. Aminhttps://www.blogger.com/profile/00063404912692423973noreply@blogger.comtag:blogger.com,1999:blog-2496415891665263000.post-47858393250103156832012-02-14T09:16:01.953+02:002012-02-14T09:16:01.953+02:00hiiiiii
how can i use these commands in SP.
plz he...hiiiiii<br />how can i use these commands in SP.<br />plz help me.<br />thnx in adv.<br />i uses sql server 2005/nitinhttps://www.blogger.com/profile/07578841127147534740noreply@blogger.comtag:blogger.com,1999:blog-2496415891665263000.post-47942969102390629402008-12-30T14:18:00.000+02:002008-12-30T14:18:00.000+02:00Better would be to use SET NOEXEC ON as in below e...Better would be to use SET NOEXEC ON as in below example as it will validate objects also<BR/><BR/>SET NOEXEC ON<BR/>Go<BR/>Select * from dbo.Brooks<BR/>Go<BR/>SET NOEXEC OFFHrishikesh Desaihttps://www.blogger.com/profile/16690939953136090923noreply@blogger.com