Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
4| Name | Data Type | Length | Description |
|---|---|---|---|
| @p_cuitbaja | varchar | 30 | |
| @p_cuitalta | varchar | 30 | |
| @p_userid | int | 4 | |
| @p_fecha | date | 3 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.cambios_cuit_bcra
-- Add the parameters for the stored procedure here
@p_cuitbaja varchar(30),
@p_cuitalta varchar(30),
@p_userid int,
@p_fecha date
AS
BEGIN
SET NOCOUNT ON;
begin try
begin
insert into cambios_cuit
(
cuit,
cuit_inactivo,
fecha,
visible,
origen_del_dato ,
created,
modified
)
values
(@p_cuitalta,
@p_cuitbaja,
@p_fecha,
'1',
'BCRA',
GETDATE(),
null)
select 'ok' as ok
end
end try
begin catch
select ERROR_MESSAGE() as error
end catch
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.cambios_cuit_bcra
-- Add the parameters for the stored procedure here
@p_cuitbaja varchar(30),
@p_cuitalta varchar(30),
@p_userid int,
@p_fecha date
AS
BEGIN
SET NOCOUNT ON;
begin try
begin
insert into cambios_cuit
(
cuit,
cuit_inactivo,
fecha,
visible,
origen_del_dato ,
created,
modified
)
values
(@p_cuitalta,
@p_cuitbaja,
@p_fecha,
'1',
'BCRA',
GETDATE(),
null)
select 'ok' as ok
end
end try
begin catch
select ERROR_MESSAGE() as error
end catch
END
GO
Depends On
1Used By
No items found