How to insert multiple records in sql server 2008

        By using Insert statement we can insert multiple records

at a time in a single query in sql server 2008.In the i am 

creating a table with the name sample and insert the three records

in a single statement.

      Create TABLE sample 

        (
          ID INT NOT NULL PRIMARY KEY,
          Name VARCHAR(100) NOT NULL

        )

Inserting the Multiple Records bu using single statement :

      INSERT INTO sample (ID, Name)
        VALUES (2415, 'rajesh'), 

        (1402, 'kumar'), 

       (1432, 'happy')