表变量

数据库中表变量与临时表的优缺点
数据库

数据库中表变量与临时表的优缺点

256 0

--表变量:DECLARE @tb table(id int identity(1,1), name varchar(100)) INSERT @tb SELECT id, name FROM mytable WHERE name like ‘zhang%’ --临时表: SELECT name, address INTO #ta FROM mytable WHERE name like ‘zhang%’(if exists (select * from…