![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
j805440805
kdfsdk
展开
-
sql计算两个时间月份之差
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].GetMonth') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))DROP FUNCTION [dbo].GetMonthGOcreate function GetMonth (@stad原创 2013-11-06 17:21:40 · 5112 阅读 · 0 评论 -
sql 序号生成方法
rank() 与dense_rank()分析 1.rank()分析函数语法:RANK() OVER([PARTITION BY expr1[,expr2,..,exprn]] ORDER BY expr1[,expr2,..,exprn]) 功能:转载 2013-11-06 17:25:58 · 917 阅读 · 0 评论