请问一下如何合并where子句中的条件?
例如:
declare @lc_where varchar(255),@ln_clinetid int
select ........ where '[email protected]_clientid '[email protected]_where
???
上述的语句报错
求助!!
------解决方案--------------------
declare @lc_where varchar(255),@ln_clinetid int
declare @sql varchar(8000)
set @sql= 'select ........ where goodlist.clientid= '+cast(@ln_clientid as varchar)[email protected]_where
exec (@sql)