方法一:
insert grade3(grade1id,grade2id,grade3id,name,admin_pagename)
values('A1','B10','C'+ltrim(str(@@IDENTITY)),'标题','admin_new_l.aspx')
解释:grade3id='C'+ltrim(str(@@IDENTITY))
字符串'C'+ 刚插入的自增ID
方法二、
CREATE PROCEDURE [dbo].[PRO_InsertGrade3]
@grade2id varchar(10),
@name varchar(50),
@memo varchar(8000),
@memo1 varchar(200)
AS
BEGIN
insert grade3(grade1id,grade2id,grade3id,name,memo,memo1,admin_pagename)
values('A1',@grade2id,'C111111111',@name,@memo, @memo1,'admin_new_l.aspx');
update grade3 set grade3id='C'+ltrim(str(IDENT_CURRENT('grade3'))) where id=IDENT_CURRENT('grade3') ;
END