These are the two widely used SET options in SQL Server. Most developers explicitly set these options while creating Stored Procedures, Triggers and User Defined Functions but many are unclear on why we need to explicitly SET them? And why they are special compared to other options? Below is the typical usage of these options.… Continue reading Understanding SET QUOTED_IDENTIFIER ON/OFF and SET ANSI_NULLS ON/OFF