{"id":361,"date":"2010-07-21T22:17:24","date_gmt":"2010-07-22T03:17:24","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?page_id=361"},"modified":"2013-06-26T04:23:33","modified_gmt":"2013-06-26T09:23:33","slug":"rewrite-sql-server-propriety-joins-to-ansi-sql-compliant-joins","status":"publish","type":"page","link":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/rewrite-sql-server-propriety-joins-to-ansi-sql-compliant-joins\/","title":{"rendered":"Rewrite SQL Server proprietary joins to ANSI SQL compliant joins"},"content":{"rendered":"<p>This demo illustrates how to rewrite SQL Server proprietary joins to ANSI SQL compliant joins, it\u2019s a very useful tool if you have lots of old SQL Server propriety joins that need to be converted to ANSI SQL compliant joins. You can also learn how to rewrite SQL to meet your own requirement from this demo.<\/p>\n<p>\nSQL Server propriety joins\n<\/p>\n<pre>\r\nSELECT t1.*\r\nFROM   table1 t1,\r\n       table2 t2\r\nWHERE  t1.f1 *= t2.f1\r\n       AND t1.f2 > 10 \r\n<\/pre>\n<p>\nConvert to ANSI SQL compliant joins\n<\/p>\n<pre>\r\nSELECT t1.*\r\nFROM   table1 t1\r\n       LEFT JOIN table2 t2\r\n         ON t1.f1 = t2.f1\r\nWHERE  t1.f2 > 10 \r\n<\/pre>\n<p>Download this demo: <a href=\"http:\/\/www.dpriver.com\/gsp\/demos\/csharp\/joinconverter\/joinconveter.cs\">C# version<\/a><\/p>\n<p>Reference:<\/p>\n<p>1. <a href=\"http:\/\/infocenter.sybase.com\/help\/index.jsp?topic=\/com.sybase.help.ase_15.0.sqlug\/html\/sqlug\/sqlug166.htm\" title=\"sybase: converting outer joins with join-order dependency\" target=\"_blank\">sybase: Converting outer joins with join-order dependency<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This demo illustrates how to rewrite SQL Server proprietary joins to ANSI SQL compliant joins, it\u2019s a very useful tool if you have lots of old SQL Server propriety joins that need to be converted to ANSI SQL compliant joins. You can also learn how to rewrite SQL to meet your own requirement from this demo. SQL Server propriety joins SELECT t1.* FROM table1 t1, table2 t2 WHERE t1.f1 *= t2.f1 AND t1.f2 > 10 Convert to ANSI SQL compliant joins SELECT t1.* FROM table1 t1 LEFT JOIN table2 t2 ON t1.f1 = t2.f1 WHERE t1.f2 > 10 Download this\u2026<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":235,"menu_order":210,"comment_status":"closed","ping_status":"open","template":"gsp_feature_page_tt.php","meta":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Help you to make better use of General SQL Parser<\/title>\n<meta name=\"description\" content=\"Rewrite SQL Server proprietary joins to ANSI SQL compliant joins\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/rewrite-sql-server-propriety-joins-to-ansi-sql-compliant-joins\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Help you to make better use of General SQL Parser\" \/>\n<meta property=\"og:description\" content=\"Rewrite SQL Server proprietary joins to ANSI SQL compliant joins\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/rewrite-sql-server-propriety-joins-to-ansi-sql-compliant-joins\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and Data Blog\" \/>\n<meta property=\"article:modified_time\" content=\"2013-06-26T09:23:33+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\",\"name\":\"SQL and Data Blog\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"contentUrl\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"width\":251,\"height\":72,\"caption\":\"SQL and Data Blog\"},\"image\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"name\":\"SQL and Data Blog\",\"description\":\"SQL related blog for database professional\",\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/rewrite-sql-server-propriety-joins-to-ansi-sql-compliant-joins\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/rewrite-sql-server-propriety-joins-to-ansi-sql-compliant-joins\/\",\"name\":\"Help you to make better use of General SQL Parser\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\"},\"datePublished\":\"2010-07-22T03:17:24+00:00\",\"dateModified\":\"2013-06-26T09:23:33+00:00\",\"description\":\"Rewrite SQL Server proprietary joins to ANSI SQL compliant joins\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/rewrite-sql-server-propriety-joins-to-ansi-sql-compliant-joins\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/rewrite-sql-server-propriety-joins-to-ansi-sql-compliant-joins\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/rewrite-sql-server-propriety-joins-to-ansi-sql-compliant-joins\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dpriver.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"List of demos illustrate how to use general sql parser\",\"item\":\"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Rewrite SQL Server proprietary joins to ANSI SQL compliant joins\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Help you to make better use of General SQL Parser","description":"Rewrite SQL Server proprietary joins to ANSI SQL compliant joins","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/rewrite-sql-server-propriety-joins-to-ansi-sql-compliant-joins\/","og_locale":"en_US","og_type":"article","og_title":"Help you to make better use of General SQL Parser","og_description":"Rewrite SQL Server proprietary joins to ANSI SQL compliant joins","og_url":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/rewrite-sql-server-propriety-joins-to-ansi-sql-compliant-joins\/","og_site_name":"SQL and Data Blog","article_modified_time":"2013-06-26T09:23:33+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/www.dpriver.com\/blog\/#organization","name":"SQL and Data Blog","url":"https:\/\/www.dpriver.com\/blog\/","sameAs":[],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","contentUrl":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","width":251,"height":72,"caption":"SQL and Data Blog"},"image":{"@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/www.dpriver.com\/blog\/#website","url":"https:\/\/www.dpriver.com\/blog\/","name":"SQL and Data Blog","description":"SQL related blog for database professional","publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/rewrite-sql-server-propriety-joins-to-ansi-sql-compliant-joins\/","url":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/rewrite-sql-server-propriety-joins-to-ansi-sql-compliant-joins\/","name":"Help you to make better use of General SQL Parser","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/#website"},"datePublished":"2010-07-22T03:17:24+00:00","dateModified":"2013-06-26T09:23:33+00:00","description":"Rewrite SQL Server proprietary joins to ANSI SQL compliant joins","breadcrumb":{"@id":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/rewrite-sql-server-propriety-joins-to-ansi-sql-compliant-joins\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/rewrite-sql-server-propriety-joins-to-ansi-sql-compliant-joins\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/rewrite-sql-server-propriety-joins-to-ansi-sql-compliant-joins\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dpriver.com\/blog\/"},{"@type":"ListItem","position":2,"name":"List of demos illustrate how to use general sql parser","item":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/"},{"@type":"ListItem","position":3,"name":"Rewrite SQL Server proprietary joins to ANSI SQL compliant joins"}]}]}},"_links":{"self":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/pages\/361"}],"collection":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/comments?post=361"}],"version-history":[{"count":8,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/pages\/361\/revisions"}],"predecessor-version":[{"id":1588,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/pages\/361\/revisions\/1588"}],"up":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/pages\/235"}],"wp:attachment":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media?parent=361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}