Benefits Of Stored Procedures

There are many benefits of using a stored procedures like increased execution speed, fast access data, consistency etc.


1. Execution Speed
Increased execution speed is the most useful advantage of Stored Procedures. Stored Procedures are optimized the first time they are compiled. Stored procedures are cached on the server.
2. Security
One of the most useful advantage of using Stored Procedures is security. We can give execute rights to store procedure so it can perform the right task. It creates a more secure enviroment.
3. Fast Data Access
SQL Stored Procedures are optimized for best execution path to the required data.
4. Consistency
Utilizing Stored Procedures enforces consistency, since users do not have to create and use their T-SQL statements.
5. Modular Programming
One of the most usefull advantage of Stored Procedures that Stored Procedures are located at one location means that there are no confusion and Stored Procedures is the sharing of application logic.

Comments

Post a Comment

Popular posts from this blog

Login with facebook using coldfusion

Image
Here is a example. How to make facebooklogin for a website using coldfusion?. Before start you make a account with facebook. Step 1 :  Create a app for your website using facebooklogin.here you can get app_key and secret_key. Step 2: Step 4:  You can see this screen :   Step 5:   After filling UserName and Password a screen show like this...    After click ok the redirect to logininformation:- Output in logininformation.cfm  I hope this is useful for you. if you are facing any problem write us in comment. we are happy to solve that problem.   For more details visit these links : -   http://developers.facebook.com/docs/facebook-login/   //Permissions   http://developers.facebook.com/docs/reference/login/   https://developers.facebook.com/docs/reference/api/user/
Read more

Create CSV file in Coldfusion Using CFFile

Create CSV file in Coldfusion Using CFFile <cfquery name="GetUsers" datasource="TestDB">     SELECT UserID, UserName, Password,Active,     CASE Active         WHEN 1 THEN 'Active'         WHEN 0 THEN 'InActive'         END AS Status     FROM shema_users        </cfquery> <cfset HeaderColumn = "UserID,UserName,Password,Status"> <CFSET FileOutputPath = "C:\ColdFusion10\cfusion\wwwroot\Test\uploads">                            <CFFILE ACTION="Write" FILE="#FileOutputPath#\Users.csv" OUTPUT="#HeaderColumn#" nameconflict="overwrite" addnewline="yes">                     <cfloop query=...
Read more

Get Previous One Day Data in Sql Server

Get Previous One Day Data in Sql Server using convert(), dateadd(), datediff() and getdate() sql functions and between operator. SELECT OrderID , CustomerID , OrderDateTime FROM [ DEMODB ] . [ dbo ] . [ Orders ] WHERE OrderDateTime   BETWEEN CONVERT ( VARCHAR ( 10 ) ,   DATEADD ( DAY , DATEDIFF ( DAY , 0 , GETDATE ( ) ) , - 1 ) , 101 ) + ' ' + '00:00:00' AND CONVERT ( VARCHAR ( 10 ) ,   DATEADD ( DAY , DATEDIFF ( DAY , 0 , GETDATE ( ) ) , - 1 ) , 101 ) + ' ' + '23:59:59'
Read more