一个简单的存储过程

我一般在进行数据库访问时都是调用存储过程来进行数据操作的，下面是一个最基本的存储过程书写方式。

alter procedure [dbo].[lsp_EditURL] as
    declare @typo varchar(255)
    declare @id int
    declare w_cursor CURSOR FOR
    select [id],[content] from dbo.doc where parent>0
    open w_cursor
    fetch NEXT fron w_cursor into @id,@typo
    while @@FETCH_STATUS = 0
    begin
        if CharIndex('smileyes/u/',@typo)>0
        begin
            update doc set [content]=replace(@typo,'smileyes/u/','smileyes/userphoto/') where id=@id
        end
    fetch NEXT from w_cursor into @id,@typo
    end
    close w_cursor
deallocate w_cursor

 

 调用的时候只需要  exec dbo.lsp_EditURL