declare @string varchar(1000) set @string='aaaa,bbbb,cccc,dddd' set @string='select '''+replace(@string,',','''as str union all select ''')+'''' exec(@string)
create table #a(a varchar(100))declare @string varchar(1000) set @string='aaaa,bbbb,cccc,dddd' set @string='insert #a select '''+replace(@string,',','''as str union all select ''')+'''' exec(@string)select * from #a
我这里是SYBASE数据库 为什么我使用这个代码建立一个存储过程踢是错误呢?? CREATE PROCEDURE TEST AScreate table #a (a varchar(100) )declare @string varchar(1000) set @string='aaaa,bbbb,cccc,dddd'set @string='insert #a select '''+replace(@string,',','''as str union all select ''')+''''exec(@string)select * from #a;
set @string='aaaa,bbbb,cccc,dddd'
set @string='select '''+replace(@string,',','''as str union all select ''')+''''
exec(@string)
set @string='aaaa,bbbb,cccc,dddd'
set @string='insert #a select '''+replace(@string,',','''as str union all select ''')+''''
exec(@string)select * from #a
为什么我使用这个代码建立一个存储过程踢是错误呢??
CREATE PROCEDURE TEST
AScreate table #a
(a varchar(100)
)declare @string varchar(1000)
set @string='aaaa,bbbb,cccc,dddd'set @string='insert #a select '''+replace(@string,',','''as str union all select ''')+''''exec(@string)select * from #a;