Click here to hide categories Click here to show left categories

User: Home          welcome : Guest          Log In / Register here     




Allow double quotes in Store procedures

To allow double quotes in store procedures, Below line need to put above the procedure.
SET QUOTED_IDENTIFIER Off
When SET QUOTED_IDENTIFIER is ON, identifiers can be delimited by double quotation marks, and literals must be delimited by single quotation marks. When SET QUOTED_IDENTIFIER is OFF, identifiers cannot be quoted and must follow all Transact-SQL rules for identifiers. By default It is On.

It may give error like Create or alter statement should be first statement

To remove this error, write go before Create or alter. Example shown below:
SET QUOTED_IDENTIFIER Off
go
CREATE PROCEDURE spMyProc
(
-- definition
)
Share this article   |    Print    |    Article read by 3083 times
Author:
Rohit kakria
I am software developer
Related Articles: No related article
Related Interview Questions: No related interview question