search

cretz / node-tds

Pure JS implementation of TDS protocol for Microsoft SQL Server
http://cretz.github.com/node-tds
MIT License
104 stars 23 forks source link

Multiple rows with single insert #26

Open gitfy opened 12 years ago

gitfy commented 12 years ago

Hi, I am trying to find a way to do parameterized insert of multiple records in a single insert call.

Is this even possible. How do i defined the parameters, should they like

INSERT INTO TABLE values (@column11, @column21, ..), (@column21, @column22...) and send the values to the paramters in { @column11, @column12, ..... }

or there is a better way of do it.

Any help is appreciated. Thanks.

cretz commented 12 years ago

Since this is simply a protocol to SQL Server, it only supports what a normal query supports.

Having said that, bulk inserts are on the menu