Can I use the following with ExecuteScalar?

[RA]

Hi

I have the following sql:

sql = "INSERT INTO Customers (FirstName, LastName) VALUES ('New', 'test');
SELECT id FROM Customers WHERE (id = SCOPE_IDENTITY())"

myCommand.CommandText (sql, cn);
Can I use it with ExecuteScalar and by that I will get the new id(Identity)
column value?

object id = cmdsql.ExecuteScalar ();



Thanks,
Ronen

 

[Miha Markic]

Hi,

Yes.

 

[Miha Markic]

Ah, btw, you might replace "SELECT id FROM Customers WHERE (id =
SCOPE_IDENTITY())" with "SELECT SCOPE_IDENTITY"