Posted in SQL Server

SQL Server Tips – Find Stored Procedure or Function containing “Some Text”

Many times I came across a need to search procedure or functions having some “text”. The reason behind this need could be anything, here is the code to get that result. You need to query INFORMATION_SCHEMA.ROUTINES in order to get this details.  Continue reading “SQL Server Tips – Find Stored Procedure or Function containing “Some Text””

Posted in SQL Server

SQL Server Tips – Dynamic Order By

Many times we need to sort records based on some conditions and for that we need to implement conditional sorting in SQL server. I have mentioned some techniques to achieve this below.

Continue reading “SQL Server Tips – Dynamic Order By”