Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
4| Name | Data Type | Length | Description |
|---|---|---|---|
| @formulario | int | 4 | |
| @cod_subramo | int | 4 | |
| @cod_ramo | int | 4 | |
| @descripcion | varchar | 1000 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.backend_modificar_CIUU
@formulario int,
@cod_subramo int,
@cod_ramo int,
@descripcion varchar(1000)
AS
BEGIN
SET NOCOUNT ON;
update ramos
set cod_ramo = @cod_ramo,
descripcion = @descripcion
where cod_subramo = @cod_subramo
and formulario = @formulario
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.backend_modificar_CIUU
@formulario int,
@cod_subramo int,
@cod_ramo int,
@descripcion varchar(1000)
AS
BEGIN
SET NOCOUNT ON;
update ramos
set cod_ramo = @cod_ramo,
descripcion = @descripcion
where cod_subramo = @cod_subramo
and formulario = @formulario
END
GO
Depends On
1Used By
No items found