query
-
Query Sql Version Microsoft MSSQL
References https://support.microsoft.com/kb/321185 http://blogs.msdn.com/b/euanga/archive/2008/01/23/confused-by-sql-server-version-numbers.aspx Continue reading
-
MSSQL Quick Reference
Snippets below have been condensed from their original sources for brevity. See references for original articles. Great reference on joins: http://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins Show all tables in specific database: (MSSQL equivalent of MySql “show tables”) Insert into: Insert if not exists: Trigger… Continue reading
{handshake sound} 