How can I insert string value including single quote into a string type table column?

please see this

Put quite simply:

SELECT 'This is Ashok''s Pen.';

So inside the string, replace each single quote with two of them.

Or:

SELECT 'This is Ashok\'s Pen.'

Hi,

It is never a good practice to insert Single Quote " ' " with your data in database as it leads to SQL Injections.

Anyway if you still want to do it....can check below

insert into your_Table (your_col) values ('he''s')

As per your comments check below

DECLARE @strVar VARCHAR(100)
SET @strVar='hi''s'
print(@strVar)

Hope this will be helpful to you.





Cheers.

use \ before sting value where you want to insert single quote

i.e. string name = " ABC \'XYZ\'";

sample example

string connectionString; 
            connectionString   =  "Data Source=USER\\SQLEXPRESS;Initial Catalog=db;Integrated Security=SSPI;";
            SqlConnection conn = new SqlConnection(connectionString);
            conn.Open();
            SqlCommand cmd = new SqlCommand("INSERT INTO [Employee]([Name],[EmployeeDepartment])VALUES (@Name,@EmployeeDepartment) ", conn);
            cmd.CommandType = CommandType.Text;
            cmd.Parameters.Add("@Name", SqlDbType.VarChar, 500).Value = "ABC \'XYZ\'";
            cmd.Parameters.Add("@EmployeeDepartment", SqlDbType.VarChar, 50).Value = "Dept";
            cmd.ExecuteNonQuery();
            conn.Close();

SQL Query that you can fire from SSMS

INSERT INTO [Employee]
           ([Name]
           ,[EmployeeDepartment])
     VALUES
           ('ABC ''XYZ'''
           ,'dept'
           )