Answer Posted / vimal
Store procedure is a pre compiled code
it is doing single task of several task
it is used to reduce the execution time
if we want to call store procedure just we call its name
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
How to write a query with an inner join in ms sql server?
Explain the Ways to improve the performance of a sql azure database?
What is compound operators?
Detail about the hardware which is supported by SQL server?
How do users use Report Builder with SQL Server data sources?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
What is exporting utility?
What are the properties of the relational tables?
Find nth lowest salary or get nth lowest salary?
How can windows applications connect to sql servers via odbc?
What is replication and database mirroring?
Create and insert into temp table in sql server?
how to avoid cursors? : Sql server database administration
How do I find the sql server instance name?