| Author |
Topic |
|
willow_mimi
Starting Member
14 Posts |
 Posted - 2008-08-06 : 01:00:12
|
| Have u ever named your stored procedure, begin with "sp"??I just recently found that:It's not good to use "sp_"prefix in user-defined stored procedure nameswhy??read more on:[url]http://myblog-sql.blogspot.com/2008/07/using-sp-prefix-in-stored-procedure.html[/url]Murni Lim,MCTS,MCITPMicrosoft Certified TrainerMy blog about SQL:http://myblog-sql.blogspot.com |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
willow_mimi
Starting Member
14 Posts |
Posted - 2008-08-06 : 02:18:39
|
| Thanks for your input.But not everyone knows that , right?Murni Lim,MCTS,MCITPMicrosoft Certified TrainerMy blog about SQL:http://myblog-sql.blogspot.com |
 |
|
|
willow_mimi
Starting Member
14 Posts |
Posted - 2008-08-06 : 03:02:45
|
| To :Tara Kizer(OOT) I just read your profile that u had baby ,congrats for you :)Murni Lim,MCTS,MCITPMicrosoft Certified TrainerMy blog about SQL:http://myblog-sql.blogspot.com |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-08-06 : 03:11:23
|
i shouldn't think there's many SQL Server professionals who didn't know this alreadyquote:
Originally posted by willow_mimi
Thanks for your input.But not everyone knows that , right?Murni Lim,MCTS,MCITPMicrosoft Certified TrainerMy blog about SQL:http://myblog-sql.blogspot.com
Em |
|
|
|
MikeZ
Starting Member
6 Posts |
Posted - 2008-08-06 : 03:58:22
|
| Willow_mimi, it's a good posting I just knew that!! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-06 : 11:50:24
|
| I just checked the IP address of willow_mimi and MikeZ as I had a suspicion. They are the same person. willow_mimi == MikeZThat's really low, willow_mimi, to compliment your own post as another user.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-08-06 : 11:55:16
|
I wonder if MikeZ == SQLUSA?
elsasoft.org |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-06 : 11:55:45
|
You're kidding me?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-08-06 : 11:57:11
|
I was just thinking that responding to yourself with a different username is a sqlusa tactic.
elsasoft.org |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-06 : 12:01:16
|
Hehehe... Haven't seen him posting anything useful for ages.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-08-06 : 13:26:07
|
quote:
Originally posted by willow_mimi
Thanks for your input.But not everyone knows that , right?
Then lets save some time and just copy/paste the entire contents of Books Online into a post. I'm sure there's stuff in there that some people don't know.And be sure to plug your blog while you are at it.e4 d5 xd5 Nf6 |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-06 : 13:45:12
|
I was not referring to Jezemines answer?Didn't see that until topic refresh.I was referring to Tara's post 08/06/2008 : 11:50:24
E 12°55'05.25"N 56°04'39.16" |
|
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2008-08-06 : 14:05:43
|
| This post regarding not using "sp_" is obviously common knowledge, but I would be interested if anyone has a article that lists accepted standards for naming different objects. (I.e Stored Procedure = Sproc_, Function = fn_ or F_, etc). |
|
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2008-08-06 : 14:06:27
|
| Good post Vinnie, that was really insightful! :)I'm sorry couldn't resist! |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2008-08-06 : 14:30:13
|
| You guys are cold. I looked up SQLUSA and read some of his posts and comments and all. All I can say is LMAO. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-08-06 : 15:09:25
|
| Accepted naming conventions are whatever-the-hell I decide they are.e4 d5 xd5 Nf6 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-06 : 15:12:33
|
quote:
Originally posted by Vinnie881
This post regarding not using "sp_" is obviously common knowledge, but I would be interested if anyone has a article that lists accepted standards for naming different objects. (I.e Stored Procedure = Sproc_, Function = fn_ or F_, etc).
Everyone's style is different. Here is what we use:Sprocs: usp_ for applications, rsp_ for reports, and isp_ for internal DBA stuffFunctions: udf_Views: v_There are people who hate prefixes like these, such as Graz (owner of the site). I believe he's got an article on it. I don't care except for views and table-valued functions as I'd like to know by looking at the query that it's a view or a table-valued function rather than a regular table.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-06 : 15:22:09
|
quote:
Originally posted by Van
You guys are cold. I looked up SQLUSA and read some of his posts and comments and all. All I can say is LMAO.
)Oh, you should see the response he get on sqlmag.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
acollins74
Yak Posting Veteran
82 Posts |
Posted - 2008-08-06 : 15:26:36
|
| Ha, worked on a few dbs where through some migration/upgrade it was decided to prefix tbl_ to some views where the actual table no longer exists. good times. |
|
|
|
Next Page
|
it's bad using "SP_" for naming procedure?
willow_mimi/MikeZ wins in the looks department.Tara KizerMicrosoft MVP for Windows Server System - SQL Server