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