Paging in MySQL and SQL Server: use LIMIT and OFFSET to skip some rows and return only the next few, with examples for both databases.
SQL SERVER – MySQL – PostgreSQL – How to Concat Strings?
How to concat strings the same way in SQL Server, MySQL and PostgreSQL? I switched from the plus operator to the CONCAT function, and here is why.
SQL SERVER – What Permissions I have on Database I am Connected to?
When I get access to a new server, I first check the permissions I have on the database. One simple query with fn_my_permissions shows the full list.
Free Tools Worth Having on a SQL Server
Choose free SQL Server tools by the problem they solve, from SSMS and sqlcmd to Extended Events, and understand the limits before relying on them.
MySQL – How to Create Stored Procedure
Confused by semicolons when you create stored procedure code in MySQL? Change the DELIMITER first, then reset it. Here is a simple example.
SQL SERVER – Working with Business Days in SQL Server – A Different Approach
I recommend that you download XLeratorDB and try this problem along with me, this is going to be a fun exercise and something new to learn about Business Days.
SQL SERVER – How to Allow Only Alphabets in Column – Create Check Constraint to Insert Only Alphabets
Allow only alphabets in a SQL Server column with an explicit ASCII-letter rule. These tested examples reject empty strings, NULL, spaces, digits, and punctuation while explaining collation and existing-data checks.