34,590
社区成员
发帖
与我相关
我的任务
分享
--try
ident_current('Class')+ident_incr('Class')
insert into Tablec select 'aa',1,@@identity+1
CREATE TABLE [dbo].[Class] (
[ClassID] [int] IDENTITY (1, 1) NOT NULL ,
[ClassName] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
[ClassType] [int] NULL ,
[ClassParentID] AS ([classid])
) ON [PRIMARY]
insert into class(className,classtype) values( 'test ', 'a')
insert into class(className,classtype,classparentID)
values('test', 1,isnull(@@identity+1,1))
CREATE TABLE Class(
[ClassID] [int] IDENTITY (1, 1) NOT NULL ,
[ClassName] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
[ClassType] [int] NULL ,
[ClassParentID] AS ClassID );