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.
E&ICT MNIT - Data Science and Machine Learning |
IIT Madras - Advance Certification in Data Science and AI |
E&ICT IIT Guwahati - Cloud Computing & DevOps |
E&ICT IIT Guwahati - Cyber Security |
E&ICT IIT Guwahati - Software Engineering & Application Development |
E&ICT IIT Guwahati - Big Data Analytics |
E&ICT IIT Guwahati - Full Stack Web Development |
E&ICT MNIT - AI and Machine Learning |
E&ICT IIT Guwahati - UI UX Design Strategy |
IIT Madras - Data Analytics for Business |
E&ICT IIT Roorkee - Cloud Computing & DevOps |
E&ICT MNIT - Cyber Security & Ethical Hacking |
E&ICT MNIT - Business Analyst & Project Management
Big Data Analytics Courses |
Data Science Courses |
Business Intelligence courses |
Best Salesforce Courses |
Cloud Computing Courses |
Best Digital Marketing Courses |
Programming Courses Online |
Database Certification Courses |
Best Testing Courses |
Project Management Certification Courses |
Best Web Development Certification courses |
Automation Trainings |
Cyber Security Training Courses
Data Science Courses |
Best Artificial Certification Intelligence Course |
Machine Learning Training |
Python Course |
DevOps Certification Course |
AWS Training and Certification |
Azure Certification |
AWS DevOps Training |
Azure DevOps Certification Course |
Cyber Security Course |
CEH course |
Big Data Hadoop Certification |
SQL Online Course |
Salesforce Admin Certification |
Online Salesforce Developer Certification |
Selenium Training Online |
Business Analyst Course Online |
Data Analyst Certification course |
Best Microsoft Power BI Certification Course |
Tableau Course Online |
Linux certification Course |
Data Analytics Certification Course
MCA Degree Program |
MBA Degree Program |
MBA HR Degree Program |
MBA IT Degree Program |
MBA Finance Degree Program |
MBA General Degree Program |
MSC in Data Science
© COPYRIGHT 2011-2022 INTELLIPAAT.COM. ALL RIGHTS RESERVED.
Download Salary Trends Now !
Learn how professionals like you got up to 100% Salary Hike.