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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Where can I get I guide on conventions for naming

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

Posted - 2007-06-12 : 11:27:44
http://vyaskn.tripod.com/object_naming.htm
http://databases.aspfaq.com/database/what-naming-convention-should-i-use-in-my-database.html
http://www.sql-server-performance.com/vk_sql_best_practices.asp
http://www.sqlservercentral.com/rc/resourcedetail.asp?Q=31

And In case you are wondering where I got the links from, I googled

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2007-06-12 : 11:56:14
Think you mean

http://www.fuckinggoogleit.com/search?query=database+naming+convention

(Thanks for reminding me about that).



==========================================
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.
Go to Top of Page

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
Go to Top of Page

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.
Go to Top of Page

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.
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -