I'm trying to insert some text data into a table in SQL Server 9.
The text includes a single quote(').
How do I escape that?
I tried using two single quotes, but it threw me some errors.
insert into my_table values('hi, my name''s tim.');
If you are using SQL Server 2008, then following query will work well in your case:
DECLARE @My_Table TABLE ( [value] VARCHAR(200))INSERT INTO @My_Table VALUES ('Hi, My name''s Tim.')SELECT * FROM @My_Table
DECLARE @My_Table TABLE (
INSERT INTO @My_Table VALUES ('Hi, My name''s Tim.')
SELECT * FROM @My_Table
Hi, My name's Tim.
You can escape the single quote by doubling them up.
Certification in Digital Marketing |
Certification in Big Data Analytics |
Certification in Cloud & Devops |
Certification in Full Stack Web Development
Big Data and Data Science Master’s Course |
Data Science Architect Master’s Program |
Cloud and DevOps Architect Master’s Course |
Artificial Intelligence Engineer Master’s Course |
Microsoft Azure Certification Master’s Training
Data Science Course Online |
Big Data Hadoop Certification Training |
Machine Learning Course Online |
Artificial Intelligence Course and Training |
Salesforce Certification Training: Administrator and App Builder |
Tableau Training and Certification Course |
Python Data Science Course & Training |
Ethical Hacking Course |
Business Analyst Course |
Courses in Cyber Security
© COPYRIGHT 2011-2021 INTELLIPAAT.COM. ALL RIGHTS RESERVED.
Download Salary Trends Now !
Learn how professionals like you got up to 100% Salary Hike.