Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
4| Name | Data Type | Length | Description |
|---|---|---|---|
| @cuit | varchar | 20 | |
| @detectado | date | 3 | |
| @publicado | date | 3 | |
| @truncar | bit | 1 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.apocrifas_altas
@cuit varchar(20),
@detectado date,
@publicado date,
@truncar bit = 0
AS
BEGIN
-- select top 10 * from apocrifastest
/*
exec apocrifas_altas '20317226722','2000-12-11','2011-02-14','false'
*/
if (@truncar = 1)
begin
truncate table apocrifas
end
insert into apocrifas (cuit,detectado,publicado,visible)
values (@cuit,@detectado,@publicado,1)
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.apocrifas_altas
@cuit varchar(20),
@detectado date,
@publicado date,
@truncar bit = 0
AS
BEGIN
-- select top 10 * from apocrifastest
/*
exec apocrifas_altas '20317226722','2000-12-11','2011-02-14','false'
*/
if (@truncar = 1)
begin
truncate table apocrifas
end
insert into apocrifas (cuit,detectado,publicado,visible)
values (@cuit,@detectado,@publicado,1)
END
GO
Depends On
1Used By
No items found