Hi

I have a set of values that I need to insert and sql server table. My
question is, out of all the methods what is the best (in terms of being
simplest/most straightforward) method to do that?

Thanks

Regards

John,

Assuming you want to do this with a .Net program.

Create a Transact SQL insert string and process that with execute.nonquery

I hope this helps,

Cor

Depends on what you find the simplest. Maybe you could enter the data
in manually ! What could be simpler ! ;-)

The most basic syntax is


INSERT INTO tableName VALUES( value1, value2  . . . . .  )

Things to bear in mind about using this approach.

1.) Your values MUST be in sequence with the table design
2.) If ANY of your values include single quotes ' then your statement will
fail.

Using Parameters if more time consuming, but far less prone to error

Show quoteHide quote

Parameters will also prevent any possible "Sql Injection"attack, as
something that would be an executable statement if inlined is simply
text if it's a parameter value.

Absolutely, good point !

Show quoteHide quote

DBConcurrencyException on dataset update (because of datetime primary key ?)
escaping special operators, ', etc.
HOWTO: List SQL Servers on Local Machine
Re: Efficient data retrieval techniques
Does one know how to bind a BindingDataSource with designer ?