By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,843 Members | 2,300 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,843 IT Pros & Developers. It's quick & easy.

insert double quotes into sql server table

P: n/a
hi,
just wanted to know if i need to insert a string with double quotes in
it into a sql server table, do i need to use any delimeters, like \"?
an insert like:
insert into producttable values(key, "double quote text")

where i need the "double quote text" to go in like that, with the " "
at both ends.

Thank you.

Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
soni29 (so****@hotmail.com) writes:
just wanted to know if i need to insert a string with double quotes in
it into a sql server table, do i need to use any delimeters, like \"?
an insert like:
insert into producttable values(key, "double quote text")

where i need the "double quote text" to go in like that, with the " "
at both ends.


You double them.

This is a kind of information that you easily can find out by using the T-
SQL Reference in Books Online. By using this wealth of information, you
can get the answers to your questions quicker.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.