摘要:
1.显示1~12个月月份信息 select lpad(level,2,0) from dual connect by level<13; 2.获取某个时间段之间的月份列表(示例返回2009-03到2010-03之间的月份列表) SELECT TO_CHAR(ADD_MONTHS(TO_DATE('2 阅读全文
摘要:
一.SQL Server 经验 1.一个简单的存储过程 CREATE PROCEDURE [dbo].[usp_GetFolderID](@itemID INT, @folderID INT OUTPUT) AS BEGIN TRY SELECT @folderID = FOLDERID FROM 阅读全文