Other CONCAT_WS SQL function

1. Usage of CONCAT_WS to show full name from employees table

SQL Server Query 1

            
 SELECT EmployeeID, CONCAT_WS(' ', FirstName, LastName) AS FullName FROM Employees;   

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select().Columns("EmployeeID", "EmployeeID")  

     .Column(new CONCAT_WS(" ", new Column("FirstName"), new Column("LastName")), "FullName")  

     .From("Employees")  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT EmployeeID,
       EmployeeID,
       CONCAT_WS(@pMAIN_2507200159531532200, FirstName, LastName) AS FullName
FROM Employees;


            
        

Parameters (If used)

Query Results 1:

2. Usage of CONCAT_WS to create customer identifier

SQL Server Query 2

            
 SELECT CONCAT_WS(' - ', CustomerID, CompanyName) AS CustomerIdentifier FROM Customers;   

            
        

Create SQL query with SqlQueryBuilder 2

            
 var (sql2, parameters2) = new SqlQueryBuilder()  

     .Select()  

     .Column(new CONCAT_WS(" ", new Column("CustomerID"), new Column("CompanyName")), "CustomerIdentifier")  

     .From("Customers")  

     .Build();  

            
        

Query build by SqlQueryBuilder 2

            
SELECT CONCAT_WS(@pMAIN_2507200159531571770, CustomerID, CompanyName) AS CustomerIdentifier
FROM Customers;


            
        

Parameters (If used)

Query Results 2:

3. Usage of CONCAT_WS to format customer address

SQL Server Query 3

            
 SELECT CustomerID, CONCAT_WS(', ', Address, City, Region, PostalCode, Country) AS CustomerAddress   

 FROM Customers;   

            
        

Create SQL query with SqlQueryBuilder 3

            
 var (sql3, parameters3) = new SqlQueryBuilder()  

     .Select().Column("CustomerID", "CustomerID")  

     .Column(new CONCAT_WS(", ", new Column("Address"), new Column("City"), new Column("Region"),  

         new Column("PostalCode"), new Column("Country")), "CustomerAddress")  

     .From("Customers")  

     .Build();  

            
        

Query build by SqlQueryBuilder 3

            
SELECT CustomerID AS CustomerID,
       CONCAT_WS(@pMAIN_2507200159531603490, Address, City, Region, PostalCode, Country) AS CustomerAddress
FROM Customers;


            
        

Parameters (If used)

Query Results 3:

4. Usage of CONCAT_WS to format product details

SQL Server Query 4

            
 SELECT TOP 15 ProductName, CONCAT_WS(CHAR(9), ProductName, UnitPrice, UnitsInStock) AS ProductDetailsWithTabs   

 FROM Products;   

            
        

Create SQL query with SqlQueryBuilder 4

            
 var (sql4, parameters4) = new SqlQueryBuilder()  

     .Select().Top(15).Column("ProductName", "ProductName")  

     .Column(new CONCAT_WS(new CHAR(9), new Column("ProductName"), new Column("UnitPrice"),  

             new Column("UnitsInStock")), "ProductDetailsWithTabs")  

     .From("Products")  

     .Build();  

            
        

Query build by SqlQueryBuilder 4

            
SELECT TOP 15 ProductName AS ProductName,
              CONCAT_WS(CHAR(@pMAIN_2507200159531638630), ProductName, UnitPrice, UnitsInStock) AS ProductDetailsWithTabs
FROM Products;


            
        

Parameters (If used)

Query Results 4:

5. Usage of CONCAT_WS to format order details

SQL Server Query 5

            
 SELECT TOP 25 OrderID, ProductID,   

 	CONCAT_WS(' | ', 'Product ID: ' + CAST(ProductID AS VARCHAR), 'Quantity: ' + CAST(Quantity AS VARCHAR), 'Unit Price: $' +   

 		CAST(UnitPrice AS VARCHAR)) AS OrderDetailInfo   

 FROM [Order Details];  

            
        

Create SQL query with SqlQueryBuilder 5

            
 var (sql5, parameters5) = new SqlQueryBuilder()  

     .Select().Top(25).Columns("OrderID", "ProductID")  

     .Column(new CONCAT_WS(" | ", new CONCAT("Product ID: ", new CAST(new Column("ProductID"), SqlDataType.VARCHAR)),  

         new CONCAT("Quantity: ", new CAST(new Column("Quantity"), SqlDataType.VARCHAR)),  

         new CONCAT("Unit Price: $", new CAST(new Column("UnitPrice"), SqlDataType.VARCHAR))), "OrderDetailInfo")  

     .From("[Order Details]")  

     .Build();  

            
        

Query build by SqlQueryBuilder 5

            
SELECT TOP 25 OrderID,
              ProductID,
              CONCAT_WS(@pMAIN_2507200159531673930, CONCAT(@pMAIN_2507200159531673931, CAST (ProductID AS VARCHAR)), CONCAT(@pMAIN_2507200159531673932, CAST (Quantity AS VARCHAR)), CONCAT(@pMAIN_2507200159531673933, CAST (UnitPrice AS VARCHAR))) AS OrderDetailInfo
FROM [Order Details];


            
        

Parameters (If used)

Query Results 5: