How to fetch primary key after an insert command? (MS SQL 2005 Express)

[koalinho]

Hi

I am a novice in MS SQL 2005 Express and would like to know how to fetch a primary key after an insert command. I have used MYSQL and there you have a command that covers this function. I am using C# and ASP.NET 2.0.
Is there something similar in MSSQL?

Thanks for you reply.

Regards
Arno

[kestrel]

Please do not post questions in the Articles Section. I have moved this to the Forum.

--
Kestrel

[Motoma]

Hi

I am a novice in MS SQL 2005 Express and would like to know how to fetch a primary key after an insert command. I have used MYSQL and there you have a command that covers this function. I am using C# and ASP.NET 2.0.
Is there something similar in MSSQL?

Thanks for you reply.

Regards
Arno

Please take a look at this link and come back if you have any more questions.

[patelaashish]

Hi

I am a novice in MS SQL 2005 Express and would like to know how to fetch a primary key after an insert command. I have used MYSQL and there you have a command that covers this function. I am using C# and ASP.NET 2.0.
Is there something similar in MSSQL?

Thanks for you reply.

Regards
Arno

Hi,

I assume you want the last insert record ( primary key) ?

Let me know and I will help you with the code?

Cheers.

[patelaashish]

Hi,

I assume you want the last insert record ( primary key) ?

Let me know and I will help you with the code?

Cheers.

Please find below the code to find the last inserted record:


CREATE PROCEDURE name
(
@ID int OUTPUT
)
AS
INSERT INTO Table1
(DateCreated)
VALUES
( GETDATE() )
SET @ID = SCOPE_IDENTITY()
;