Multiple Insertion into a table [Resolved]

Thank youu..

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

if you want to insert multiple row at a time from .Net,

Then Use
Bulkinsert in ADO.Net

Ajay
ajaypatelfromsanthal.blogspot.in

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Thanks

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Ok..Thank youu

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Ok..Thank you

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

its not working...........

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://www.aspnetcodes.com/

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Ok..

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Thank youu...
Using this query i inserted multiple rows at a time..

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

create table employee(empname varchar(90),empaddress varchar(90))

insert into employee values('test'),('test1')


hope this will help regards

sriram

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Thank youu

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Yes..That code is working fine..

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

I m getting Error--


Incorrect syntax near ','.

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://www.aspnetcodes.com/

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Hi sandeep,

please check your code. i have work correctly..please use CGN007 code..

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Table creation Script


create table EmployeeMas
(Firstname varchar(10),
Lastname varchar(10),
sal float,
Department varchar(10)
)
While inserting multiple it gives error..


insert into EmployeeMas values('Raj','aaa',5000,'ERP'),('Ram','bbb',4000,'ERP'),('Sachin','ccc',5000,'MED'),('Rahul','ddd',8000,'MED')

it works fine if i insert single record

insert into EmployeeMas values('Raj','aaa',5000,'ERP')

Error

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ','.

Sql serserver 2005

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://www.aspnetcodes.com/

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Hi sandeep,
Are u Ok now?Did u get result?

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator

Yes Union all worked...

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://www.aspnetcodes.com/

Muhsinathk, if this helps please login to Mark As Answer. | Alert Moderator