drop procedure cit_namee
create procedure cit_namee
as begin
declare @_i int
declare @_len int
declare @s varchar(1000)
declare @b varchar(2)
set @b=1
set @s='select '
select @_len=max(len(cityname)) from dbo.T_city
set @_i=1
while @_i <= @_len
begin
set @s = @s + ' substring(cityname , ' + ltrim(@_i) + ','+@b+' ) as 第'+ltrim(@_i) +'个字节 ,'
-- select substring(cityname, @_i,1) from dbo.T_city
set @_i=@_i+1
end
set @s = substring(@s , 1 , len(@s) - 1) + ' from dbo.T_city'
print @s
end
exec cit_namee
返回的是一句执行语句 要看到试图应该怎么写?
create procedure cit_namee
as begin
declare @_i int
declare @_len int
declare @s varchar(1000)
declare @b varchar(2)
set @b=1
set @s='select '
select @_len=max(len(cityname)) from dbo.T_city
set @_i=1
while @_i <= @_len
begin
set @s = @s + ' substring(cityname , ' + ltrim(@_i) + ','+@b+' ) as 第'+ltrim(@_i) +'个字节 ,'
-- select substring(cityname, @_i,1) from dbo.T_city
set @_i=@_i+1
end
set @s = substring(@s , 1 , len(@s) - 1) + ' from dbo.T_city'
print @s
end
exec cit_namee
返回的是一句执行语句 要看到试图应该怎么写?
解决方案 »
- 您好,关于数据库分离附加的问题。
- having count(1)=1看不懂麻烦解答
- 从数据库服务器a可以直接拷贝数据库文件到数据库服务器b上使用吗?
- 求一个负载的分析
- 问一个简单的多个变量赋值问题?
- select * from ForumsArtcle where TopicID in (3,2,5,1,4) 请帮我看一下这排序
- select选择时间的问题
- 关于一个SQL排序的问题`高手进
- 问题:select * from servername.dbname.username.tablename
- SQL 不知道怎么描述~~~看详细吧
- 如何让fcompany 逐行递增?
- 能否实现T表的A字段与该表主键为外键关系并实现相关逻辑
create procedure cit_namee
as begin
declare @_i int
declare @_len int
declare @s varchar(1000)
declare @b varchar(2)
set @b=1
set @s='select '
select @_len=max(len(cityname)) from dbo.T_city
set @_i=1
while @_i <= @_len
begin
set @s = @s + ' substring(cityname , ' + ltrim(@_i) + ','+@b+' ) as 第'+ltrim(@_i) +'个字节 ,'
-- select substring(cityname, @_i,1) from dbo.T_city
set @_i=@_i+1
end
set @s = substring(@s , 1 , len(@s) - 1) + ' from dbo.T_city'
--print @s
exec (@s)
end
go