create table demo(类 varchar(20)) insert into demo values('上衣')
insert into demo values('内衣')
insert into demo values('外套')
insert into demo values('西服')create proc [dbo].[pppp] @C1 varchar(1000)
as
begin
declare @sql varchar(8000)
select @sql = isnull(@sql + ',' , '') + 类 from +@C1+ group by 类 -- +' 附近有语法错误。
select @sqlend
自己写出来一个,但是运行的结果不对,那个@C1不能这样子使用,但是这个要用到变量,如何才可以实现 ,谢谢.
解决方案 »
- 再开贴求一条access数据库用的sql有关计算的语句
- 请教一个并不复杂但是难以得到结果的查询语句
- 50分的帖:谁能给出关于sp_的具体用法!
- SQL Server 内存占用导致服务器访问慢的问题
- 有用过SQL Server6.5的牛人吗?$$$
- insert有没有办法一次插入多条记录?数据源是一些文本
- 求一个sql语句
- 一个关于926和945的错误!修复数据库的问题,有关926和945错误的!
- SQL server2000安装的问题:(
- :怎样用编程实现创建SQL Sever数据库的内容?比如Click一下,就在Sql Server里面创建了数据库(如:名字Amass100HR0),最好用C++Build编一段代码。
- 难搞的Insert INTO,求大虾帮忙
- SQL 2000查询分析器连接局域网内主机时出错
create table demo(类 varchar(20))
insert into demo values('上衣')
insert into demo values('内衣')
insert into demo values('外套')
insert into demo values('西服')
gocreate proc [dbo].[pppp] @C1 varchar(1000)
as
begin
declare @sql varchar(8000)
create table #t(类 varchar(20))
insert into #t
exec('select 类 from '+@C1)
select @sql = isnull(@sql + ',' , '') + 类 from #t group by 类
print @sql
end
goexec [pppp] 'demo'
godrop proc [pppp]
drop table demo/***********内衣,上衣,外套,西服
declare @sql varchar(8000)
set @sql= 'SELECT * FROM '+@tablename+ '
exec(@sql)
insert into demo values('内衣')
insert into demo values('外套')
insert into demo values('西服')create proc [dbo].[pppp] @C1 varchar(1000)
as
begin
exec('declare @sql varchar(8000)
select @sql = isnull(@sql + '','' , '''') + 类 from '+'demo'+' group by 类
select @sql')
endexec pppp 'demo'/*---------------------
内衣,上衣,外套,西服(1 行受影响)
declare @sql varchar(8000)
set @sql= 'SELECT * FROM '+@tablename+ ''
exec(@sql) [/code]
as
begin
exec('declare @sql varchar(8000)
select @sql = isnull(@sql + '','' , '''') + 类 from '+@C1+' group by 类
select @sql')
end
drop table demo
gocreate table demo(类 varchar(20)) insert into demo values('上衣')
insert into demo values('内衣')
insert into demo values('外套')
insert into demo values('西服')if OBJECT_ID('pppp') is not null
drop proc [dbo].[pppp]
go
create proc [dbo].[pppp] @C1 varchar(1000)
as
begin
exec('declare @sql varchar(8000)
select @sql = isnull(@sql + '','' , '''') + 类 from '+@C1+' group by 类
select @sql')
end
go
exec pppp 'demo'
go/*----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
内衣,上衣,外套,西服(1 行受影响)
*/