Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
1| Name | Data Type | Length | Description |
|---|---|---|---|
| @p_nombre_file | varchar | 200 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
-- =============================================
-- Author: <Samuel Gonzalez>
-- Create date: <06 Feb 2017>
-- Description: <Obtener el último número de línea de la tabla temporal de procesamiento de archivo de altas>
-- =============================================
CREATE OR ALTER PROCEDURE dbo.cheques_obtener_ultima_linea_altas
@p_nombre_file varchar(200)
AS
BEGIN
SET NOCOUNT ON;
select max(nro_linea) as ultima_linea from chequesBCRA_procesamiento_altas where (nombre_file = @p_nombre_file)
END
GO
GO
-- =============================================
-- Author: <Samuel Gonzalez>
-- Create date: <06 Feb 2017>
-- Description: <Obtener el último número de línea de la tabla temporal de procesamiento de archivo de altas>
-- =============================================
CREATE OR ALTER PROCEDURE dbo.cheques_obtener_ultima_linea_altas
@p_nombre_file varchar(200)
AS
BEGIN
SET NOCOUNT ON;
select max(nro_linea) as ultima_linea from chequesBCRA_procesamiento_altas where (nombre_file = @p_nombre_file)
END
GO
Depends On
1Used By
No items found