将刚插入的记录的自增Id,插入到另一个字段中

方法一：

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)ASBEGIN   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