As I have informed you earlier in this post, there are some interesting tips I have contributed in July 2011. You may find them interesting if you follow them. The following are some of my tips I posted there
Most Learned Posts of all time
Google is also a calculatorYou can drop multiple tables using single DROP statementSSMS Allows you to ask a question in the MSDN forum directly from SSMS
Just Learned Posts for the month of July 2011
Shortcut for Col is NOT NULL and col is NOT EMPTYArithmetic operations with datetime columnOrder by clause should be always part of row_number() functionUse Regular expression for better performanceKeyword NOT can be nested or wrapped any number of times Short-circuit in WHERE clauseyou need to wrap $ with braces to use + or - operatorsvariable value can be directly assigned to another variable during declarationTEXT datatype cannot be used in a comparison or ORDER BY, but can be used in LIKEScope of variable in a declare statementUnary Minus operator can be only applied with numeric datatypesValid/Invalid statements in Exists clauseLeading + operators will be omitted for non-integer datatypes alsoSQL Server DenaliParse function will convert data to specific datatypeTRY_CONVERT function. Returns data if successful otherwise returns nullTry_parse function return parsed data if successful otherwise returns nullFun in MathematicsFun with 1Sum of consecutive odd numbers starting from 1 is a perfect square
Tags: t-sql, sql_server, sqlserver, tsql, BRH, SQL Server, #SQLServer, just_learned,