Difference between writing SQL query and stored procedure ?
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
What are click through reports?
Explain left outer join and right outer join?
What is a unique index?
What is Lock table in SQL?
What command do we use to rename a db, a table and a column?
Is foreign key unique?
Is t sql the same as sql server?
Can a database be shrunk with users active?
Define union, union all, minus, intersect?
How can we determine what objects a user-defined function depends upon?
What are date and time data types in ms sql server?
How do I install sql server?
What are pessimistic lock and optimistic lock?
How do you migrate data from mssql server to azure?
What is sql azure database?