<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
i am trying to insert <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;INSERT INTO &nbsp;[CORRCE] ( &nbsp;[Year_Ref] , &nbsp;[Ref] &nbsp;,[Date] ,[SentTo] ) &nbsp; &nbsp; &nbsp;<br />
&nbsp; &nbsp; &nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; VALUES<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ('22' , '556' , '21 September 2016' , ' hotel 's b'a')<br />
<br />
Any suggestions?
</div>
</div>


Hello,

i am trying to insert 

	INSERT INTO  [CORRCE] (  [Year_Ref] ,  [Ref]  ,[Date] ,[SentTo] )      
     
	
	   VALUES
	 ('22' , '556' , '21 September 2016' , ' hotel 's b'a')

Any suggestions?

insert query with value having 's

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.