Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using quotes in a string
Message
From
18/10/2012 11:26:33
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Using quotes in a string
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01555242
Message ID:
01555242
Views:
63
Hi all

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
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Next
Reply
Map
View

Click here to load this message in the networking platform