Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
johnstern
Yak Posting Veteran
67 Posts |
Posted - 2007-06-12 : 11:19:32
|
| Where can I get I guide on conventions for naming, stored procedures, tables, user functions ? that I can implement in my work |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-12 : 12:18:20
|
| Or even search this site!http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Good+table+naming+convention |
 |
|
|
johnstern
Yak Posting Veteran
67 Posts |
Posted - 2007-06-12 : 15:52:51
|
| I google it too and as expected, found articles that advocate different types of conventions, I was hoping maybe there will be a convention that is generally consider a standard in the industry. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-13 : 09:54:52
|
| Nope - every company is different.The only consistent thing should be don't call SPs sp_..., but then I'm dealing with a company now whose naming standards give that as a prefix for all SPs, but then they didn't realise why system stored procs were named that or why they are special.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-13 : 10:10:33
|
"The only consistent thing should be don't call SPs sp_..., "And whatever naming convention you adopt make sure you are consistent |
 |
|
|
|
|
|