Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
7| Name | Data Type | Length | Description |
|---|---|---|---|
| @p_cuit | varchar | 20 | |
| @p_id_padron | int | 4 | |
| @p_usuario | varchar | 20 | |
| @p_titulo | varchar | 100 | |
| @p_id_seccion | int | 4 | |
| @p_texto | text | -1 | |
| @p_id_datos_generales | int | 4 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.backend_alta_datos_generales
@p_cuit varchar(20),
@p_id_padron int,
@p_usuario varchar(20),
@p_titulo varchar(100),
@p_id_seccion int,
@p_texto text,
@p_id_datos_generales int
AS
BEGIN
SET NOCOUNT ON;
insert into datos_generales (
cuit,
titulo,
id_seccion,
texto,
visible,
created,
created_by,
id_padron)
values (
@p_cuit,
@p_titulo,
@p_id_seccion,
@p_texto,
'1',
GETDATE(),
@p_usuario,
@p_id_padron)
select '0' as error, 'El registro se grabó satisfactoriamente' as mensaje
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.backend_alta_datos_generales
@p_cuit varchar(20),
@p_id_padron int,
@p_usuario varchar(20),
@p_titulo varchar(100),
@p_id_seccion int,
@p_texto text,
@p_id_datos_generales int
AS
BEGIN
SET NOCOUNT ON;
insert into datos_generales (
cuit,
titulo,
id_seccion,
texto,
visible,
created,
created_by,
id_padron)
values (
@p_cuit,
@p_titulo,
@p_id_seccion,
@p_texto,
'1',
GETDATE(),
@p_usuario,
@p_id_padron)
select '0' as error, 'El registro se grabó satisfactoriamente' as mensaje
END
GO
Depends On
1Used By
No items found