表变量自动增加字段、主键的定义+exists使用例子

--表变量定义自动增加字段，定义主键

DECLARE @tmp2 table(id int IDENTITY(1,1),id2 int primary key(id))insert into @tmp2(id2) select top 100 id from book order by idselect * from @tmp2 order by id

--指定一个子查询，测试行是否存在

select t.id from book t where exists(select 1 from @tmp2 where id2=t.id )