SQL SERVER – How to insert a string value with an apostrophe (single quote) in a column
How to insert a string value with an apostrophe (single quote) in a column is a general problem? Mostly, it happens when you insert any name with apostrophe. . Lets now resolve it step by step. Step 1 :Create a sample table. 12345678 USE tempdbGOCREATE TABLE tbl_sample( [ID] INT, [Name] VARCHAR(50))GO Step 2 :Insert the name with…