Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using quotes in a string
Message
 
 
To
18/10/2012 11:26:33
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01555242
Message ID:
01555243
Views:
47
You have to double single quotes inside a string literal

>
>I need to put
>
>Bulk Insert qryICECLImport from @FileName with (FieldTerminator = ',' , RowTerminator = '/n')
>
>
>into a string - or at least I'm assuming I need to because SQL is not liking the parameterized file name, it's got the red squiggly line and says 'expecting INTEGER, STRING...' and perhaps that's what I should be asking about - but anyway would someone please remind me how to have quote marks within quote marks. I'm really missing being able to use single quotes (') AND double quotes (")
>
>Thanks
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform