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: 5572 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

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

Bookmark It

< Previous : What is abstract method or abstract method is foun ...

Next > : How to Create object For Inner Class? or how to ac ...

Comments or Responses

More Interview Questions by Self-Innovator

Latest Interview Questions

How to Create object For Inner Class? or how to access inner class met ...
Which of the following statements are true about the C#.NET code snipp ...
What is MTOM?
Which message encoding format/s is/are available in WCF?
How will you create your aggregate function using PostgreSQL?
What is the purpose of USING Operator in the ORDER BY clause of Postgr ...
What is the purpose of Array_To_String in PostgreSQL?
What is the purpose of String_Agg function in PostgreSQL?
More ...