文章分类 -  数据库

摘要：众所周知 Vaules 用于插入数据declare @t table (id int , col1 int, col2 int, col3 int)insert into @t values(1, 14, 12, 24) select * from @t1. 用Values插入多行,如:declare @t table (id int , col1 int, col2 int, col3 int)insert into @tvalues(1, 14, 12, 24),(2, 55, 31, 122),(3, 121, 50, 28)select * from @t2. 用Values模拟表变量 阅读全文