Inserting Multiple values in SQL

Self-Innovator
Posted by Self-Innovator under Sql Server category on | Points: 40 | Views : 987
Inserting multiple records on a single statement
INSERT INTO TBL_REGISTRATIONS(NAME,EMAIL)
SELECT 'MOHAMMED','mohammed.mhd@gmail.com'
UNION ALL
SELECT 'AHMED','ahmed21@yahoo.com'
UNION ALL
SELECT 'JOHN','john.mathew@facebook.com'

Comments or Responses

Login to post response