/**
 *  C U R S O R E S
 */
DECLARE @cod as int
DECLARE @user as varchar(50)
DECLARE @pass as varchar(50)

DECLARE CURSORITO cursor for
    SELECT CliCod, CliUser, CliPass FROM Cliente

OPEN CURSORITO
FETCH NEXT FROM CURSORITO INTO @cod, @user, @pass
WHILE @@fetch_status = 0
BEGIN
    UPDATE Cliente SET CliPass= @user WHERE CliCod=@cod
    
    FETCH NEXT FROM CURSORITO INTO @cod, @user, @pass
END

CLOSE CURSORITO
DEALLOCATE CURSORITO


/**
 *  T R I G G E R S
 */
CREATE TRIGGER tigre_1 ON articulos
    FOR INSERT, UPDATE, DELETE
    AS
    
    IF (SELECT COUNT(*) FROM inserted WHERE cantidad <= 0 )>0
        PRINT "error tigre_1 la cantidad a ingresar debe ser > 1"


/**
 *  S T O R E D   P R O C E D U R E S
 */
CREATE PROCEDURE busco_articulo @cod_art INT AS
SELECT * FROM articulos
		WHERE codigo_articulo = @cod_art
GO

EXEC busco_articulo

/**
 *  V I E W S
 */
CREATE VIEW nombre_vista AS
	SELECT campo_1,.....,campo_n  
		FROM  tabla_1,...,tabla_n
			WHERE condicion_1,..condicion_n


/**
 * T R A N S A C T I O N S
 */
BEGIN TRANSACTION
ROLLBACK TRANSACTION
COMMIT TRANSACTION



<!-- www.000webhost.com Analytics Code -->
<script type="text/javascript" src="http://analytics.hosting24.com/count.php"></script>
<noscript><a href="http://www.hosting24.com/"><img src="http://analytics.hosting24.com/count.php" alt="web hosting" /></a></noscript>
<!-- End Of Analytics Code -->