欧美极品高清xxxxhd,国产日产欧美最新,无码AV国产东京热AV无码,国产精品人与动性XXX,国产传媒亚洲综合一区二区,四库影院永久国产精品,毛片免费免费高清视频,福利所导航夜趣136

標(biāo)題: 程序人生 —— SQL Server函數(shù)小記 [打印本頁(yè)]

作者: hongniu 時(shí)間: 2015-6-25 15:16
標(biāo)題: 程序人生 —— SQL Server函數(shù)小記
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('入庫(kù)貨位1,出庫(kù)貨位1,入庫(kù)貨位2,出庫(kù)貨位2,', 1, 2, '123')

3、數(shù)據(jù)分頁(yè)(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

待續(xù)...

歡迎光臨 (http://m.raoushi.com/bbs/)