Twitter
Facebook
Google+
RSS

Home
CSharp
Visual Studio
How To
Microsoft Office
- Powerpoint
- Word
- Excel
- Outlook
OutSystems
Contact Us
Alternatives

Category Archives: SQL Server

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

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

Dealing with the column names that looks like SQL Keywords in SQL Serv...

September 14, 2016 no comments

How to return the column names from a table in SQL Server ?

September 7, 2016 no comments

SQL Server’s ISNULL() equivalent in PostgreSQL

September 6, 2016 no comments

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

Print a text N number of times in SQL Management Studio

September 1, 2016 no comments

1 2 3 4 Next »

Recruit Me

Download My Resume

Web Dev Training (Online)

Recent Posts

Json.NET How to #2 – Convert a simple JSON string to C...

Delphi Community Edition free for download.

If you are a seasonal delphi or objective pascal developer and would like to try the new Embarcadero Delphi version free , then you can use the Delphi Community Edition. Delphi Community Edition is a free version for hobby programmers or small compan... Delphi Community Edition free for download.

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

SQL Server – Shortcut to display the Stored procedure ...

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 Management Studio and connect to the server. 1....

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

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 defined in the TextInfo class. How to Convert a strin... How to Convert a string to Title Case in C# ?

Cloud Training (Online)

Contact

Name

Message

About us

Thank you for using for buying this theme from Well Themes. If you have questions, please feel free contact.

Popular Categories

Windows Phone
CSharp
Visual Studio
General
Excel

Wanna Recruit Me ?

If you are a Employer or an Agency or if you have any references with-in your contacts who are looking out for a Principal Engineer / Architect / Technical Evangelist role , here's a profile for you to look at.

Download My Resume

Thank You