SQL-question

[RTT]

i have a script that insert a variable amount of rows in a table. each row
is identified by an autonumber by SQL

how can i find out the number of the newly added rows without having to much
troubles?

 

[Peter Proost]

I'm not sure but I think you can use a sql command and then use it's
ExecuteNonQuery method It should return the number of rows affected

hth greetz Peter

 

[Guest]

Hello,

If you need to get back the last autonumber value of the last record that
has been entered then I would suggest you have a read of this article:

http://msdn.microsoft.com/library/d...cpconRetrievingIdentityOrAutonumberValues.asp

Hope this is of some help?

Thanks

Kevin

 

[Peter Proost]

Hi

I misread the question so my solution won't help you out sorry, but Kevin's
link probably will

Greetz Peter

 

[RTT]

thxs, i still have to tweak it some more so it fits my needs perfectaly but
is does the trick.. thxs

 

[Cor Ligthert]

RTT

A command.executescalar with an SQL string for @@identity gives you the last
inserted identity.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_globals_50u1.asp

I hope this helps,

Cor

 

[Veign]

In what language? How did you add the record? What does this question have
to do with all the newsgroups you posted to?

You have posted this question to both VB and DotNet newsgroups..

Check out the @@Identity statement