Multiple rows with single insert #26

Open
gitfy opened this Issue May 10, 2012 · 1 comment

2 participants

@gitfy

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
Owner

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment