Getting the PK back from an insert sql statement, how?

[Bob]

Using sql 2005 and Vs2005 , snippet below.

Dim Conn As New SqlConnection(M y.Settings.Conn ectionString.To String)

Dim cmd As New SqlCommand

Dim MYPK as long

Conn.Open()

cmd.Connection = Conn

cmd.CommandText = "Insert Into Mytable (Field1,Field2)
Values('Value1' ,'Value2')"

"When executed, this inserts only one new row. How can I get the primary key
of that new record back into variable MYPK

Any help appreciated,

Bob

[Cor Ligthert [MVP]]

Re: Getting the PK back from an insert sql statement, how?

Bob,

Have a look at scope_identity

http://msdn.microsoft.com/library/en-us/tsqlref/ts_sa-ses_6n8p.asp

I hope this helps,

Cor

[Peter Huang [MSFT]]

RE: Getting the PK back from an insert sql statement, how?

Hi Bob,

Here is link for your reference.
320141 HOW TO: Retrieve an Identity Value from a Newly Inserted Record from
SQL

http://support.microsoft.com/?id=320141

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.