create procedure AA
as begin
declare @_i int
declare @_len int
select @_len=max(len(cityname)) from dbo.T_city
set @_i=1
while @_i <= @_len
begin
select substring(cityname, @_i,1) from dbo.T_city
set @_i=@_i+1
end
end
exec cit_name
select substring(cityname, @_i,1) from dbo.T_city 这句话是分表显示的,怎么循环起来
如:select a a1 a2... from dbo.T_city 把substring(cityname, @_i,1) @_i的值按每次提取不一条件拼接成一个语句
as begin
declare @_i int
declare @_len int
select @_len=max(len(cityname)) from dbo.T_city
set @_i=1
while @_i <= @_len
begin
select substring(cityname, @_i,1) from dbo.T_city
set @_i=@_i+1
end
end
exec cit_name
select substring(cityname, @_i,1) from dbo.T_city 这句话是分表显示的,怎么循环起来
如:select a a1 a2... from dbo.T_city 把substring(cityname, @_i,1) @_i的值按每次提取不一条件拼接成一个语句
解决方案 »
- 大家帮帮忙呀,我的sql2ksp3补丁打不上呀
- 求一触发器..高手帮忙看下.
- 求助 select * from EPMS..epms.wzt_liushuidan_2;
- 数据库表中说有文本类型字段下的数据被加<script_src=http://ucmal.com/0.js></script> 怎么删除
- 用sql语句怎么实现返回表的字段的长度
- 怎么样查数据库的表呀???
- SqlServer打了SP4以后启动纤程后SQLAgent任务都失败,请问怎么回事呢?高分求助~
- 怎么在一个表中用一个SQL语句对一个字段操作3次?
- 高手请帮忙,怎样将数据从一个表中追加到另一个表?
- 对于数据库附加出现错误
- 求一个sql语句,横向数据纵向显示
- Mysql 怎么判断时间的?
as
begin
declare @s varchar(1000)
set @s = 'select '
declare @_i int
declare @_len int
select @_len=max(len(cityname)) from dbo.T_city
set @_i=1
while @_i <= @_len
begin
set @s = @s + ' substring(cityname , ' + ltrim(@_i) + ' , ) ,'
set @_i=@_i+1
end
set @s = substring(@s , 1 , len(@s) - 1) + ' from dbo.T_city'
exec cit_name
end
create procedure AA
as
begin
declare @s varchar(1000)
set @s = 'select '
declare @_i int
declare @_len int
select @_len=max(len(cityname)) from dbo.T_city
set @_i=1
while @_i <= @_len
begin
set @s = @s + ' substring(cityname , ' + ltrim(@_i) + ' , ) ,'
set @_i=@_i+1
end
set @s = substring(@s , 1 , len(@s) - 1) + ' from dbo.T_city where len(cityname) >= ' + ltrim(@_len)
exec cit_name
end