October, 2019 | Developer Publish

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

How to Convert a string to Title Case in C# ?

October 9, 2019 no comments

Assume that you have a string in C# and you want to have a mixture of both the upper case and the lowercase (i meant TitleCase in this example). You can do that easily using the ToTitleCase method de...

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