Hello, I'm not sure if it is the current default in MS SQL Server, but documentation says that it is going to be default in the future. In all our test-servers it seems to be the default (2000, 2005 and 2008).
Information about the setting: http://msdn.microsoft.com/en-us/library/ms176056.aspx And the qoute: "Important: In a future version of SQL Server CONCAT_NULL_YIELDS_NULL will always be ON and any applications that explicitly set the option to OFF will generate an error. Avoid using this feature in new development work, and plan to modify applications that currently use this feature." So it seems they are going to support the ANSI-SQL behaviour always in the future. For our use-case we will just note it as a deviation of the SQL- standard and we will create a work-around for it in our templating system. Setting it in the url is too user-dependent. Greetings, Remco --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
