How do I concat a parameter with a string in a named query?
For instance:
SELECT
CONVERT(DECIMAL(18,2), vs.available_bytes / 1073741824.0) AS [Available Space (MB)]
FROM sys.master_files AS mf
CROSS APPLY sys.dm_os_volume_stats(mf.database_id, mf.file_id) AS vs
WHERE
DB_NAME(mf.database_id) = 'TagHistory'
AND vs.volume_mount_point = 'F:\';
I want "F" to be the parameter :disc