CREATE TABLE [dbo].[Miscellaneous]
( 
     [ID] INT IDENTITY(1,1) NOT NULL,    
     [Item] NVARCHAR(50) NOT NULL DEFAULT(N'')
)
GO

CREATE PROCEDURE [dbo].[usp_Miscellaneous_Insert]
(
    @comma_delimited_string NVARCHAR(MAX)
)
AS
BEGIN
    DECLARE @xml XML = [dbo].[svf_ConvertToXML](@comma_delimited_string)
    INSERT INTO  [dbo].[Miscellaneous](Item)
    SELECT nref.value('.','NVARCHAR(MAX)') AS [Item]
    FROM @xml.nodes('/insus') AS R(nref)
END
 
GO

DECLARE @str NVARCHAR(MAX) = N'金，水，木，火，土'
EXECUTE [dbo].[usp_Miscellaneous_Insert] @str
SELECT [ID],[Item] FROM [dbo].[Miscellaneous]