Hi Guys, When you generate a script to create a Stored Procedure, below three statements are generate by default. SET ANSI_NULLS on SET NOCOUNT on SET QUOTED_IDENTIFIER on Why do we need these. Why Management Studio thinks we would require these options. Let us understand each one of these one by one. SET ANSI NULL ON : … Continue reading SET ANSI_NULLS, NOCOUNT and QUOTED_IDENTIFIER.