[MSSQL]存储过程示例(拷贝数据表--游标使用--更新数据-日期函数的使用)

CREATE procedure UF_Po_ScheduleSp
as

declare @CurrDate NVARCHAR(10)
set @CurrDate=convert(varchar(10),getdate(),120)

/*
 * delete today
 */
delete
from Uf_Po_Schedule
where convert(varchar(10),schedule_date,120)=@CurrDate

-- and item='LW-01000080'
/*
 *  拷贝计划明细表数据到Uf_Po_Schedule
 */
--SET FORCEPLAN OFF

insert  Uf_Po_Schedule(
            schedule_date
            ,item
            ,due_date
            ,ExceptMessage