SQL Server Archives - Developer Publish

SQL Server 101 – GROUP BY datetime and ignore time

SQL Server 101 – Extract Domain Name from Email Address

SQL Server 101 – Get the identity of inserted row

SQL Server 101 – Search tables for a specific column name

SQL Server 101 – Get the size of all tables in database

SQL Server 101 – Get the Date part from DateTime

SQL Server 101 – Return the Current DateTime

SQL Server 101 – Check if a column exists in a table

SQL Server 101 – How to add a column with a default value to existing table ?

SQL Server 101 – How to Delete Top N records ?

Fix – Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 08001, Native Error: 17

SQL Server – Shortcut to display the Stored procedure Code

SQL Function to make all TEXT to propercase in SQL Server

How many databases does a SQL Server Instance support?

Dealing with the column names that looks like SQL Keywords in SQL Server

How to return the column names from a table in SQL Server ?

SQL Server’s ISNULL() equivalent in PostgreSQL

Quick way to search within a procedure in SQL Server

How to view the code of a stored procedure using a Query in SQL Server ?

Print a text N number of times in SQL Management Studio