dynamic sql : insert literal (char or varchar)

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: John A Grandy (johnagrandy-at-yahoo-dot-com)
Date: 12/06/04 

Date: Sun, 5 Dec 2004 17:45:18 -0800

when building dynamic sql how to insert a literal for char or varchar type
column ?

declare @tablename varchar(100)
set @tablename = "mytable1"
declare @sql varchar(2000)
set @sql = 'select LicenseNumber from ' + @tablename + ' where col1 =
'value1''
exec(@sql)

the above doesn't work .....

neither does the following ...

declare @tablename varchar(100)
set @tablename = "mytable1"
declare @sql varchar(2000)
set @sql = 'select LicenseNumber from ' + @tablename + ' where col1 =
''value1'''
exec(@sql)

Relevant Pages