Results 1 to 4 of 4

Thread: convert reserved words to upper

  1. 01-14-2005, 02:48 PM #1
    alex
    alex is offline Registered User
    Join Date
    Sep 2002
    Posts
    159

    convert reserved words to upper

    We want to covert all reserved words
    in procedures to upper case,any suggestions ?
    Reply With Quote Reply With Quote
  2. 01-14-2005, 02:59 PM #2
    nosepicker
    nosepicker is offline Registered User
    Join Date
    Dec 2004
    Posts
    502
    Well, you could update the "text" column in the syscomments table, which is where the stored procedures are kept. However, I am generally not in favor of messing around with the data in the system tables. I would prefer to generate scripts for all the stored procedures, write a simple program to do the text changes, and then run the modified script to re-create the stored procedures.
    Reply With Quote Reply With Quote
  3. 01-14-2005, 04:31 PM #3
    Rawhide's Avatar
    Rawhide
    Rawhide is offline Registered User
    Join Date
    Feb 2003
    Posts
    1,048
    Just curious, but why would you want to do that?
    Reply With Quote Reply With Quote
  4. 01-14-2005, 04:42 PM #4
    alex
    alex is offline Registered User
    Join Date
    Sep 2002
    Posts
    159
    We want use "sql standards"

    so all the existing code should
    have reserved words in upper case
    (to improve "VISABILITY" and be more
    "READABLE")
    and if someone forgot to code in
    upper case, it should be converted
    to upper at "any time"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules