文件名称：插入费用存储过程的实现方式
文件大小：11KB
文件格式：SQL
更新时间：2013-07-17 06:32:48
一个存储过程
--feiyongz '1025','038',3000,'2009-12-26 00:00:00.000','2011-12-25 00:00:00.000','1','',2,100,'','','1' --select * from daoruyou where js_bill='0011001210000652' --update bilvendjsm set yearmonth='2010-04' where yearmonth is null --select stdate,datediff(day,stdate,'2009.09.20') ,dateadd(day,20,stdate),dateadd(month,1,stdate),convert(varchar(7),dateadd(day,20,stdate) ,120) from BASVENDFYDA --select @startdate,@enddate,datediff(day,convert(varchar(7),@startdate,102)+'.'+'21',convert(varchar(7),dateadd(day,20,@startdate) ,120)+'.'+'20')+1 as '本月天数',datediff(day,@startdate,convert(varchar(7),@startdate,102)+'.'+'21') as '开始月20天数差' ,datediff(day,convert(varchar(7),@enddate,102)+'.'+'20',@enddate),convert(varchar(7),@startdate,102) ,datediff(day,@enddate,'2009.09.20'),dateadd(day,20,@enddate),dateadd(month,1,@enddate),convert(varchar(7),dateadd(day,20,@enddate) ,120) from BASVENDCON --datediff(day,'2010.01.16','2010-01.20') --select datediff(day,'2009.09.26','2009.10.20')+1 =30/30*25 --select datediff(day,'2010.10.21','2010.10.25')+1 =30/30*5 --select * from basvendfyddtla where vendcode='1025' --select * from BASVENDFYDA where vendcode='1025' --delete from basvendfyddtla where vendcode='1025' --delete from BASVENDFYDA where vendcode='1025' --select * from tbapptable where tablecaption like '%费%'