SQL SERVER- Solution SQL Puzzle of SET ANSI_NULL

Posted by: Journey to SQL Authority with Pinal Dave, on 28 May 2013 | View original | Bookmarked: 0 time(s)

Earlier I have posted a puzzle which received so many valid responses and got a fantastic explanation to the questions as well. I encourage all of you to read the original puzzle here. First run following script: SET ANSI_NULLS ON; -- Query1 SELECT 'SQLAuthority' AS Statement11 WHERE 'Authority' IN ('S','Q', 'L', 'Authority', NULL); -- Query […]...

Category: SQL | Other Posts: View all posts by this blogger | Report as irrelevant | View bloggers stats | Views: 333 | Hits: 8

Similar Posts

  • Migrating to Postgresql with my friend NHibernate more
  • Migrated from Community Server to DasBlog more
  • Web Deployment Tool has gone RTW more
  • Mocking indexer getters with Moq more
  • The MethodLinq concept more
  • Global Application settings and the web.config file. more
  • Installing the FTP Service for IIS 6.0 On An Alternate Port Number and Configuring Windows Firewall more
  • Mocking indexer setters with Moq more
  • WPF Bindings and CurrentCulture Formatting more
  • Visual Studio 2010 1-Click Publishing more

News Categories

.NET | Agile | Ajax | Architecture | ASP.NET | BizTalk | C# | Certification | Data | DataGrid | DataSet | Debugger | DotNetNuke | Events | GridView | IIS | Indigo | JavaScript | Mobile | Mono | Patterns and Practices | Performance | Podcast | Refactor | Regex | Security | Sharepoint | Silverlight | Smart Client Applications | Software | SQL | VB.NET | Visual Studio | W3 | WCF | WinFx | WPF | WSE | XAML | XLinq | XML | XSD