use ysxt_data
declare @lbname char(20),@zsbz char(4)set @lbname='T2002_yszb'
set @zsbz='预览'exec('delete from '+rtrim(@lbname)+' where zsbz='''+rtrim(@zsbz))+''''
declare @lbname char(20),@zsbz char(4)set @lbname='T2002_yszb'
set @zsbz='预览'exec('delete from '+rtrim(@lbname)+' where zsbz='''+rtrim(@zsbz))+''''
declare @lbname varchar(20),@zsbz varchar(4),@sqlstr varchar(8000)set @lbname='T2002_yszb'
set @zsbz='预览'
set @sqlstr='delete from '+rtrim(@lbname)+' where zsbz='''+rtrim(@zsbz))+''''exec(@sqlstr)