SELECT @@IDENTITY AS 'Identity'为什么返回的是NULL???
我在SQL里面执行下面的语句,每次都能正确插入,但是SELECT @@IDENTITY AS 'Identity'却返回的是NULL
请高手讲解一下为什么,谢谢!!
INSERT INTO Account (UserId,Email,FirstName,LastName,Addr1,City,State,zip,Country,phone)
VALUES ('2222','Accountant','12','aaaa','aa','a','dd','ddd','dd','sss')
SELECT @@IDENTITY AS 'Identity'