Exception Handlers:
In SQL server the errors are always written to sysmessages table, so no exception can be handled here. The type of access to the SQL server from the front end determines the state of the error and how the error information can be retrieved.
Eg.
a). For ODBC type of access the error messages are [...]
Standard to create the columns:
The column name should be of the form XX<Abbr/Name><suffix> (XXX represents the abbreviation of the Table Name.It should be a meaningful abbreviation of the table name to which the column belongs.<suffix> is a meaningful suffix).
Column name should not be longer than 30 Alphanumeric characters.
Column name (<Abbr/Name> only) should be same throughout an application [...]
Standards to create the tables:
The table name should be the same as the logical entity name or should bear some significance to the data stored therein.
The table must have a primary key that uniquely identifies each row.
The column names will be same as logical attribute name.
Columns must be defined as NOT NULL wherever possible.
Table names [...]
