27,579
社区成员
发帖
与我相关
我的任务
分享
insert into OrgInfo values('OOXX')select @@identity
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[OrgInfo]') AND type in (N'U'))
DROP TABLE OrgInfo
CREATE TABLE [dbo].[OrgInfo](
[OrgId] [int] IDENTITY(1,1) NOT NULL,
[OrgName] [varchar](50) Not NULL,
)
SELECT * FROM OrgInfo
INSERT INTO OrgInfo(OrgName) VALUES ('OOXX') SELECT @@IDENTITY
SELECT * FROM OrgInfo
DECLARE @t TABLE (id int)
INSERT INTO tableName (fieldList ...)
OUTPUT INSERTED.id INTO @t
values (valueList ...)
SELECT * FROM @t
INSERT INTO tableName (fieldList ...) values (valueList ...) select inserted.OrgId
INSERT INTO tableName(OrgName)
values('OOXX')
SELECT SCOPE_IDENTITY() AS aliasName --用SCOPE_IDENTITY(),返回当前作用域的所有表的identity值.最准确
--创建表
create table OrgInfo
(
OrgId int identity(1,1) primary key,
OrgName nvarchar(20)
)
--插入测试数据
insert into OrgInfo
select '张三' union select '李四' union select '王五'
select * from OrgInfo
/*
OrgId OrgName
----------- --------------------
1 李四
2 王五
3 张三
*/
--假设此时我们再插入一条,然后得到新插入的id
insert into OrgInfo select '刘六'
--得到新插入的id
select @@identity
/*
4
*/
--得到新插入的数据行
select * from OrgInfo where OrgId=@@identity
/*
OrgId OrgName
----------- --------------------
4 刘六
*/
insert into OrgInfo
select dbo.yourfunction(),'ooxx'
select @@indentity
insert into OrgInfo
select newid(),'ooxx'