Define about the Stored Procedure

- It's a set of T-SQL statements combined together to perform a single task formed by combining numerous small tasks.

- When you essentially run a stored procedure, a set of statements is run.

 

Posted Date: 9/7/2013 3:58:17 AM | Location : United States

Ask an Expert

Related Discussions:- Define about the stored procedure, Assignment Help, Ask Question on Define about the stored procedure, Get Answer, Expert's Help, Define about the stored procedure Discussions

Write discussion on Define about the stored procedure
Your posts are moderated

Write your message here..

Related Questions

Data analysis and design, give some example real-life situations where DBMS... give some example real-life situations where DBMS are most suiitabe

The need for three level architecture, The need for three level architectur... The need for three level architecture The aim of the three level architecture is to divide each user's view of the database from the way the database is physically shown.

How to create values of structured type, How to create values of structured... How to create values of structured type? Constructor functions are used to make values of structured types. A function with the similar name as a structured type is a construct

When are they useful justify with an example, When are they useful? Justify... When are they useful? Justify with an example. The temporary tables are commonly used to support specialized rollups or exact application processing needs. Unlike a permanent t

Create a database for store company details, You group has been hired by  T... You group has been hired by  TrainingrUs.com to keeps track of training revenues. TrainingrUS.com wants you to keep scheduling. COURSE table contains following information:

Wound-wait scheme-deadlock prevention, " Wound-wait" scheme : It is based o... " Wound-wait" scheme : It is based on a preemptive method. It is based on a simple rule:                   If Ti requests a database resource that is held by Tj

Objectives of database manangement system, OBJECTIVES After going thro... OBJECTIVES After going through this unit you should be capable to: Explain the File Based system and its limitations; Explain the structure of DBMS; Explain the

Create a company database, Company Database: a-)Here is the ER Model ... Company Database: a-)Here is the ER Model b-)Here is the Relational Model:     IMPORTANT NOTICE FOR SOLUTION TYPE: ***THIS ASSIGNMENT WILL BE SOLVED BY THE

What is candidate key, What is Candidate Key Super Key or Candidate Ke... What is Candidate Key Super Key or Candidate Key: It is such an attribute of a table that can uniquely recognize a row in a table. Generally they have unique values and can n

Define query language, Define query language?   A query is a statement ... Define query language?   A query is a statement requesting the retrieval of information. The portion of DML that includes information retrieval is known as a query language.