Thursday, 2 March 2017

How to insert values with single quote into tables in sql server?

I have used these identifiers in my proc. But still it fails while inserting any value that contains single quote in it. Can any one help



SET ANSI_NULLS ON;

GO
SET QUOTED_IDENTIFIER ON;
GO
-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

c++ - Does curly brackets matter for empty constructor?

Those brackets declare an empty, inline constructor. In that case, with them, the constructor does exist, it merely does nothing more than t...