Stored procedures and triggers in SQL Server may become confused while executing stored procedures and triggers when SQL Server special words such as TRANSACTION appear as table or other names,even if they are enclosed in square brackets [ ].

Question

Quizplus · Accepted Answer

SQL Server may interpret special words as keywords even when they are enclosed in square brackets, causing confusion during the execution of stored procedures and triggers.

Stored Procedures and Triggers in SQL Server May Become Confused