SQL Server

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 – Get the Date part from DateTime

May 10, 2020 no comments

You can use the convert function in SQL Server to retrieve only the date part from the date time. How to get the Date part from DateTime variable in SQL Server ? Here’s a sample code snippet de...

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...

Fix – Sqllib error: OLEDB Error encountered calling IDBInitializ...

October 15, 2019 no comments

Are you facing the below error in SQL Server and looking for a fix ? Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 08001, Native Error: 17 Here&#...

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 ...

1 2 3 4 5 Next »

Recent Posts

Getting Started With Entity Framework Core 2.0 By Senthil Ku...

In this session you’ll learn how to get started using Entity Framework Core and how to use them in your .NET Applications. You will learn the new features in EF 2.0 , How to create data models to work with Entity Framework Core and know some of...

SQL Server 101 – Get the identity of inserted row

SQL Server 101 – Search tables for a specific column n...

SQL Server 101 – Get the size of all tables in databas...

SQL Server 101 – Get the Date part from DateTime

You can use the convert function in SQL Server to retrieve only the date part from the date time. How to get the Date part from DateTime variable in SQL Server ? Here’s a sample code snippet demonstrating how to do it. SELECT CONVERT(DATE, GETD...

SQL Server 101 – Get the Date part from DateTime