求大牛解决方法

求大牛
怎么接收一个字符 让它以行显示啊

SQL code

   123456789id123456789

SQL code

declare @tab table(id nvarchar(2))declare @str nvarchar(50)declare @len intdeclare @i intselect @str='123456789'select @i=1select @len=len(@str)while(@i<=@len)begin    insert into @tab(id) values(substring(@str,@i,1))    select @i=@i+1endselect * from @tab
[解决办法]
SQL code
declare @str nvarchar(50)set @str='123456789'select substring(@str,number,1) colfrom master..spt_valueswhere [type] = 'p' and number between 1 and len(@str)/**************col----123456789(9 行受影响)
[解决办法]
SQL code
declare @str varchar(100)set @str='123456789'select SUBSTRING(@str,s.number + 1,1) from master..spt_values swhere s.type='p' and s.number <len(@str)
[解决办法]
SQL code
DECLARE @ID NVARCHAR(100)SET @ID = '123456789'SELECT TOP 100 ID=IDENTITY(INT,1,1) INTO #T FROM SYSOBJECTS,SYSCOLUMNSSELECT ID = SUBSTRING(@ID,ID,1) FROM #T WHERE ID <= LEN(@ID)DROP TABLE #T
[解决办法]
SQL code
if OBJECT_ID('tb') is not null drop table tb go declare @t varchar(800)set @t='123456789'declare @i intset @i=1create table tb(id varchar(10)) while @i<= LEN(@t)begin  insert into tb values(SUBSTRING(@t,@i,1))  -- set @t=SUBSTRING(@t,@i,@i+1)  set @i=@i+1   end; select * from tbid----------123456789(9 行受影响)
[解决办法]
SQL code
 declare @t varchar(800)set @t='123456789'  select SUBSTRING(@t,number,1)  from master..spt_values where number between 1 and LEN(@t) and type='p'----123456789(9 行受影响)
[解决办法]
SQL code
declare @s varchar(max)set @s='sfefgthg15461'select SUBSTRING(@s,number+1,1) from master..spt_values where type='p' and number<=LEN(@s)