ASE Database forum - SQL Coding standard

Author

SQL Coding standard

Ollie

2005-09-21, 9:49 am

Has anyone put together a SQL Coding standard or know of a
published one? I am in the process of putting together one.
Coincidentally, Sybase sent me an email yesterday stating
that they've been compiling SQL standard over a period of
several years based on exeperience working with different
client, but they want me to go through a survey to rate me
against that standard. It feel like I am taken an exam. I
want answers not exams.

Eugene Korolkov

2005-09-21, 9:49 am

Hi Ollie,

I also was preparing one for our company,
unfortunately did not finished yet , it is relatively big (already > 60
pages),
too busy with other stuff now.

Regards,
Eugene

Ollie wrote:

>Has anyone put together a SQL Coding standard or know of a
>published one? I am in the process of putting together one.
>Coincidentally, Sybase sent me an email yesterday stating
>that they've been compiling SQL standard over a period of
>several years based on exeperience working with different
>client, but they want me to go through a survey to rate me
>against that standard. It feel like I am taken an exam. I
>want answers not exams.
>
>

Bret Halford

2005-09-21, 11:24 am

There is set of naming conventions forming appendix E of the book
"Physical Database Design for Sybase SQL Server" by
Gillette, Muench, and Tabaka. Prentice Hall, 1995
ISBN 0-13-161523-8

http://www.amazon.com/exec/obidos/t...=books&n=507846

Cheers,
-bret

Ollie wrote:

> Has anyone put together a SQL Coding standard or know of a
> published one? I am in the process of putting together one.
> Coincidentally, Sybase sent me an email yesterday stating
> that they've been compiling SQL standard over a period of
> several years based on exeperience working with different
> client, but they want me to go through a survey to rate me
> against that standard. It feel like I am taken an exam. I
> want answers not exams.

Eugene Korolkov

2005-09-21, 11:24 am

I used to use as a basis for our standard Database Coding Standard and
Guideline
(http://www.nyx.net/~bwunder/dbChang...ol/standard.htm)
+ tried to distill everything else what I have found on the web +
"Sybase server Dba survival guide"
(it also has naming conventions standards, but it is only very small
part of the whole needed stuff actually)
+ recent Joe Celko's book "SQL programming style". Very important is
error handling, found 3 diff.styles.

Actually it would be very good to have it incorporated in some TSQL
developer environment.
(+ possibility to tune it according to own preferences + good style
templates like
see for example www.qnxo.com by S.Feuerstein for PL/SQL )).

Regards,
Eugene

Bret Halford wrote:

>There is set of naming conventions forming appendix E of the book
>"Physical Database Design for Sybase SQL Server" by
>Gillette, Muench, and Tabaka. Prentice Hall, 1995
>ISBN 0-13-161523-8
>
>http://www.amazon.com/exec/obidos/t...=books&n=507846
>
>Cheers,
>-bret
>
>
>Ollie wrote:
>
>
>
>
>
>

Sponsored Links