Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76225 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
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
Do you know what is replace and stuff function in sql server?
What is create command?
What is the difference between DataRow.Delete() and DataRow.Remove()?
What are statistics?
Do you know spatial data types - geometry and geography in sql server 2008?
Explain the cursor lock types?
How many triggers are possible per table?
Does windows server 2016 come with sql server?
How to list all stored procedures in the current database using ms sql server?
List the various tools available for performance tuning?
What is an indexing strategy?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
What are the types of stored procedures in an sql server?
