Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 77466 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
Can a database be shrunk with users active?
What is sql injection and why is it a problem? : sql server security
How many cores do I need for sql server 2016?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
How can sql server instances be hidden?
What is encryption key?
what is the different types of backups available in sql server? : Sql server database administration
Explain trigger and its types?
What is auditing in sql server?
How do you know if sql server is running on your local system?
What are the properties of the transactions?
What is a non clustered primary key?
How to store and query spatial data?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What is indexing explain it with an example?
