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.
| Author |
Topic |
|
Mohansoft
Starting Member
6 Posts |
 Posted - 2005-09-10 : 10:56:57
|
| If you can simply have a set of transact sql queries .. than why do we go for stored procedures.Is there any perfomance difference between simply having a set of sql statements and a stored procedure.D.Mohan Raj |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2005-09-10 : 11:03:11
|
| Try to search on Store procedure on BOl you will find lots of advantages over thereComplicated things can be done by simple thinking |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-09-10 : 11:12:24
|
there is a performance differnce.there is a huge security issue.there is implementing business logic in sprocs.there is not having to change the app if the sql logic is changed.there is ... a lot of other stuff...Go with the flow & have fun! Else fight the flow  |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Why stored procedures