GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Networking  >  Client/Server Computing
Go To First  |  Previous Question  |  Next Question 
 Client/Server Computing  |  Question 43 of 95    Print  
What are Stored procedures?
A stored procedure ia s named collection of SQL statements and procedural logic that is compiled, verified and stored in a server database. It is typically treated like any other database object. Stored procedures accept input parameters so that a single procedure can be used over the network by multiple clients using different input data. A single remote message triggers the execution of a collection of stored SQL statements. The results is a reduction of network traffic and better performance.



  
Total Answers and Comments: 1 Last Update: January 24, 2006   
  
 Sponsored Links

 
 Best Rated Answer
—

No best answer available. Please pick the good answer available or submit your answer.
January 24, 2006 03:48:30   #1  
sithusithu Member Since: December 2005   Contribution: 161    
RE: What are Stored procedures

A stored procedure is a precompiled collection of Transact-SQL statements and optional flow control statements similar to an executable script. Stored procedures are stored and run within the database. You can run a stored procedure with the EXECUTE SQL statement in a database client tool just as you can run SQL statements. Unlike standard SQL however stored procedures allow user-defined variables conditional statements and other powerful programming features.

Cheers

Sithu


 
Is this answer useful? Yes | No

 Related Questions

TP lite, based on stored procedures.TP heavy, based on the TP monitors. 
Latest Answer : Online Transaction Propcessing (OLTP),Online Complex Processing(OLCP) and Online Analytical Processing(OLAP). ...
With a transaction server, the client invokes remote procedures that reside on the server with an SQL database engine. These remote procedures on the server execute a group of SQL statements. The network 
In 2-tier Client/Server systems, the application logic is either burried inside the user interface on the client or within the database on the server.Example: File servers and Database servers with stored 
Latest Answer : Refers to client/server architectures in which the user interface runs on the client and the database is stored on the server. The actual application logic can run on either the client or the server. ...
RPC hides the intricacies of the network by using the ordinary procedure call mechanism familiar to every programmer. A client process calls a function on a remote server and suspends itself until it gets 
A stored procedure ia s named collection of SQL statements and procedural logic that is compiled, verified and stored in a server database. It is typically treated like any other database object. Stored 
Latest Answer : A stored procedure is a precompiled collection of Transact-SQL statements and optional flow control statements, similar to an executable script. Stored procedures are stored and run within the database. You can run a stored procedure with the EXECUTE ...
Triggers are special user defined actions usually in the form of stored procedures, that are automatically invoked by the server based on data related events. It can perform complex actions and can use 
The triggers are called implicitly by database generated events, while stored procedures are called explicitly by client applications. 
Latest Answer : Triggers Are Genrated when Some Invalid Data Filled In The Form, And Rules Are Deployed To The Particular Field It Allows Only Valid Entry.  ...
Latest Answer : Exchange server is used as office's mail server. It collects all the office mails and  exchanges the mails to perticular given mail addresses.In exchange server we have to give the perticular user & it's mail address. ...

 Sponsored Links

 
Related Articles

Linux Thin Client Networks Design and Deployment Review

Linux Thin Client Networks Design and Deployment Review Introduction This book is written by David Richards a veteran Linux thin client network designer Designed for System Administrators Linux Thin Client Networks Design and Deployment goes over the concepts which are related to thin client network
 

SQL Server 2005 Integration Services Review

SQL Server 2005 Integration Services using Visual Studio 2005 A Beginner s Guide SQL Server 2005 A offering of Microsoft Corporation for database management the SQL server 2005 is one of the powerful database management systems in the world Available for integration in almost any system that uses Mi
 

SQL Server Integration Services

SQL Server Integration Services Here is a sample chapter from Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 by Jayaram Krishnaswamy Environment set up for Visual Studio 2005 with respect to SSIS and multiple tasking Connecting to Microsoft Access Text Files Excel S
 

Web Server

Web Server A web server can be a program or the computer itself which receives the requests from various other browsers and responds to those requests These requests are all requests that are being sent for some documents There are two kinds of web servers available The web server program and the
 

Home Networking

Home Networking Home networks are creating the modern day offices at home for individuals who prefer to stay at home while working For domestic usage the home networks found no uses as most people could afford only one computer However there are families that find one computer is not enough for them
 

Exploring Business Networking

Exploring Business Networking Introduction to Business Networking With the dawn of globalization and international business opportunities Business Networking is the latest buzz word among the business communities The Business Networking relies on the principle of sharing expertise knowledge skills s
 

Client-Server Models and N-Tier Applications

Client Server Models and N Tier Applications One of principal objective of Client Server methods is to provide data to an end user However Client Server architectural methodologies are much more complex Client Server describes the process wherein a client program generates contact with a separate se
 

Java and Client Server Models

Java and Client Server Models The Role of Client Servers on the Web Client server models provide the essential mechanisms for working with the Internet In fact most of the World Wide Web is built according to this paradigm In client server models the web browsers run by millions of users are the cli
 

Web Services and Client Server Technology

Web Services and Client Server Technology Introduction to Distributed Computing The Internet and expanded network connectivity established client sever models as the preferred form of distributed computing When talking about Client Server models of networked communication using web services the broa
 

Object-Oriented Client-Server Internet

Object Oriented Client Server Internet OCSI Environments as IT Infrastructure Client Server Basics Object Oriented Client Server Internet OCSI environments provide the IT infrastructure for supporting OCSI applications For our purposes infrastructure refers to operating systems networks middleware
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape