Solved

Batches and stored procedures

Posted on 2011-02-27
2
205 Views
Last Modified: 2012-05-11
Hi experts,
I have two questions.
One what exactly is a batch and how do you call stored procedures from it
Return a status value to a calling procedure or batch to indicate success or failure and the reason for failure
Seconds,
what does this statement means
"responsible for monitoring of risk batches and fixing problem". does it have to with the sql batches?
risk batches??

It will great if you could provide any help in this regards.

Thanks

0
Comment
Question by:SameerMirza
2 Comments
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 500 total points
ID: 34992716
from : http://msdn.microsoft.com/en-us/library/ms189267.aspx

batch
An SQL batch is a set of one or more Transact-SQL statements sent from a client to an instance of SQL Server for execution. It represents a unit of work submitted to the Database Engine by users.

risk batches are to do with financial batch trading but thats all I know.

from dictionary.com :

batch trading

A trading system for securities in which orders accumulate and then, at specified times, are executed all at once. Batch trading in the U.S. securities markets only is used on opening transactions when orders received after the previous day's close are executed all at one time.
0
 

Author Closing Comment

by:SameerMirza
ID: 35166658
thanks
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now