Montag, 2. August 2010 15:20
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.
- Verschoben Brian AurichMicrosoft Employee, Moderator Donnerstag, 30. September 2010 04:58 migration (From:SQL Azure - Archive)
Dienstag, 3. August 2010 07:05Moderator
It is supported in SQL Azure. You can test it with sample code:
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
- Als Antwort markiert Yi-Lun LuoModerator Freitag, 6. August 2010 09:51