哪里有存储过程的教程下载？解决办法

---------------添加的存储过程-- ===========================================-- Author:        <Author Name : Charry Chen>-- Create date: <Create Data : 2007-5-14>-- Description:    <Description : 添加科室信息>-- ===========================================ALTER PROCEDURE [dbo].[OfficeInfo_AddOfficeInfo](        @Office_Name nvarchar(50),        @Phone nvarchar(30),        @Position nvarchar(100),        @Director_Name nvarchar(50)        )ASbegin    INSERT INTO OfficeInfo    (        Office_Name,        Phone,        Position,        Director_Name    )    VALUES    (        @Office_Name,        @Phone,        @Position,        @Director_Name    )End-----------------------更新的存储过程-- =============================================-- Author:        <Author Name : Charry Chen>-- Create date: <Create Data : 2007-5-14>-- Description:    <Description : 更新科室信息>-- =============================================ALTER PROCEDURE [dbo].[OfficeInfo_UpdateOfficeInfo](        @Office_ID int,        @Office_Name nvarchar(50),        @Phone nvarchar(30),        @Position nvarchar(100),        @Director_Name nvarchar(50)        )ASBEGIN    update OfficeInfo     set        Office_Name = @Office_Name ,        Phone = @Phone,        Position = @Position,        Director_Name = @Director_Name    where Office_ID= @Office_IDEND-- =============================================-- Author:        Marry-- Create date: 2007-02-14-- Description:    Add or Update Larger=-- ================================================ 更新或删除ALTER PROCEDURE [dbo].[mis_SystemSetup_AddorUpDateLargerUpload]     @radix    Int,    @taskNum  Int,    @PRI      Nvarchar(50),    @dateTime DatetimeASBEGINSELECT *FROM   FtpSecondUpLoadMaintenanceIF     @@Rowcount < = 0INSERT INTO FtpSecondUpLoadMaintenance(    radix,    taskNum,    PRI,    dateTime)VALUES(    @radix,   @taskNum,   @PRI,         @dateTime)ELSE    UPDATE FtpSecondUpLoadMaintenance    SET         radix = @radix,        taskNum = @taskNum,        PRI= @PRI,         dateTime = @dateTimeEND--------------------------更新ALTER PROCEDURE [dbo].[mis_SystemSetup_DeleteTifFolderPathInfo]      @TifID    int,     @IsUsing        INT OUTPUTASSELECT Flag FROM   TifFolderPathWHERE  Flag = 0 And TifFolderPath_ID = @TifIDIF  @@Rowcount > 0UPDATE         TifFolderPathSET        InActive=0,        @IsUsing = 0WHERE        TifFolderPath_ID = @TifIDELSE     SET         @IsUsing = 1----删除的存储过程-- ==========================================-- Author:        <Author Name : Charry Chen>-- Create date: <Create Data : 2007-5-14>-- Description:    <Description : 删除科室信息>-- ==========================================ALTER PROCEDURE [dbo].[OfficeInfo_DelOfficeInfo](   @Office_ID int)ASBEGIN    DELETE From OfficeInfo     where Office_ID = @Office_ID  END----查找----排序-- ===========================================-- Author:        <Author Name : Charry Chen>-- Create date: <Create Data : 2007-5-14>-- Description:    <Description : 获得科室信息>-- ===========================================ALTER PROCEDURE [dbo].[OfficeInfo_GetAllOfficeInfo]ASBEGIN    SELECT Office_ID,Office_Name,Phone,Position,Director_Name from  OfficeInfo    order by Office_ID asc/descEND