Understanding SET QUOTED_IDENTIFIER ON/OFF and SET ANSI_NULLS ON/OFF

added by ranjithk
4/27/2010 6:40:53 AM

1 Kicks, 84 Views

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 explicitly SET them? and Why these two are special compared to other options?


0 comments