A one line DATEADD query to find the last day of month for any date. It handles leap years: February 2008 gives the 29th and 2007 the 28th.
SQL SERVER – ASCII to Decimal and Decimal to ASCII Conversion
In this blog post we will see how we can convert ASCII to Decimal and Decimal to ASCII. In simple words, we will see the decimal and ASCII conversion.
SQL SERVER – Math Functions Available in SQL Server
One list of the Math Functions available in SQL Server, from ABS and CEILING to SQRT and TAN, and why RAND is the only nondeterministic one among them.
SQL SERVER – 2005 – SSMS Change T-SQL Batch Separator
A big script used EndBatch instead of GO. Rather than a risky mass replace, I changed the Batch Separator in SSMS under Tools, Options, and it ran as is.
SQL SERVER – Fix: Error 130: Cannot perform an aggregate function on an expression containing an aggregate or a subquery
Error 130 says you cannot perform an aggregate function on an expression containing an aggregate, like AVG(COUNT()). A derived table gets around it.
SQL SERVER – Binary Sequence Generator – Truth Table Generator
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 – DBCC commands List – documented and undocumented
The full list of documented and undocumented DBCC commands with their syntax, plus how DBCC TRACEON(2520) and DBCC HELP show all of them in Query Analyzer.