MS says that only system stored procedures should start with sp becasue when sql recieves a stored proc with sp_ it looks in the master system stored procedures first then looks in the current database. I doubt the speed difference is that much but just a tidbit of my two cents.
Josh <!--- Cut out of Books Online ---> Many of your administrative activities in Microsoft® SQL Server™ are performed through a special kind of procedure known as a system stored procedure. System stored procedures are created and stored in the master database and have the sp_ prefix. System stored procedures can be executed from any database without having to qualify the stored procedure name fully using the database name master. It is strongly recommended that you do not create any stored procedures using sp_ as a prefix. SQL Server always looks for stored procedures beginning with sp_ in this order: Look for the stored procedure in the master database first. Look for the stored procedure based on any qualifiers provided (database name or owner). Look for the stored procedure using dbo as the owner, if one is not specified. Therefore, although the user-created stored procedure prefixed with sp_ may exist in the current database, the master database is always checked first, even if the stored procedure is qualified with the database name. -----Original Message----- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 11:10 AM To: CF-Talk Subject: RE: DB Table Naming Conventions We usually do something like so: Stored Proc: sp_whatever Views: vw_whatever Tablename: tblUsers, tblPermissions, etc. Fields: Always prefixed with table-related text as such: userID (PK/ID) ufirstname ulastname uaddress1 uaddress2 ucity ustate uzip etc. That just makes it easier for me to see what field is related to what table - especially when you have similar data in multiple fields (which we try to avoid by abstracting the database as much as possible - but sometimes is necessary). There may be a better way or a more suitable way for your programming style. Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) -----Original Message----- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 10:20 AM To: CF-Talk Subject: Re: DB Table Naming Conventions -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 [EMAIL PROTECTED] wrote: | I'm just curious, What naming conventions for DB tables do you use? this is a biggy :-) a lot of php developers that work with mysql, a non relational db use pk names of ID.... I always name the pk of table (table_name)_id... I also tend to prefix ~ column names with an abbreviation of the table name, it makes life easier as there is more information there and when you start joining tables, there is less conflict if u use common naming conventions z -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6-2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAj0HWKMACgkQm98oI6K7h0gxUQCgjUvOt0+YVHgz/Qyh8RlAawAp CrwAoOwShhA1t7xZpiKsaYQ3Cdz8Supo =YXc3 -----END PGP SIGNATURE----- ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists