--khlx是数值型
exec('select count(*) from tab_kh where khlx='+@lxbh+' or '+@lxbh+'=''all''')
--khlx是字符型
exec('select count(*) from tab_kh where khlx='''+@lxbh+''' or '+@lxbh+'=''all''')
exec('select count(*) from tab_kh where khlx='+@lxbh+' or '+@lxbh+'=''all''')
--khlx是字符型
exec('select count(*) from tab_kh where khlx='''+@lxbh+''' or '+@lxbh+'=''all''')
declare @sql varchar(100)
set @sql='select count(*) from tab_kh where khlx='+cast(@lxbh as varchar)+' or ['+cast(@lxbh as varchar)+']=''all'''
exec(@sql)