What is the Use of ANSI_NULLS

  • Hi,

    What is the Use of ANSI_NULLS? why why do we use this in storedprocedure? what is the working of this?

  • You ought to go and read up on these topics in the Books Online(BOL) (the SQL Server documentation that gets installed with the product). Then, if you have specific questions of understanding after reading there you can post the more detailed questions here. Otherwise you're asking us to look up the stuff in BOL and copy it over here for you.

    BOL is also available on the web.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Please read Books Online for what this does.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply