concatenation strings within a select statement

[junkmail]

can someone tell me the correct syntax for replacing the hard coded path and file name with a declared variable? I am assuming I have to build it by concatenation but the apostrophe's are throwing me off.



SELECT * into test FROM OPENROWSET('VFPOLEDB', 'c:\work\'; ' '; ' ', 'SELECT * FROM test.dbf')

 

[bborissov]

Double all apostrophes in the string:

DECLARE @Test varchar(300)
SET @Test = '  c:\Work\;'' '';'' ''    '

Borislav Borissov
VFP9 SP2, SQL Server

 

[markros]

You will have to execute it dynamically by building the whole string and then executing it execute(@SQL). You need to double every single quote.

PluralSight Learning Library