Sometimes you need to manipulate a transfer data from a souce database
to another; if you need to exclude some columns from the table list (you got them as comma delimited string list dinamically) you have to cast the string column name as sysname type
you can do it with this function, but you can use for whatever table type you want to retrieve
Just pass a list as string comma separated and receive a table of that list.
Adjust the return type at your convinience.
-- =============================================
-- Author:Bernabé Díaz
-- Create date: 12/24/2008
-- Description:returns an array of sysname from string filter
-- =============================================
CREATE FUNCTION [dbo].[Udf_TABLECOLUMNLIST]
(
@strDataSet VARCHAR(4000)
)
RETURNS @DST TABLE
(
x SYSNAME
)
AS
BEGIN
DECLARE @Idxb INT
SET @Idxb=CHARINDEX(',',@strDataSet,1)
IF @Idxb=0
BEGIN
INSERT INTO @DST
SELECT CAST(@strDataSet AS SYSNAME)
RETURN
END
ELSE
BEGIN
WHILE CHARINDEX(',',@strDataSet,1)<>0
BEGIN
INSERT INTO @DST
SELECT CAST(SUBSTRING(@strDataSet,1,@Idxb-1) AS SYSNAME)
SELECT @strDataSet=LTRIM(RTRIM(SUBSTRING(@strDataSet,@Idxb+1,LEN(@strDataSet)-@Idxb)))
SET @Idxb=CHARINDEX(',',@strDataSet,1)
CONTINUE
END
END
INSERT INTO @DST
SELECT CAST(LTRIM(RTRIM(@strDataSet)) AS SYSNAME)
RETURN
END 
2023-07-18 (first published: 2012-12-04)
1,625 reads
This function return the text format of a month calendar. It could be useful for sending through emails when you do do not have other tools, but T-SQL to send text emails.
2023-07-18 (first published: 2012-10-31)
1,879 reads
If you need to get a range sequence of numbers this script can help you to acomplish it. For example : the sequency of numbers between -5 and 5 or 1 and 200, etc..
2023-07-18 (first published: 2012-04-23)
1,427 reads
I prepared this version (my original did not used XML)
By being helped by forums feedback from SQL central
Forward it to yours peers.
2023-07-18 (first published: 2010-05-13)
1,823 reads
2023-07-18 (first published: 2010-03-18)
2,066 reads