<div>
Also, the above usually means that if you're INSERTing using a SELECT that you'll need to use REPLACE to convert to double-quotes for the insert..
<pre><code id="code-20-39563030-1">CREATE TABLE #t1 (name varchar(25))
CREATE TABLE #t2 (name varchar(25))

INSERT INTO #t1 (name) VALUES ('Charley O''Brien') 
INSERT INTO #t2 (name) SELECT REPLACE(name, '', '''') FROM #t1

SELECT * FROM #t1
SELECT * FROM #t2</code></pre>
</div>


Also, the above usually means that if you're INSERTing using a SELECT that you'll need to use REPLACE to convert to double-quotes for the insert..

CREATE TABLE #t1 (name varchar(25))
CREATE TABLE #t2 (name varchar(25))

INSERT INTO #t1 (name) VALUES ('Charley O''Brien') 
INSERT INTO #t2 (name) SELECT REPLACE(name, '', '''') FROM #t1

SELECT * FROM #t1
SELECT * FROM #t2

<div>
Thanks Jim. &nbsp;Actually, this is a MySQL script that I am trying to convert to T-SQL so it has a few unfamiliar things in it. &nbsp;The backslash seems to be the escape character for MySQL. &nbsp;Let me try your suggestions and get back.<br />
<br />
Sandra
</div>


Thanks Jim.  Actually, this is a MySQL script that I am trying to convert to T-SQL so it has a few unfamiliar things in it.  The backslash seems to be the escape character for MySQL.  Let me try your suggestions and get back.

Sandra

<div>
Thanks for the grade. &nbsp;Good luck with your code. &nbsp;-Jim
</div>


Thanks for the grade.  Good luck with your code.  -Jim

<div>
<div class="content wysiwyg-content">
I am inserting data via &nbsp;script but how do I keep the apostrophe intact? &nbsp;The &quot;\&quot; escape does not work.<br />
<br />
INSERT INTO Track (TrackID, AlbumID, Title, TrackNumber, Duration) VALUES (24,12,'You Won\'t See Me',3,202);<br />
<br />
Sandra
</div>
</div>


I am inserting data via  script but how do I keep the apostrophe intact?  The "\" escape does not work.

INSERT INTO Track (TrackID, AlbumID, Title, TrackNumber, Duration) VALUES (24,12,'You Won\'t See Me',3,202);

Sandra

Keep the apostrophe intact in an INSERTstatement SQL T-SQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.