Showing posts with label insert multiple rows sql server 2008. Show all posts
Showing posts with label insert multiple rows sql server 2008. Show all posts

Friday, March 8, 2013

insert multiple rows sql server 2008



For inserting multiple rows using one insert statement you can do as following example :
declare @dept table
 (
   DeptId int identity(1,1) not null,
   DeptName nvarchar(500)
 )

 insert into @dept values ('sales'),('marketting'),('hr'),('IT')

 select * from @dept 

SQL fiddle can be check here  

.net core advance

 Dependency Injection (DI) is a fundamental concept in .NET Core that facilitates loose coupling between components in an application by all...