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.
SQL SERVER – Location of Statistics Before and After Database is Marked as a Read-Only
Where do old statistics go when a database becomes read-only? The location of statistics created before the change stays the same, and they remain permanent.
SQL SERVER – Statistics for Read-Only Database are in TempDB
Statistics usually live in the same database as the table, so where do they go for a read-only database? The answer is TempDB. Here is how it works.
SQL SERVER – MySQL – Order Column by Nearest Value for Any Integer
How do you order column values by how close they are to any integer, such as -5? Here is a script that works the same way on SQL Server and MySQL.
SQL SERVER – Export Data AS CSV from Database Using SQLCMD
We often import CSV into SQL Server, but how do you export data as CSV with SQLCMD? Two simple commands, one with column headers and one without.





