SQL Server | Developer Publish

SQL Server 101 – Get the identity of inserted row

May 24, 2020 no comments

If you are looking at a way to find the identity of the inserted row in SQL Server , you can use the SCOPE_IDENTITY(). How to get the identity of the inserted row in SQL Server ? SCOPE_IDENTITY, IDEN...

SQL Server 101 – Search tables for a specific column name

May 23, 2020 no comments

You might want to search all the tables in your database for a specific column name in order to rename or perform some cleanup. How to search tables for a specific column name in SQL Server ? SELECT ...

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

May 23, 2020 no comments

You might have a scenario where you want to find out how much space that each of the tables in your database is taking so that you can take action on it. There are various ways which one could use to...

SQL Server 101 – Return the Current DateTime

May 10, 2020 no comments

If you want to return the current date time in SQL Server , the easiest way to do it is using the GETDATE() function. How to return the Current DateTime in SQL Server ? The GETDATE() function returns...

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

May 10, 2020 no comments

If you need to check if a column exists in a table or not in SQL Server , below is a sample code snippet that demonstrates how to do it. How to check if a column exists in a table in SQL Server ? The...

SQL Server 101 – How to add a column with a default value to exi...

May 10, 2020 no comments

There are times when you want to add an column with a default value to the existing table in SQL Server and you can easily do that with the DEFAULT keyword. How to add a column with a default value t...

SQL Server 101 – How to Delete Top N records ?

May 10, 2020 no comments

Assume that you have a table named “Employee” in MS SQL Server and you would like to delete the top 1000 rows from the table. You can use the SQL Query with the TOP (N) as option as shown...

SQL Server – Shortcut to display the Stored procedure Code

October 14, 2019 no comments

Are you looking at displaying the stored procedure code quickly with-in your SQL Server Management Studio ?. Here’s how you do it. How to display SP Code in SQL Server Management Studio ? Open ...

SQL Function to make all TEXT to propercase in SQL Server

October 9, 2019 no comments

There are times when you want to change the tect from the table to a proper case in SQL Server and here’s a small resuable function that lets you do it. create function ConvertToTitleCase(@Text as va...

How many databases does a SQL Server Instance support?

August 14, 2018 no comments

Here’s a common question on what is the maximum number of databases that I can run on a single SQL Server instance. You can have 32,767 databases per SQL Server instance as per the Microsoft do...

1 2 3 4 5 Next »