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
|
|
|
