sqlserver2000字段行转列

发布时间：2020-12-12 15:13:47 所属栏目：MsSql教程来源：网络整理

导读：----建表语句 IF object_id(' [tb] ') IS NOT NULL DROP TABLE [ tb ] CREATE TABLE [ tb ]([ sIDNo ] int, [ sAccount ] int) INSERT [ tb ] ????????????????? SELECT 1001,15451551 UNION ALL SELECT 1001,13151345 UNION ALL SELECT 1001,15484565 UNION

----建表语句

IF object_id('
[tb]
') IS NOT NULL DROP TABLE [
tb
] CREATE TABLE [
tb
]([
sIDNo
] int,
[
sAccount
] int) INSERT [
tb
]
????????????????? SELECT 1001,15451551
UNION ALL
SELECT 1001,13151345
UNION ALL
SELECT 1001,15484565
UNION ALL
SELECT 1002,15487963
UNION ALL
SELECT 1002,21544454
UNION ALL
SELECT 1003,95235646
UNION ALL
SELECT 1003,12321512

SELECT sIDNo,dbo.f_str(sIDNo) AS sAccount FROM tb t GROUP BY sIDNo

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!