Sqlserver
Bing_Q
这个作者很懒,什么都没留下…
展开
-
如何在sqlserver实现oracle中START WITH id = '' CONNECT BY PRIOR id=p_id语句
--oracle中的 START WITH id = '' CONNECT BY PRIOR id=p_id 如何在sqlserver中实现呢。最好的解决办法:WITH NODES AS ( SELECT * FROM DBO.T_ADMIN_RMS_CD C WHERE C.XH = '200909271033495d64880c587a4beda5bbac86fd92e原创 2015-05-12 10:16:34 · 1566 阅读 · 0 评论 -
sql server 实现lastIndexOf
sql server 实现lastIndexOflen(@WapImage)+1-charindex('.',reverse(@WapImage))原创 2015-05-12 10:22:25 · 622 阅读 · 0 评论 -
ROW_NUMBER()函数的用法
对无ID(或者ID不规则)的表进行分页操作,可以使用row_number()函数分页[code="sql"]WITH OrderedOrders AS(SELECT *,ROW_NUMBER() OVER (order by Number)as RowNumber FROM dbo.xfd ) SELECT * FROM OrderedOrders WHERE RowNumber ...原创 2011-05-24 10:25:25 · 116 阅读 · 0 评论 -
如何在sqlserver实现oracle中START WITH id = '' CONNECT BY PRIOR id=p_id语句
[code="sql"]--oracle中的 START WITH id = '' CONNECT BY PRIOR id=p_id 如何在sqlserver中实现呢。最好的解决办法:WITH NODES AS ( SELECT * FROM DBO.T_ADMIN_RMS_CD C WHERE C.XH = '200909271033495d64880c587a4be...原创 2011-08-11 17:17:25 · 230 阅读 · 0 评论 -
sql server 实现lastIndexOf
[code="sql"]sql server 实现lastIndexOflen(@WapImage)+1-charindex('.',reverse(@WapImage))[/code]原创 2014-05-26 15:00:40 · 589 阅读 · 0 评论 -
SqlServer实现oracle10g的 wmsys.wm_concat()
[code="sql"]-- 查询处理 --SQL2005中的方法2 create table tb(id int, value varchar(10))insert into tb values(1, 'aa')insert into tb values(1, 'bb')insert into tb values(2, 'aaa')insert into tb val...原创 2014-06-24 15:50:35 · 482 阅读 · 0 评论