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
what purpose does the model database serve? : Sql server database administration
How to view existing indexes on an given table using sys.indexes?
How are the unique and primary key constraints different?
How many tables can be joined in SQL Server?
Is truncate autocommit?
What is the purpose of optimization?
Explain what is log shipping?
Explain multiserver query
Does hive support indexing?
What is normalization? Describe its different types.
What is openrowset sql server?
Is there any difference between the primary key and unique key?
What are the different types of cursor?
What is the osql utility?
Explain comment on transactions?