my personal conventions...
Tables:
- Users
- OrderDetail
Columns:
- FirstName
- UnitPrice
Sprocs:
- sp_
[action] e.g., sp_UsersInsert, sp_OrderDetailInsert
(Reason: New databases don't contain sp_* sprocs, so why bother with usp_*?)
T-SQL variables:
- have to admit it, sometimes I go hungarian...