Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76953 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
where the connection string store in the database
What is instead of trigger sql server?
What are different types of collation sensitivity?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
How important do you consider cursors or while loops for a transactional database?
Explain what are sparse columns?
What are constraints in microsoft sql server?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
what is the difference between openrowset and openquery?
Difference between drill down and drill through report.
How does stuff differ from the replace function?
How to loop through result set objects using mssql_fetch_array()?
What are different backups available in sql server?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Explain different types of self contained sub query?
