2,596
社区成员
发帖
与我相关
我的任务
分享
CREATE procedure str_chr
str varchar(4000)
AS
str2 varchar(4000),
str_select varchar(4000),
str_from varchar(4000),
str_where varchar(4000),
str_and varchar(4000),
str_group varchar(4000),
str_split varchar(4000)
BEGIN
select str2 = lower(str)
--sybase是否支持chr(10) LZ试一试,直接在后面添加 + chr(10)
SELECT str_select= str_replace(str,'),','), ')
SELECT str_from= str_replace(str_select,'from',' from')
SELECT str_where= str_replace(str_from,'where',' where ')
SELECT str_and= str_replace(str_where,'and',' and ')
SELECT str_group= str_replace(str_and,'group by','group by ')
--这里我觉得应该是str_group而不是str,是否LZ写错,如果不是,自己更改代码
SELECT str_split= str_replace(str_group,') *',') * ')
return str_split
END;