Answer Posted / raghuram
Stored procedure is a set of T-Sql statements combined to
perform a single task of multiple tasks. It do not run
values, It performs only tasks. It reduces network traffic
and improve the performance. It accepts the input
parameters. It helps to ensure the integrity of the
database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the concepts and capabilities of sql server?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
what's the difference between delete table and truncate table commands? : Sql server database administration
Difference between Inner vs outer joins?
What is the difference between implicit and explicit transaction?
What is an identity?
ow to bring suspect mode datbase online from scratch
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Explain some stored procedure creating best practices or guidelines?
Mention the differences between sql server and mysql.
What is the return type of executeupdate ()?
What are relationships and mention different types of relationships in the dbms
How to transfer an existing table from one schema to another schema in ms sql server?
What is query parameter in ssrs?
