Insert Constructors in SQL SERVER 2005 and 2008
Dear Developer, Insert Constructors in SQL SERVER 2005 and 2008, This is new feature in 2005 and 2008. Which allow you pass multiple value statement into single insert Statement. SQL :- SET IDENTITY_INSERT [dbo].[mastAssociatedWith] ON INSERT INTO [dbo].[mastAssociatedWith] (ID,[AssociatedWith]) VALUES (12,'Albert Rajan'), (15 ,'Amol Koparde'), (1 ,'Cmk'), (10 ,'Diwali'), (4 ,'For'), (14 ,'K. P. Rajeev'), (9 ,'Mer'), (5 ,'Obom'), (7 ,'Per'), (11 ,'Rajesh Sharma'), (3 ,'Rsk'), (6 ,'Sfk'), (13 ,'Sushil Kasar'), (2 ,'Vsk') SET IDENTITY_INSERT [dbo].[mastAssociatedWith] OFF It has help me to perform task for import data from client database to my development database. I was given task to import client data into development database.Data was given in text file. I had multiple choose to import data into SQ...