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.

 

Answer 1

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