问题:
有一表如下:
CREATE TABLE news (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[TITLE] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
当我用INSERT INTO NEWS(TITLE)VALEUS (‘SDFSDF’)新增数据时,用什么方法可以得到ID的值?
用SELECT ID FROM NEWS WHERE TITLE=‘SDFSDF’除外
解答:
緊接著就用
SELECT @@IDENTITY
或用
SELECT SCOPE_IDENTITY()
或用
SELECT IDENT_CURRENT('news')