fnMFVariableTableName¶
Signature¶
dbo.fnMFVariableTableName(
@TablePrefix NVARCHAR(100),
@TableSuffix NVARCHAR(20)
)
Returns¶
NVARCHAR: a composed table name derived from the prefix and suffix (may be used to generate a unique working table name).
Parameters¶
@TablePrefix NVARCHAR(100) (required) - Table name prefix.
@TableSuffix NVARCHAR(20) (required) - Table name suffix.
Purpose¶
Create a composed table name using a prefix and suffix. Useful for generating working or temporary table names.
Examples¶
SELECT dbo.fnMFVariableTableName('tmpTest', '1') AS TableName;
Changelog¶
Date |
Author |
Description |
2019-08-30 |
JC |
Added documentation |
2018-02-28 |
LC |
Include an alternative method of setting the file name based on unique identifier. This is controlled by using a flag. |