Other DATALENGTH SQL function

1. Usage of DATALENGTH with customers

SQL Server Query 1

            
 SELECT CustomerID, DATALENGTH(CustomerID) AS CustomerIDDataLength FROM Customers;   

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

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

     .Column(new DATALENGTH(new Column("CustomerID")), "CustomerIDDataLength")  

     .From("Customers")  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT CustomerID AS CustomerID,
       DATALENGTH(CustomerID) AS CustomerIDDataLength
FROM Customers;


            
        

Parameters (If used)

Query Results 1:

2. Usage of DATALENGTH in WHERE clause

SQL Server Query 2

            
 SELECT ProductName   

 FROM Products   

 WHERE DATALENGTH(ProductName) - 5 > 20; -- Find products with a name longer than 10 Unicode characters (20 bytes)  

            
        

Create SQL query with SqlQueryBuilder 2

            
 var (sql2, parameters2) = new SqlQueryBuilder()  

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

     .From("Products")  

     .Where(new Where(new DATALENGTH(new Column("ProductName"))  

         .AddArithmatic(new Arithmatic().Subtract(5))  

         .GreaterThan(20)))  

     .Build();  

            
        

Query build by SqlQueryBuilder 2

            
SELECT ProductName AS ProductName
FROM Products
WHERE DATALENGTH(ProductName) - @pMAIN_2512060923065545550 > @pMAIN_2512060923065545551;


            
        

Parameters (If used)

Query Results 2: