ALTER FUNCTION [dbo].[ChangeCharToTable]
(@InStatement NVARCHAR(MAX))
RETURNS @InTable TABLE
(
Id int not null primary key clustered
)
AS
BEGIN
DECLARE @XML as xml
set @XML='<t><i>' + REPLACE(@InStatement,',','</i><i>') + '</i></t>'
INSERT INTO @InTable
SELECT T.c.query('text()').value('.','int') as Id from @XML.nodes('/t/i') T(c)
RETURN
END
SELECT top 100 ID FROM [ChangeCharToTable]('1,2,3')
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。