Thank this author by sharing:
String Operation in Stored Procedure
As a SQL Server DBA you should know that your code is stored in syscomments by default. While most D...
Search for String Occurence with this script in your stored procedures.
How to Retrieve roleid's by passing csv strings into stored procedure
Nested Stored Procedure
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.