SQL Server Archives - Developer Publish

Expand To Show Full Article

SQL Server Archives - Developer Publish

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 – 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 ?

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

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 ?