关于exec变量嵌套单引号的问题

[michaelmodna]

declare @sql varchar(2000)

declare @condition varchar(200)

Set @condition = 'where smm_num >= "'+ 'S2010010' + '"'

select @condition

select   @sql   =   'select   top 100 *   from   sms_200912 ' + @condition

exec(@sql)

运行后出现如下错误 ：

Msg 207, Level 16, State 1, Line 1
Invalid column name 'S2010010'.

我在查询定义的条件变量里面用的是双引号，因为单引号我赋不进去值，请大家帮忙指点一上，谢谢！！

[快乐_石头]

declare @sql varchar(2000)

declare @condition varchar(200)

Set @condition = 'where smm_num >= ''S2010010'''

select @condition

select   @sql   =   'select   top 100 *   from   sms_200912 ' + @condition

exec( @sql)

[百年树人]

declare @sql varchar(2000)

declare @condition varchar(200)

Set @condition = 'where smm_num >= '+ '''S2010010'''

select @condition

select   @sql   =   'select   top 100 *   from   sms_200912 ' + @condition


exec(@sql)

[andysun88]

declare @sql varchar(2000)
set @sql=''
declare @condition varchar(200)

Set @condition = 'where smm_num >= ''S2010010'''

select   @sql  = 'select   top 100 *   from   sms_200912 ' + @condition

--print @sql
exec(@sql)

[yananguo_1985]

declare @sql varchar(2000)

declare @condition varchar(200)

Set @condition = 'where smm_num >='+ '''S2010010''' 

select @condition

select   @sql   =   'select   top 100 *   from   sms_200912 ' + @condition

exec(@sql)

[h821291419]

declare @sql varchar(2000)

declare @condition varchar(200)

Set @condition = 'where smm_num >= "'+ '''S2010010' + '''"'

select @condition

select   @sql   =   'select   top 100 *   from   sms_200912 ' + @condition

exec(@sql)