What is a Stored Procedure?

Answer Posted / guest

Its nothing but a set of T-SQL statements combined to
perform a single task of several tasks. Its basically like a
Macro so when you invoke the Stored procedure, you actually
run a set of statements.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps to process a single select statement?

507


What is the purpose of linked server configuration in sql server?

548


Explain data warehousing in sql server?

602


What is stretch database in sql server?

562


What does it mean to manipulate data?

556






Explain identity in sql server?

561


What are the rules to use the rowguidcol property to define a globally unique identifier column?

589


What is the use of =,==,=== operators?

573


How to insert multiple rows with one insert statement in ms sql server?

582


How to check if a table is being used in sql server?

513


What is the difference between function and stored procedure in sql server?

482


Can a table have 2 foreign keys?

499


Explain the microsoft sql server delete command? : SQL Server Architecture

577


What is the full form of ddl?

505


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2080