A script that builds a 512 row truth table with its decimal value and binary sequence, using CROSS JOINs on a bit table. Add or remove joins to resize it.
SQL SERVER – Query to Find First and Last Day of Current Month – Date Function
Find the first and last day of the current month with one query. This Date Function example uses DATEADD, DAY and GETDATE and runs against today’s date.
SQL SERVER – Explanation SQL Command GO
GO is not a T-SQL command. It tells SQL Server tools to send the current batch. Why a GO statement must sit on its own line, and how it ends a batch.
SQL SERVER – 2005/2000 Examples and Explanation for GOTO
How the GOTO statement jumps to a label in the same T-SQL batch. My explanation for GOTO covers the syntax, the rules and when I still use it.
SQL SERVER – UDF – User Defined Function to Find Weekdays Between Two Dates
A user defined function that returns the number of weekdays between two dates, skipping Saturday and Sunday. It was written by Alexander Chigrik.
SQL SERVER – Collate – Case Sensitive SQL Query Search
Make a SQL Query Search case sensitive: add COLLATE Latin1_General_CS_AS to the WHERE clause so ‘casesearch’ matches one row instead of all four.
SQL SERVER – 2005 Security DataSheet
The SQL Server 2005 Security DataSheet from Microsoft covers its security features, like automatic secured updates and encryption of sensitive data.