SQL Server

SQL Server 101 – GROUP BY datetime and ignore time

white smartphone

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

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

How to get day of a week in SQL Server ?