Hi
Can anyone tell me How to write optimized Insert Query(Used for Inline Query not stored procedure)?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
SenthilkumarPosted Dec 12, 2011, 11:31 PM
If you use the sql server 2008 then you can use the following.
INSERT INTO MyTable (FirstCol, SecondCol)
VALUES ('First',1),
('Second',2),('Third',3),('Fourth',4),('Fifth',5)