declare @tbl table(bianmaint int,kucunliang varchar(20))
declare @date datetime
set @date='2005-8-14'
insert into @tbl
select bianma,kucunliang
from shouhuoku where shdate>=@date
declare @date datetime
set @date='2005-8-14'
insert into @tbl
select bianma,kucunliang
from shouhuoku where shdate>=@date
select @tbName='kucunmingxiku',
@dt='2005-08-14'
set @sql=' delete '+@tbName+
' insert into '+@tbName+
' (bianma,kucunliang) '+
'select bianma,kucunliang from shouhuoku where shdate>=cast('''+@dt+''' as datetime)'
exec(@sql)