The last line of a SQL script decides whether your work is saved, rolled back, or still holding locks. Here are the classic endings and how to check them.
SQUARE: Expect a float Result From Numeric Inputs
SQUARE accepts numeric inputs convertible to float and returns float. Explicit decimal display keeps this small example readable without claiming exact decimal multiplication.
SQL SERVER – Query to Find First and Last Day of Current Month – Date Function
One query to find the First and Last Day of Current Month in SQL Server, plus the last day of the previous month and the first day of the next.
SQL SERVER – UDF – Function to Parse AlphaNumeric Characters from String
UDF_ParseAlphaChars keeps only the alphanumeric characters in a string and strips everything else using PATINDEX and STUFF. A handy function, with a test.
SQL SERVER – 2005 – List all the database
Several ways to list all the database names on a server, from sp_databases and sp_helpdb to sys.databases and sp_msForEachDB. I use sp_databases myself.
SQL SERVER – Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support
Error:
Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support
1) Enable Server for CLR Support.
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.