Question

数据库sql Server2000 如何得到刚插入数据自动生成的ID?

请用存储过程!!! 如何得到返回结果,是否跟接收Select 语句一样?

ALTER PROCEDURE dbo.G_Account_Add_123

(
@Account_DayTime datetime,
@Account_Class varchar(50),
@Account_Over varchar(50),
@Remark varchar(5000)
--@Account_ID int output
)

AS
INSERT INTO Account
(Account_DayTime, Account_Class, Account_Over, Remark)
VALUES (@Account_DayTime, @Account_Class, @Account_Over, @Remark)

--set @Account_ID=(select Account_ID from inserted)
select @@identity

RETURN

这个正确吗?

Answer 1

正确，没问题。@@identity就是新插入的自增长ID

Answer 2

没什么技术。就是简单的调用按个数据库连接。