Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76857 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / komal sankhe
compared with sql query, stored procedure is efficient and
timesaving execution.Because stored procedure is program
once it formed then execute as a program at the same
time.coz queries are taking the time
| Is This Answer Correct ? | 19 Yes | 22 No |
Post New Answer View All Answers
How to retrieve error messages using odbc_errormsg()?
what are the types of indexes? : Sql server database administration
How to automatically create a log when an exception is being received into SQL Server?
What are the advantages of using cte?
What type of locking occurs during the snapshot generation? : sql server replication
What is the difference between value type and reference type?
Explain optimistic and pessimistic concurrency?
How to use copy and concatenate commands in SQL?
What is the purpose of a table?
Describe in brief sql server monitoring ways.
How can we delete a table in sql server?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
What is database replication? What are the different types of replication you can set up in sql server?
What are the different ways you can create databases in sql server?
What is mscorsvw.exe - process - microsoft .net framework ngen?
