Difference between writing SQL query and stored procedure ?
Answer Posted / shivangi rastogi
in sql query,there is not security features since when we
write a query in our programe,through ildasm command it
will show thw query to the public.
in stored procedure,we named a set of query & it works as a
file name whenever anyone checks the query it ll find the
procedure name not that query onwhich our programe is
running.
in sql query,if any error in query it ll compiled & show
error at runtime,which is not in stored procedure.
Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
Explain security with sql azure?
What is measure group, measure? : sql server analysis services, ssas
What is a subquery in a select query statement in ms sql server?
List the ways in which dynamic sql can be executed?
How to delete database objects with "drop" statements in ms sql server?
Explain the difference between function and stored procedure?
What is the importance of three tier architecture?
Do you know what are the differences between lost updates and uncommitted dependencies?
How can I create a report based on a query? : sql server management studio
Can we use where clause with group by?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What encryption security is available in sql azure?
What is etl - extraction, transformation, and loading?
What are the different types of sub-queries?
What is store procedure? How do they work? When do you use?