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
 Database Design and Application Architecture
 How Stored Procedure works in Database Engine ?

Author  Topic 

Langthasa
Starting Member

6 Posts

Posted - 2011-02-11 : 05:00:03
Hi All,

Can any body tell me how exactly Stored Procedure works in Database Engine ?

What are the steps it performs in the database engine?

I will be glad if anyone can share their knowledge with me.

With Regards,
Langthasa

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-02-11 : 05:07:23
probably best to refer to one of the SQL Server Internal book by Kalen Delaney


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

Langthasa
Starting Member

6 Posts

Posted - 2011-02-11 : 05:15:14
Hi khtan,

can u suggest me any site for dat?


With Regards,
Langthasa
Go to Top of Page

Langthasa
Starting Member

6 Posts

Posted - 2011-02-11 : 05:15:14
Hi khtan,

can u suggest me any site for dat?


With Regards,
Langthasa
Go to Top of Page

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2011-02-11 : 05:25:37
http://www.amazon.co.uk/Microsoft-SQL-Server-2008-Internals/dp/0735626243/ref=sr_1_1?ie=UTF8&qid=1297419866&sr=8-1

It is the best book I have ever read on SQL Server and was written by members of the community. Buy it, you won't regret it.

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
Go to Top of Page

Langthasa
Starting Member

6 Posts

Posted - 2011-02-11 : 05:54:38
Hi Charli,

Thank U for giving me the information.

I will go for it.

With Regards,
Langthasa
Go to Top of Page
   

- Advertisement -