Get the last inserted index

See more:

SQL

Microsoft

I'm writing a MS SQL procedure that receives data, inserts it into a table, and then is supposed to retrieve the new index where the data was inserted. The only UNIQUE field is the ID, and I wouldn't like to count simply of the IDENTITY, because IDENTITY_INSERT Could mess things up... Is there anything safe that I could do?

That's what I was writing, is it any good?

CREATE PROCEDURE dbo.Func(@var text)
        AS
	BEGIN
	INSERT INTO Table (Col) VALUES(@var)
	SELECT TOP 1 TableID FROM Table ORDER BY TableID DESC
	RETURN TableID
	END