Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gopi Sri T-SQL RE: T-SQL
Peter E. Kierstead
SSCarpal Tunnel
Points: 4114
More actions
March 24, 2011 at 1:00 pm
#1303177
Note:insert into #test values (2,'D'),('','E') is equal to insert into #test select 2,'D' union select '','E'
Note:
insert into #test values (2,'D'),('','E') is equal to insert into #test select 2,'D' union select '','E'
Actually, its like:
insert into #test values (2,'D'),('','E') is equal to insert into #test select 2,'D' union all select '','E'