Michael Valentine Jones (2/13/2013)
Andy Hyslop (2/11/2013)[/b
...
Why should User Defined Functions not be prefixed UDF or udf, views not Prefixed with VW or vw and Stored Procedures not USP or usp
...
That is an odd question to show up on a SQL test. There are no technical reasons (that I know of) why you can't do that, or why the application would work better.
I have seen many applications that used UDF, VW, and USP, but I have never seen any actual application problems caused by this.
Of course there are many good reasons not to use them that others have pointed out, but in the end they amount to style preference, standards, ease of coding, ease of understanding, etc.
I completely agree, it was unusual and that's why it threw me....totally!!! :-S
I really couldn't think of a valid reason and my answer reflected as such..
Although I am seeing some valid reasons why not to and am enjoying the discussion I just cant see any real impact that necessitates the term "must not be used"...:crazy:
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe