sql如何把结果放到一行里面去 select 'a' as a select 'b' as b如何得到[a][b] a b就是把结果放到一行里面去 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select 'a' as a , 'b' as b select 'a' as a union allselect 'b' as b 汗select * from(select 'a' as a )aCROSS join(select 'b' as b)b select 'a' as a , 'b' as b Write a new function to deal with your select result. Not limit Function, Procedure is a good way.I think you should use cursor in function or procedure to resolve your question. sql2000 float型 SUM求和 科学计数 请高手指教 很奇怪的rand 这条语句怎么写? 求一条sql 查询语句的写法 windowsXp 下能装SQL SERVER 2000 吗? 求大神优化sql! 请教大侠们一个执行select语句的问题 简单问题(测试时间) 请教,一个有关把MySql中一个表的数据倒到Ms SQL Server一个表中的sql语句,这个语句是在Ms SQL Server中执行的 SQL Server 2008中datatime数据读出来以后不完整 能介绍一本学SQL SERVER 2000的入门自学好书吗? SQL server 2000 这个JOB怎么写
union all
select 'b' as b
select * from
(select 'a' as a )a
CROSS join
(select 'b' as b)b
select 'a' as a , 'b' as b