--Adds a sql_variant element to the end of a sql_variant list, after first inserting a delimiter (nvarchar) --If both element and list are nvarchars, using dbo.fnAddToList will be faster ALTER FUNCTION dbo.fnAddVarToList (@VarList sql_variant, @VarNew sql_variant, @Del nvarchar(10)) RETURNS nvarchar(4000) AS BEGIN DECLARE @List nvarchar(4000), @New nvarchar(4000) SELECT @List = NULLIF(CONVERT(nvarchar(4000), @VarList), ''), @New = NULLIF(CONVERT(nvarchar(4000), @VarNew), '') --First try the concatened string, if null then just the list, --if it too is null, just the new element RETURN COALESCE(@List + @Del + @New, @List, @New) END
Never been to CodeSnippets before?
Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)
UDF to add a sql_variant to a list (See related posts)
You need to create an account or log in to post comments to this site.
Related Posts
Snippets (source code soon to be available) developed by Peter Cooper and powered by Ruby On Rails