摘要:
CREATE FUNCTION fntest ( @list VARCHAR(MAX) )RETURNS @t TABLE ( SecId VARCHAR(10) )AS BEGIN ; WITH cte AS ( SELECT SUBSTRING(@list, LEN(@list) - 10 + 1, 10) AS v ,1 lvl UNION ALL SELECT... 阅读全文
摘要:
CREATE FUNCTION fntest ( @list VARCHAR(MAX) )RETURNS @t TABLE ( SecId VARCHAR(10) )AS BEGIN ; WITH cte AS ( SELECT SUBSTRING(@list, LEN(@list) - 10 + 1, 10) AS v ,1 lvl UNION ALL SELECT... 阅读全文
|