DECLARE @list varchar(1000), @sql varchar(1000) SELECT @list = @list + ',' + a.au_id
FROM authors a
ORDER BY phone
SET @sql = 'select ' + RIGHT(@list, len(@list) - 1) + ' from authors' EXEC (@sql)
========================================
上面想实现根据pubs的authors里的phone字段排序,然后汇总au_id排序后的结果!但我在sql 2000中运行上面的代码,并没有返回(显示)结果!请问那里错了
FROM authors a
ORDER BY phone
SET @sql = 'select ' + RIGHT(@list, len(@list) - 1) + ' from authors' EXEC (@sql)
========================================
上面想实现根据pubs的authors里的phone字段排序,然后汇总au_id排序后的结果!但我在sql 2000中运行上面的代码,并没有返回(显示)结果!请问那里错了
SET @list='' --加上这一句;否则@list的初值为NULL,NULL+Any = NULL
SELECT @list = @list + ',['+a.au_id+']'
FROM authors a
ORDER BY phoneSET @sql = 'select ' + RIGHT(@list, len(@list) - 1) + ' from authors'
print @sql
EXEC (@sql)
set @list='' --<<改了这句>>
SELECT @list = @list + ',' + a.au_id
FROM authors a
ORDER BY phone
SET @sql = 'select ' + RIGHT(@list, len(@list) - 1) + ' from authors'
EXEC (@sql)
============================================================
DECLARE @list varchar(1000), @sql varchar(1000)
SET @list='' --加上这一句;否则@list的初值为NULL,NULL+Any = NULL
SELECT @list = @list + ',['+a.au_id+']'
FROM authors a
ORDER BY phoneSET @sql = 'select ' + RIGHT(@list, len(@list) - 1) + ' from authors'
print @sql
EXEC (@sql)
=====================================
实现根据pubs的authors里的phone字段排序,然后汇总au_id排序后的结果!
但现在还是没有显示结果
=====================
这句是什么意思,把字符串串起来???
declare @sql varchar(1000)
set @sql='select au_id '
select @sql=@sql+ 'from authors order by phone
select @sql=@sql+' from authors
exec(@sql)
DECLARE @list varchar(1000), @sql varchar(1000)
set @list=''
SELECT @list = @list + ',' + a.au_id
FROM authors a
ORDER BY phone
SET @sql = 'select ' + RIGHT(@list, len(@list) - 1) + ' from authors'
EXEC (@sql)