DataStage - SQL Sever Stored Procedure

GeekInterview.com > Tech FAQs > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 112 of 140

SQL Sever Stored Procedure

How to call a Stored procedure which is in SQL Server database in Datastage job?

Total Answers and Comments: 1

Last Update: September 23, 2009 Asked by: Nithyapriya_Anbumani

What are the differences between stored procedures and triggers?

Stored procedures are compiled collection of programs or SQL statements that live in the database. A stored procedure can access and modify data present in many tables. Also a stored procedure is not associated with any particular database object. But triggers are event-driven special procedures whi

XML Remote Calling Procedure

XML Remote Calling Procedure XML RPC or the XML Remote Calling Procedure is a set of compilations and implementations which allow certain programs to run on complex platforms or operating systems and allows them to make Remote Procedure calls on the Internet The Remote Procedure Calling Protocol use

Procedure for getting Scholarships

Procedure for getting Scholarships If you have done a bit of research you are probably well aware of the fact that there is a great deal of money available for scholarships Having said that it is sad to see that so many students graduate from college with lots of students loans when they could have

How Data Is Stored Within a Data Warehouse

How Data Is Stored Within a Data Warehouse The data that is stored in the data warehouse is just as important as the data warehouse itself Having a fundamental understanding of how this data is stored can be useful in the successful implementation and utilization of a data warehouse One term that yo

Using SQL Sever Management Studio - Part 2

Using SQL Sever Management Studio Part 2 In this tutorial you will learn further more about Using SQL Sever Management Studio Registered Servers To Register a server Server Groups The Summary Page The Database Engine Administration The tasks of a Database Administrator mosgoogle Registered Servers R

Using SQL Sever Management Studio - Part 1

Using SQL Sever Management Studio Part 1 In the tutorial you will learn about Using SQL Sever Management Studio The features of the Management Studio Starting SQL Server Management Studio The Object Explorer and also Default Optional connection settings mosgoogle A Database Administrator typically g

SQL Server Stored Procedures

In this tutorial you will learn further more about Access and Manipulate SQL Server data Using Stored Procedures Creating a Stored Procedure Running Stored Procedures from NET Using Parameters in Stored Procedures The IDENTITY Variable Access and Manipulate SQL Server data Using Stored Procedures mo

Live DataStage Interview Questions

Thanks to our site visitor Manoj for sending these DataStage Interview Questions You can find the updated questions here Live DataStage Interview Questions Published by Manoj G on 05 24 2005 Thanks to our site visitor Manoj for sending these DataStage Interview Questions You can find the updated que

SQL Server 2000: Using System and Extended Stored Procedures

This tutorial covers how to use System Stored Procedures which are stored in master and msdb databases and normally begin with sp and Extended Stored Procedures normally begin with xp Using System Stored Procedures mosgoogle Whenever you add a database add a login create a table or modify any

SQL Server 2000: Securing Your Stored Procedure

This tutorial explains how to secure your stored procedures if you ever need to Procedures resides on the database server in open fashion It means that every body can easily access and view its code Securing Your Stored Procedure mosgoogle Stored Procedures resides on the database server in open f

Featured Free Offers

Request Your Copy

User Name		Remember Me?
Password

Question Bank