{"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\/2011\/10\/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\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n