Named Query Parameter String Concat

Ignition
,
1

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

2

Have you tried:

AND vs.volume_mount_point = CONCAT(:disc, ':\');

1 Like
3

I guess I wasn't aware of the CONCAT function for SQL. That would probably work

4

(post deleted by author)