Solved

Batches and stored procedures

Posted on 2011-02-27
2
206 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server agent & maintenance task issue ? 8 66
SQl server restarts itself 6 33
SQL Encryption question 2 50
Unable to save view in SSMS 21 60
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

863 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

23 Experts available now in Live!

Get 1:1 Help Now