if you are using parameter approach, you can use SqlDbType.NText, for example SqlCommand objCom = new SqlCommand(); .... objCom.Parameters.Add( new SqlParameter( "@empdata", System.Data.SqlDbType.NText)); objCom.Parameters["@empdata"].Value = "YourStringHere..."; objCom.ExecuteNonQuery();
....
objCom.Parameters.Add( new SqlParameter( "@empdata",
System.Data.SqlDbType.NText));
objCom.Parameters["@empdata"].Value = "YourStringHere...";
objCom.ExecuteNonQuery();