{"id":1226,"date":"2011-10-04T03:19:01","date_gmt":"2011-10-04T08:19:01","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?p=1226"},"modified":"2011-10-14T21:02:34","modified_gmt":"2011-10-15T02:02:34","slug":"casecapitalization-user-defined-identifier-in-sql-statement","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/2011\/10\/casecapitalization-user-defined-identifier-in-sql-statement\/","title":{"rendered":"case(Capitalization) user defined identifier in SQL statement"},"content":{"rendered":"

SQL Pretty Printer<\/a> provides the ability to capitalize user defined identifier such as stored procedure name start with sp_ in SQL Server.<\/p>\n

name: case_prefix_identitfer <\/p>\n

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

name: identifier_prefix_list<\/p>\n

setting path: capitalisation -> Identifier prefix list<\/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_prefix_identitfer to uppercase and identifier_prefix_list to sp_,<\/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":"

SQL Pretty Printer provides the ability to capitalize user defined identifier such as stored procedure name start with sp_ in SQL Server. name: case_prefix_identitfer setting path: capitalisation -> Prefix_ident name: identifier_prefix_list setting path: capitalisation -> Identifier prefix list EXECUTE Sp_executesql @query, n’@age int’, @age = 25 After setting case_prefix_identitfer to uppercase and identifier_prefix_list to sp_, 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":"\ncase(Capitalization) user defined identifier in SQL statement<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n