Other SPACE SQL function

1. Usage of SPACE

SQL Server Query 1

            
 SELECT  

     e.FirstName,  

     SPACE(10 - LEN(e.FirstName)) + e.LastName AS FormattedFullName  

 FROM  

     Employees e;  

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Column("e.FirstName", "FirstName")  

     .Column(new ColumnArithmatic().SqlFunction(  

         new SPACE(new ColumnArithmatic().Value(10).SUBTRACT().SqlFunction(new LEN(new Column("e.FirstName")))))  

         .ADD().Column("e.LastName")  

         , "FormattedFullName")  

     .From("Employees", "e")  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT e.FirstName AS FirstName,
       SPACE(@pMAIN_2507200155145634280 - LEN(e.FirstName)) + e.LastName AS FormattedFullName
FROM Employees AS e;


            
        

Parameters (If used)

Query Results 1:

2. Usage of SPACE

SQL Server Query 2

            
 SELECT  

     c.CompanyName,  

     c.Address + ', ' + c.City + SPACE(2) + ISNULL(c.Region + ', ', '') + c.Country AS FormattedAddress  

 FROM  

     Customers c;  

            
        

Create SQL query with SqlQueryBuilder 2

            
 var (sql2, parameters2) = new SqlQueryBuilder()  

     .Select()  

     .Column("c.CompanyName", "CompanyName")  

     .Column(new CONCAT(  

         new Column("c.Address"), ", ", new Column("c.City"), new SPACE(2),  

         new ISNULL(new CONCAT(new Column("c.Region"), ", "), ""),  

         new Column("c.Country")  

     ), "FormattedAddress")  

     .From("Customers", "c")  

     .Build();  

            
        

Query build by SqlQueryBuilder 2

            
SELECT c.CompanyName AS CompanyName,
       CONCAT(c.Address, @pMAIN_2507200155145688470, c.City, SPACE(@pMAIN_2507200155145688471), ISNULL(CONCAT(c.Region, @pMAIN_2507200155145688472), @pMAIN_2507200155145688473), c.Country) AS FormattedAddress
FROM Customers AS c;


            
        

Parameters (If used)

Query Results 2: