How to use SQL Server profiler to capture and debug the queries executed from inside the stored Procedure? Here is the step by step instruction for debugging queries inside stored procedure using profiler.
Simple and clean method to escape special characters using STRING_ESCAPE system function. STRING_ESCAPE function was introduced in SQL 2016. Here we will see how to use it to escape dome of the special characters.