I think auditing the history of data is important. It's not something that can be added retrospectively so the sooner you implement a solution, the better.

My personal preference is for...

Manie,

are you saying that you name stored procedures "sp_ ..."? I thought that was bad practice due to the way SQL Server will check in the Master database for procedures...

That's a very good point about putting each column on a new line. I use that method when I'm writing SQL (for an INSERT statement perhaps), but if I'm just...

I may be missing something, but it seems to me that only one of the posts so far have been about How To Lay Out SQL Code. Instead people seem...