存储过程-基础用法

--创建存储过程

create procedure [dbo].[updateMuLuBeiZu]

 AS

 Declare @archgid VARCHAR(1000),

  @bz VARCHAR(max),

  @strSql nvarchar(max)

 begin

 Declare curStudentFee Cursor for

 select archgid,bz from ARCH where BZ is not null and BZ <>''

 Open curStudentFee

 Fetch Next From curStudentFee into  @archgid,@bz;

 while(@@FETCH_STATUS=0)

 begin

 set @strSql='update CASE set BZ='''+@bz+''''+'where ID0 = (select top 1 ID0 from CASE t where t.ARCHGID='''+@archgid+''''+' order by t.INDEXID desc)'

 exec

 (@strSql)

 Fetch Next From curStudentFee into  @archgid,@bz;

 end

 Close curStudentFee

 Deallocate curStudentFee;

 end

GO 

--执行存储过程

exec updateMuLuBeiZu ;

--删除存储过程

drop procedure updateMuLuBeiZu;