Inserting info in a table

[John]

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

[Cor Ligthert [MVP]]

John,

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?

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

[Cerebrus]

>> what is the best (in terms of being simplest/most straightforward) method

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

[OHM \( One Handed Man \)]

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

--
( OHM ) - One Handed Man
AKA Terry Burns - http://TrainingOn.net

"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:OZ**************@TK2MSFTNGP03.phx.gbl...

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

[Russell]

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.

[OHM \( One Handed Man \)]

Absolutely, good point !

--
( OHM ) - One Handed Man
AKA Terry Burns - http://TrainingOn.net
"Russell" <ru*****@goisc.com> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...

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.