Search This Blog

Tuesday, March 26, 2013

Insert multiple rows WITHOUT repeating INSERT INTO SQL Server

SQL Server > Scripts > Insert multiple rows

create table #user(id int, superiorid int)
insert into #user(id, superiorid) values  (1,null), (2,1) , (3,1)