SQL Server

Enhance your Xamarin.Forms Apps with Immersive DV, Dashboards and High Performance Data Grids.

Fix – Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 08001, Native Error: 17

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

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

Quick way to search within a procedure in SQL Server

September 2, 2016 no comments

There are times when you want to to list out all the stored procedure names that contains certain keyword or search text. Here’s a simple query that helps you do that. Quick way to search withi...

How to view the code of a stored procedure using a Query in SQL Server ?

September 1, 2016 no comments

Here’s a quick tips on viewing the code of a stored procedure in SQL Management Studio. One of the quickest ways in which you can view the source code of your stored procedure is by using the sp_help...

How to get day of a week in SQL Server ?

September 1, 2016 no comments

Assume that you have a date “01/09/2016” and you would like to find out what day of the week it is. For example , it should display if it is Monday , Tuesday , Wednesday… You can us...

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

August 26, 2016 no comments

Assume a scenario where you are trying to get the records from the table where some of the records contains NULL column values and you would like to replace it with an alternate value. How to replace...

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

August 25, 2016 no comments

To check if the table exists in a database in SQL Server , you can use the INFORMATION_SCHEMA view. How to check if the table exists in a database in SQL Server ? Here’s a query that gets the t...

Using Expressions for SORT Order in SQL Server

August 20, 2016 no comments

You might want to sort the results of an query in a different order from the traditional sort (Ascending/Descending) order. For example , you wish to sort the Department records by GroupName and forc...