Tag search

Database, Microsoft, MS SQL Server, Technology

How to Find a Stored Procedure in all the Databases?

When working with MS SQL Server sometimes you need to find a stored procedure in the databases and all that you know is the name of the stored procedure that your teammate told you that he had used but couldn’t…

Muhammad Jawaid Shamshad
September 18, 2015

Database, Microsoft, MS SQL Server, Technology

Searching Lowercase data in MS SQL Server

A few days back I came across a requirement to fetch the records from the table having all lowercase letters. This was an interesting scenario. The SQL Server database by default is set for case-insensitive. But, I need to do…

Muhammad Jawaid Shamshad
September 17, 2015