Main Index o Creating a Trigger o Modifying a Trigger o Renaming a Trigger o Viewing a Trigger o Deleting a Trigger A TRIGGER is a special type of stored procedure, which is ‘fired’ automatically when the data in a specified table is modified. It is invoked when an INSERT, UPDATE, or DELETE action is […]

The stored procedure modification is usually done using the ALTER PROCEDURE statement. It can also be done by deleting the existing stored procedure and then creating a new one with the same name. If we are using the ALTER PROCEDURE statement any of the permissions associated with the stored procedure are retained. In the other […]

Parameters can be passed to the stored procedures. This makes the procedure dynamic. The following points are to be noted: * One or more number of parameters can be passed in a procedure. * The parameter name should proceed with an @ symbol. * The parameter names will be local to the procedure in which […]

It is not true that SQL Server 2000 is better than Oracle 9i or vice versa. Both products can be used to build stable and efficient system and the stability and effectiveness of your applications and databases depend rather from the experience of the database developers and database administrator than from the database’s provider. But […]

Pre-Requisites1) Tomcat 5.02) Apache axis 1.43) jdk 1.4.2 Copy the axis folder (inside D:axis-1_4webapps) into Tomcat webapps folder. 1) Create a simple java program package com.samples.webservice; class HelloWorld { public String displayName(String name) { return “Hello ” + name; } } 2) Copy the class file along with the package structure into D:Tomcat 5.0webappsaxisWEB-INFclasses folder. […]