2006-12-22

精妙的SQL和SQL SERVER 与ACCESS、EXCEL的数据导入导出转换

来源: CSDN 作者:Shell 评论 0 条
  ''' then Result end) [' Subject ']'
from (select distinct Subject from CJ) as a
select @sql = @sql ' from test group by name'
exec(@sql)

行列转换
--合并

有表A,
id pid
1 1
1 2
1 3
共68页: 上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] [21] [22] [23] [24] [25] [26] [27] [28] [29] [30] [31] [32] [33] [34] [35] [36] [37] [38] [39] 40 [41] [42] [43] [44] [45] [46] [47] [48] [49] [50] [51] [52] [53] [54] [55] [56] [57] [58] [59] [60] [61] [62] [63] [64] [65] [66] [67] [68] 下一页
(本文仅表明作者个人观点,不代表本站及其管理员立场.) 推荐 收藏 投稿 打印 返回 关闭
上一篇:两台SQL Server数据同步解决方案  
下一篇:收藏几段SQL Server语句和存储过程
    评论加载中…
 推荐文章
     

网站首页  -  网站地图 -   站长论坛  -  网站投稿  -    -  网站管理
Copyright © 2008 芜湖站长站 All Rights Reserved 皖ICP备07500611号