April 3, 2008 at 12:05 am
hi,
Can anyone please explain what is the difference between an implicit stored procedure and explicit stored procedure ?
I am not sure but what I can say is that I think Triggers are the examples of implicit stored procedure and the procedures we are explicity calling are explicit stored procedureb but I am not sure on that.
So if anyone has the detailed ideas or informations then please help me out.
Thanks and Regards
Ganesh Kumar
Bangalore
April 3, 2008 at 12:37 am
There's no such thing as an implicit or explicit stored procedure - as far as I'm aware anyway.
April 3, 2008 at 12:39 am
Hi
I guess all procedures created with "Create Procedure" statement cud be termed as explicit procedures.
"Keep Trying"
April 3, 2008 at 6:43 am
I haven't heard that term before either.
We have implicit and explicit data conversions... Not helpful, but at least those words are used. An implicit procedure would be one that occurs for you, like the implicit data conversion. That's not the same thing as a trigger.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 3, 2008 at 6:55 am
Add another to the list of those who have never heard of implicit\explicit stored procedures. Based on the fact that it is called a "stored" procedure I would think that all would be explicit as they must be created.
What is the context in which you heard the terms used? Could it be referring to the fact that SQL Server also caches execution plans for ad-hoc sql statements which, in essence, makes them like stored procedures in that way?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 3, 2008 at 11:31 am
Having never heard of "explicit or implicit stored procedures" and not being able to conceive of how a stored procedure could really be "implicit", I did a Google search on the phrase "implicit stored procedure".
The first hit was this forum thread.
Other than that, the only thing I found that could be read to imply that such exist was: "Each begin transaction statement in a stored procedure, whether implicit or explicit, must be balanced by a commit transaction statement, which decrements ...". If that phrase were misread, it could be thought to say that "transactions statements in implicit or explicit stored procedures ...", but it's actually talking about implicit and explicit transactions.
So, I have to vote for: I don't think there is such a thing.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 3, 2008 at 11:39 am
There is nothing I hate worse than googling a question and finding the place I posted it to as the first response. It never bodes well for getting a good answer.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 3, 2008 at 11:42 am
Grant Fritchey (4/3/2008)
There is nothing I hate worse than googling a question and finding the place I posted it to as the first response. It never bodes well for getting a good answer.
Hey - I take exception to that...I thought we provide somewhat halfway decent answers once in a while....:D
Still - I'm thinking this particular turkey is cooked. Toss one more on the "never heard of that before" pile.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply