create proc 过程名
@条件 varchar(8000)
as
exec('select fld1,fld2,fld3,fld4, ... from table1 where '+@条件+fld1 in (SELECT fld1 From table2 where '+@条件)
@条件 varchar(8000)
as
exec('select fld1,fld2,fld3,fld4, ... from table1 where '+@条件+fld1 in (SELECT fld1 From table2 where '+@条件)
@条件 varchar(8000)
as
exec('select fld1,fld2,fld3,fld4, ... from table1 where '+@条件+' fld1 in (SELECT fld1 From table2 where '+@条件)
@条件 text
as
exec('select fld1,fld2,fld3,fld4, ... from table1 where '+@条件+' fld1 in (SELECT fld1 From table2 where '+@条件)
结账。