{"id":1224,"date":"2011-10-04T03:11:26","date_gmt":"2011-10-04T08:11:26","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=1224"},"modified":"2011-10-14T21:03:39","modified_gmt":"2011-10-15T02:03:39","slug":"upper-case-or-lower-case-variable-name-in-sql-statement","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/upper-case-or-lower-case-variable-name-in-sql-statement\/","title":{"rendered":"Upper case or lower case variable name in SQL statement"},"content":{"rendered":"

Unlike some other SQL formatting tools, SQL Pretty Printer<\/a> able to control the case of variable name in SQL statement, this feature helps you to find out variable in SQL statement quickly.<\/p>\n

name: case_variable_name, default is no change.<\/p>\n

setting path: capitalisation -> Variable<\/p>\n


\nEXECUTE<\/span> Sp_executesql<\/span>
\n
  @query<\/span>,<\/span>
\n
  n’@age int’<\/span>,<\/span>
\n
  @age<\/span> =<\/span> 25<\/span> 
\n<\/span><\/div>\n

After setting case_variable_name to upper case,<\/p>\n


\nEXECUTE<\/span> Sp_executesql<\/span>
\n
  @QUERY<\/span>,<\/span>
\n
  n’@age int’<\/span>,<\/span>
\n
  @AGE<\/span> =<\/span> 25<\/span> 
\n<\/span><\/div>\n","protected":false},"excerpt":{"rendered":"

Unlike some other SQL formatting tools, SQL Pretty Printer able to control the case of variable name in SQL statement, this feature helps you to find out variable in SQL statement quickly. name: case_variable_name, default is no change. setting path: capitalisation -> Variable EXECUTE Sp_executesql   @query,   n’@age int’,   @age = 25  After setting case_variable_name to upper case, EXECUTE Sp_executesql   @QUERY,   n’@age int’,   @AGE = 25 <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[18,24,22],"tags":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"\nUpper case or lower case variable name in SQL statement<\/title>\n<meta name=\"description\" content=\"Upper case or lower case variable name in SQL statement\" \/>\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\/upper-case-or-lower-case-variable-name-in-sql-statement\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upper case or lower case variable name in SQL statement\" \/>\n<meta property=\"og:description\" content=\"Upper case or lower case variable name in SQL statement\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dpriver.com\/blog\/upper-case-or-lower-case-variable-name-in-sql-statement\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and Data Blog\" \/>\n<meta property=\"article:published_time\" content=\"2011-10-04T08:11:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2011-10-15T02:03:39+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\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\/upper-case-or-lower-case-variable-name-in-sql-statement\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/upper-case-or-lower-case-variable-name-in-sql-statement\/\",\"name\":\"Upper case or lower case variable name in SQL statement\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\"},\"datePublished\":\"2011-10-04T08:11:26+00:00\",\"dateModified\":\"2011-10-15T02:03:39+00:00\",\"description\":\"Upper case or lower case variable name in SQL statement\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/upper-case-or-lower-case-variable-name-in-sql-statement\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dpriver.com\/blog\/upper-case-or-lower-case-variable-name-in-sql-statement\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/upper-case-or-lower-case-variable-name-in-sql-statement\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dpriver.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upper case or lower case variable name in SQL statement\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/upper-case-or-lower-case-variable-name-in-sql-statement\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/upper-case-or-lower-case-variable-name-in-sql-statement\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7\"},\"headline\":\"Upper case or lower case variable name in SQL statement\",\"datePublished\":\"2011-10-04T08:11:26+00:00\",\"dateModified\":\"2011-10-15T02:03:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/upper-case-or-lower-case-variable-name-in-sql-statement\/\"},\"wordCount\":101,\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"articleSection\":[\"format option\",\"sql pretty printer\",\"v238\"],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\/\/www.dpriver.com\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Upper case or lower case variable name in SQL statement","description":"Upper case or lower case variable name in SQL statement","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\/upper-case-or-lower-case-variable-name-in-sql-statement\/","og_locale":"en_US","og_type":"article","og_title":"Upper case or lower case variable name in SQL statement","og_description":"Upper case or lower case variable name in SQL statement","og_url":"https:\/\/www.dpriver.com\/blog\/upper-case-or-lower-case-variable-name-in-sql-statement\/","og_site_name":"SQL and Data Blog","article_published_time":"2011-10-04T08:11:26+00:00","article_modified_time":"2011-10-15T02:03:39+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin"},"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\/upper-case-or-lower-case-variable-name-in-sql-statement\/","url":"https:\/\/www.dpriver.com\/blog\/upper-case-or-lower-case-variable-name-in-sql-statement\/","name":"Upper case or lower case variable name in SQL statement","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/#website"},"datePublished":"2011-10-04T08:11:26+00:00","dateModified":"2011-10-15T02:03:39+00:00","description":"Upper case or lower case variable name in SQL statement","breadcrumb":{"@id":"https:\/\/www.dpriver.com\/blog\/upper-case-or-lower-case-variable-name-in-sql-statement\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dpriver.com\/blog\/upper-case-or-lower-case-variable-name-in-sql-statement\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dpriver.com\/blog\/upper-case-or-lower-case-variable-name-in-sql-statement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dpriver.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Upper case or lower case variable name in SQL statement"}]},{"@type":"Article","@id":"https:\/\/www.dpriver.com\/blog\/upper-case-or-lower-case-variable-name-in-sql-statement\/#article","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/upper-case-or-lower-case-variable-name-in-sql-statement\/"},"author":{"name":"admin","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7"},"headline":"Upper case or lower case variable name in SQL statement","datePublished":"2011-10-04T08:11:26+00:00","dateModified":"2011-10-15T02:03:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dpriver.com\/blog\/upper-case-or-lower-case-variable-name-in-sql-statement\/"},"wordCount":101,"publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"articleSection":["format option","sql pretty printer","v238"],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/fd33d9e572b65788a80dc4bac2b4e5a7","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/61d4e409068502b7e4960eb89efb79f8?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.dpriver.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/1224"}],"collection":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"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=1224"}],"version-history":[{"count":2,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/1224\/revisions"}],"predecessor-version":[{"id":1252,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/1224\/revisions\/1252"}],"wp:attachment":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media?parent=1224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/categories?post=1224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/tags?post=1224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}