家有好男儿

SELECT CAST(DATEDIFF(MONTH, '2010-02-08', '2015-09-07') / 12 AS VARCHAR) + '年零' + CAST(DATEDIFF(MONTH, '2010-02-08', '2015-09-07') % ( DATEDIFF(MONTH, '2010-0...

DECLARE cur_RemoveHolidays cursor for SELECT ST_SUID,DT_ACCEPT_TIME,DT_FINISH_TIME FROM APPLY_INFO; --打开游标 open cur_RemoveHolidays DECLARE @ST_SUID VARCHAR(50) declare @St...

select * into A16T from A16 where 1=2; -- 复制表结构