none
SET ANSI_NULLS ON in SQL Azure

    Question

  • Hi ,

                I have created one table in SQL Azure and set "SET ANSI_NULLS ON"  using SQL Server R2,It has executed successfully  but  when I generated script it does not contain "SET ANSI_NULLS ON" code. so i am still not cleare whether it support this feature ot not.

                        If it support why generated script does not contains same.

     

               Thanks in advance.

     

    Monday, August 02, 2010 3:20 PM

Answers

  • Hi,

    It is supported in SQL Azure. You can test it with sample code:

    http://msdn.microsoft.com/en-us/library/ms188048.aspx

    I tested with a table in SSMS 2008R2:

    CREATE TABLE [dbo].[t1](

        [a] [int] NULL

    )

    And then right click the table -> Script Table as -> Create to… And then I can see the option SET ANSI_NULLS ON.

     

    Hope this helps,

    Raymond
    Raymond Li - MSFT
    • Marked as answer by Yi-Lun Luo Friday, August 06, 2010 9:51 AM
    Tuesday, August 03, 2010 7:05 AM
    Moderator