Solved

Batches and stored procedures

Posted on 2011-02-27
2
211 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

724 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