SQL Server

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 ?

Kill all the current active connection in SQL Server database

How to replace NULL values with alternate values in SQL Server ?

WAITFOR TIME in SQL Server

WAITFOR DELAY in SQL Server

How to check if the table exists in a database in SQL Server ?

Using Expressions for SORT Order in SQL Server

Wildcard Search in SQL Query

Other ways of specifying the alias name for a column in SQL Server

Column Alias and Square brackets in SQL Query.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Thanks, I’m not interested