Difference between writing SQL query and stored procedure ?
Answer Posted / senthil kumar
compared with query, stored procedure is efficient and fast
execution.Because stored procedure is program once it
formed then execute as a program.
Is This Answer Correct ? | 90 Yes | 26 No |
Post New Answer View All Answers
Why truncate is ddl?
What is sql injection and why is it a problem? : sql server security
What are the tool windows in sql server management studio? : sql server management studio
Explain the properties of subqueries in sql server?
What are the requirements on sql server network connections?
What are the steps you should follow to start sql server in single-user mode?
How do you manipulate data?
How do you start single user mode in clustered installations?
How to compare the top two records using sql?
What is query parameter in ssrs?
Detail about the hardware which is supported by SQL server?
What are relationships and mention different types of relationships in the dbms
How many database files are there in sql server 2000?what are they?
What is the datatype of rowid?
List out the differences between the clustered index and non-clustered index in sql server?