Al Programming
Free source code programming in C#, VB.Net, Java, SQL
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
)
Newer Post
Older Post
Home