![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL Server
SmartEmotion
这个作者很懒,什么都没留下…
展开
-
SQL Server比较数值大小
Create function f_GetMaxCyrs(@rs1 int,@rs2 int ,@rs3 int ,@rs4 int) returns intasbegin declare @rstmp int if @rs1 >= @rs2 set @rstmp = @rs1 else set @rstmp = @rs2 if @rstmp >= @rs3 s原创 2013-04-25 15:51:02 · 8228 阅读 · 0 评论 -
得到汉字的拼音码
Create function f_GetPy(@str nvarchar(4000)) returns nvarchar(4000) as begin declare @strlen int,@re nvarchar(4000) declare @t table(chr nchar(1) collate Chinese_PRC原创 2013-04-25 15:54:28 · 625 阅读 · 0 评论 -
SQL Server查重
select dwbh,count(dwbh) as bhsl from t_bzjhzb where jynd = '2011'group by dwbh having count(dwbh) > 1原创 2013-04-25 16:02:00 · 9173 阅读 · 0 评论