Define about the stored procedure, Database Management System

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







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
Related Questions
give some example real-life situations where DBMS are most suiitabe

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? 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. The temporary tables are commonly used to support specialized rollups or exact application processing needs. Unlike a permanent 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 : 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 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

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 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?   A query is a statement requesting the retrieval of information. The portion of DML that includes information retrieval is known as a query language.