Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to insert a field with a quote
Message
From
12/09/2008 14:17:52
 
 
To
12/09/2008 14:06:49
General information
Forum:
Microsoft SQL Server
Category:
Scripting
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01347154
Message ID:
01347172
Views:
18
>I have a script which insert some records in a table. In some of those values, I have a quote. However, the quote character is used as the field delimiter in the command line. How can I achieve that?

Just double them or use parameters to achieve this.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform