Shulou(Shulou.com)06/01 Report--

SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO

Creating a stored procedure in SQL Server will have the above code, what exactly does it mean?

ANSI_NULLS

For example, the following table, when there is a null value in the column Column1.

If ANSI_NULLS is ON, the statement where Column1=null returns empty. The statement where Column1 is null returns the specific number of rows.

Column 1Column 2Column 3TextTextTextQUOTED_IDENTIFIER

QUOTED_IDENTIFIER is ON, identifiers can be separated by double quotes, and text must be separated by single quotes.

QUOTED_IDENTIFIER is OFF, and identifiers cannot be quoted.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.