|
|
excuse me if this is a dump question, but what's the reason of stored procedures and how it's used? i mean when i create a stored procedure, where should i put the execute statement?
thx for any reply :)
|
|
|
|
well.. imho.. i use stored proc (sp) for queries that have a tendency to change a lot.. that way, when the query changes, we only have to update the sp.. we can leave the program undisturbed..
we can execute the sp from the program..
|
|
|
|
thx alot ya, btw, can u show me any example code on sp? im still quite blur after the tutorial my lect gave me... still hv abit doubt on this thing ....and actually how to cal the sp?method?
|
|
|
|
Stored Procedures are sql server side sql scripts. you can write it using t-sql in sql server and pl/sql in oracle. stored procedure sql scripts can be used for selection, insert, update and delete operations basically but also can do a lot - just consider it as a programming language without windows interface (just like good old days 'c' programming language with sql interface).. calling stored procedure from any programming language improves programming efficiency... you can also write customized transaction based operations using stored procedure. T-sql is a fantastic sql programming language..
|
|
|
|
|
|
|
|
embedzit
