How to Insert multiple records in an insert statement in a single line..

 Posted by Self-Innovator on 2/20/2013 | Category: Sql Server Interview questions | Views: 4114 | Points: 40
Answer:

INSERT INTO tbl_Student(Name,Class)


SELECT 'Ali','IV Standard'

UNION ALL

SELECT 'John','V Standard'

UNION ALL

SELECT 'Abraham','X Standard'


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response

More Interview Questions by Self-Innovator