-
convert reserved words to upper
We want to covert all reserved words
in procedures to upper case,any suggestions ?
-
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.
-
Just curious, but why would you want to do that?
-
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"
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
|
|