Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76854 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
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
How many triggers are possible per table?
Give an example of why you would want to denormalize a database
How network traffic be reduced by using the stored procedure?
What are the rendering extensions of ssrs?
What does it mean if @@cursor_row returns a negative number?
Determine how to use the inserted and deleted pseudo tables?
What is the difference between truncate and delete commands?
Do you know what is openxml in sql server?
Can you tell me some of the common replication dmv's and their use? : sql server replication
What is schemabinding a view?
Explain how does the report manager work in ssrs?
What is sql server transaction log file?
How do you identify a foreign key?
What are the different types of replication are there in sql server 2000?
How to replace given values with null using nullif()?
