stored procedure yazan 2
-
we write the stored procedure in sqlserver2000 (update,insert,select)that better than write the statment it in asp.net code why ???
-
we write the stored procedure in sqlserver2000 (update,insert,select)that better than write the statment it in asp.net code why ???
SP is a set of precompiled code. It imporoves performance of the application SPs can be reusable. If any DB logic changes it's ok if we change in procedure it self rather than modifying all the queries. SP makes maintainability also easier
"Aim to go where U have never been B4 and Strive to achieve it" http://groups.yahoo.com/subscribe/dotnetforfreshers http://himabinduvejella.blogspot.com
-
we write the stored procedure in sqlserver2000 (update,insert,select)that better than write the statment it in asp.net code why ???
Also, if you revoke access to the actual tables to the users and do everything through Stored Procedures then you increase the security of the application because then the the users can only do what is specified in the Stored Procedure and cannot do anything else.
Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog