Write maintainable T-SQL with clear names, explicit results, focused procedures, and comments that explain the business reason behind the code.
SQL SERVER – Difference Between EXEC and EXECUTE vs EXEC() – Use EXEC/EXECUTE for SP always
What is the difference between EXEC and EXECUTE? None. The real difference is EXEC vs EXEC(), and I show why EXEC belongs before every stored procedure call.
COUNT_BIG: Count Rows and Non-NULL Values as bigint
COUNT_BIG helps me name the counting rule before reading the result. Compare rows, supplied values and distinct readings. Then check empty results and the bigint return type.
FORMATMESSAGE: Build a Message Without Raising an Error
FORMATMESSAGE returns formatted text without raising an error. Match placeholders to typed arguments and keep formatting separate from control flow.
RIGHT: Zero Padding Can Remove Significant Digits
RIGHT can make zero padding look correct while quietly removing significant digits. I validate the allowed numeric range before creating a fixed-width label. The suffix expression alone cannot tell whether the input fits.
SQL SERVER – 2005 – Start Stop Restart SQL Server From Command Prompt
Start, stop or restart SQL Server from the command prompt with net start mssqlserver and net stop mssqlserver. A batch file can run both together.
SQL SERVER – UDF – User Defined Function – Get Number of Days in Month
A simple user defined function that returns the number of days in month for any date, with the leap year rule for February built in.







