CREATE TABLE STUDENT
(
Name varchar(50),
ID bigint,
EmailId varchar(50),
ContactInfo bigint,
Domain varchar(50)
)
Lets suppose i am declaring Domain as CS for Default.
I am now passing values using BULK INSERT Command
BULK INSERT STUDENT FROM (path of text file)
By bulk Insert I am getting data..But i want individual scripts for
Text file contains
Gaurav,231535,gaurav@xyz.com
Saurabh,235315,saurabh@xyz.com
I want individual scripts for Each row which should be created dynamically.