declare @temp table ( id int , value numeric(10), )Insert into @temp select id,value from aaa where bbb = cccdelete @temp where @temp.id = dddd.aaa_id and dddd.eee = ffff--->這個語句不對
declare @temp(id int,value varchar(10)) --少写了字段类型Insert into @temp select id,value from aaa where bbb = cccdelete a from @temp a,dddd where a.id = dddd.aaa_id and dddd.eee = ffff
delete @temp from @temp as a,dddd as b where a.id = b.aaa_id and b.eee = ffff
( id int ,
value numeric(10),
)Insert into @temp select id,value from aaa where bbb = cccdelete @temp where @temp.id = dddd.aaa_id and dddd.eee = ffff--->這個語句不對