欧美极品高清xxxxhd,国产日产欧美最新,无码AV国产东京热AV无码,国产精品人与动性XXX,国产传媒亚洲综合一区二区,四库影院永久国产精品,毛片免费免费高清视频,福利所导航夜趣136
<noframes id="ciyg4"></noframes>
<noscript id="ciyg4"></noscript>
<em id="ciyg4"></em>
<sup id="ciyg4"><code id="ciyg4"></code></sup>
<strike id="ciyg4"></strike>
<code id="ciyg4"></code>
<bdo id="ciyg4"></bdo>
<samp id="ciyg4"><noframes id="ciyg4"></noframes></samp>
<strong id="ciyg4"><fieldset id="ciyg4"></fieldset></strong>
標題:
程序人生 —— SQL Server函數小記
[打印本頁]
作者:
hongniu
時間:
2015-6-25 15:16
標題:
程序人生 —— SQL Server函數小記
1、多行拼接成一列(FOR XML PATH)
DECLARE @t_Temp TABLE
(
id VARCHAR(100)
)
INSERT INTO @t_Temp VALUES ('ID1')
INSERT INTO @t_Temp VALUES ('ID2')
INSERT INTO @t_Temp VALUES ('ID3')
INSERT INTO @t_Temp VALUES ('ID4')
INSERT INTO @t_Temp VALUES ('ID5')
SELECT id + ','
FROM @t_Temp
FOR XML PATH('')
2、截取并插入新字符串(STUFF)
SELECT STUFF('入庫貨位1,出庫貨位1,入庫貨位2,出庫貨位2,', 1, 2, '123')
3、數據分頁(ROW_NUMBER())
DECLARE @t_Temp TABLE
(
id VARCHAR(100)
)
INSERT INTO @t_Temp VALUES ('ID1')
INSERT INTO @t_Temp VALUES ('ID2')
INSERT INTO @t_Temp VALUES ('ID3')
INSERT INTO @t_Temp VALUES ('ID4')
INSERT INTO @t_Temp VALUES ('ID5')
SElECT *
FROM (SELECT ROW_NUMBER() OVER(ORDER BY id) AS ROW,*
FROM @t_Temp) T WHERE T.ROW BETWEEN 1 AND 2
待續...
歡迎光臨 (http://www.raoushi.com/bbs/)
Powered by Discuz! X3.1
