declare @sql varchar(2000), @tsql nvarchar(max), @split varchar(100)set @sql='A,B,C,D,E' --保存的字符set @split=','--分隔符select @tsql='select ''' + replace(@sql,@split,''' AS New union all select ''') + ''' 'exec(@tsql)create table T(id char(6), words varchar(100))insert into T values('1', 'A,B,C,D,E')--drop table Tdeclare @tsql varchar(100), @sentence varchar(100)exec('select top 1 words from T where id=''1'' ')--此處本嘗試獲得exec執(zhí)行的結(jié)果(字符串),以用于下面的Replace函數(shù)第一個(gè)參數(shù),但未找到方法;select @tsql='select ''' + replace('A,B,C,D,E',',',''' AS New union all select ''') + ''' 'exec(@tsql)
2 回答
浮云間
TA貢獻(xiàn)1829條經(jīng)驗(yàn) 獲得超4個(gè)贊
declare @sql varchar(2000), @tsql nvarchar(max), @split varchar(100)
set @sql='A,B,C,D,E' --保存的字符
set @split=','--分隔符
select @tsql='select ''' + replace(@sql,@split,''' AS New union all select ''') + ''' '
declare @t table([new] nvarchar(255))
insert into @t exec(@tsql)
select * from @t
這里沒(méi)必要用exec，直接取值就可以
declare @t table(id char(6), words varchar(100))
insert into @t values('1', 'A,B,C,D,E')
insert into @t values('2', 'A,B,C,D,E,F')
insert into @t values('3', 'A,B,C,D,E,F,G')
declare @w varchar(100)
select top 1 @w=words from @t
declare @tsql varchar(2000)
select @tsql='select ''' + replace(@w,',',''' AS New union all select ''') + ''' '
exec(@tsql)
心有法竹
TA貢獻(xiàn)1866條經(jīng)驗(yàn) 獲得超5個(gè)贊
這里可以不用EXEC，換另外一種思路。
DECLARE @word VARCHAR(100);
SELECT @word = (SELECT TOP 1 words
FROM T
WHERE id = 1);
這樣就可以獲取到字符串了。
- 2 回答
- 0 關(guān)注
- 4235 瀏覽