Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
5| Name | Data Type | Length | Description |
|---|---|---|---|
| @proceso | varchar | 50 | |
| @cuit | varchar | 20 | |
| @fecha | date | 3 | |
| @procesado | bit | 1 | |
| @prioridad | int | 4 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
-- Create the stored procedure in the specified schema
CREATE OR ALTER PROCEDURE dbo.AfipBatchInsert
@proceso VARCHAR(50),
@cuit VARCHAR(20),
@fecha date,
@procesado BIT,
@prioridad INT
-- add more stored procedure parameters here
AS
BEGIN
-- body of the stored procedure
INSERT INTO consultar_afip (
proceso,
cuit,
fecha,
procesado,
prioridad
) VALUES (
@proceso,
@cuit,
@fecha,
@procesado,
@prioridad
);
--
RETURN;
END
GO
GO
-- Create the stored procedure in the specified schema
CREATE OR ALTER PROCEDURE dbo.AfipBatchInsert
@proceso VARCHAR(50),
@cuit VARCHAR(20),
@fecha date,
@procesado BIT,
@prioridad INT
-- add more stored procedure parameters here
AS
BEGIN
-- body of the stored procedure
INSERT INTO consultar_afip (
proceso,
cuit,
fecha,
procesado,
prioridad
) VALUES (
@proceso,
@cuit,
@fecha,
@procesado,
@prioridad
);
--
RETURN;
END
GO
Depends On
1Used By
No items found