Please help. I need to write a stored procedure that adds a record to a
table and returns the value of the ID Column.

Thanks,

Keith

Does the ID column have the identity property? If so:

USE tempdb
CREATE TABLE a(c1 int identity, c2 int)
GO
CREATE PROC p @val int, @myId int OUTPUT
AS
SET NOCOUNT ON
INSERT INTO a(c2) VALUES(@val)
SET @myId = SCOPE_IDENTITY()
GO
DECLARE @theId int
EXEC p @val = 23, @myId = @theId OUTPUT
PRINT @theId


--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/


[quoted text, click to view]