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
What is the default sql server instance name?
What is the use of partition by in sql server?
What is a result set object returned by mssql_query()?
How do I edit a stored procedure in sql server?
Explain tablesample?
What is a filestream?
What is difference between table aliases and column aliases? Do they affect performance?
What is bulkcopy in sql?
Why we use functions in sql server?
How to create indexed view?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
What does null mean?
What are the 10 characteristics of data quality?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What is a raid and what are different types of raid configurations?