Metadata FILE_NAME SQL function

1. Usage of FILE_NAME

SQL Server Query 1

            
 SELECT FILE_NAME(1) AS 'File_Name',  

 FILE_NAME(2) AS 'Log_File_Name';  

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Column(new FILE_NAME(1), "File_Name")  

     .Column(new FILE_NAME(2), "Log_File_Name")  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT FILE_NAME(@pMAIN_2507200142351979480) AS File_Name,
       FILE_NAME(@pMAIN_2507200142351979481) AS Log_File_Name;


            
        

Parameters (If used)

Query Results 1: