INSERT INTO [tabale1] ([col1] ,[col2] ,[col3] ,[col4]) (SELECT '11','1','1','1' UNION ALL SELECT '22','2','2','2')
Wednesday, February 17, 2010
Insert Multiple Rows to Table in SQL
Subscribe to:
Posts (Atom)
INSERT INTO [tabale1] ([col1] ,[col2] ,[col3] ,[col4]) (SELECT '11','1','1','1' UNION ALL SELECT '22','2','2','2')