EXEMPLO_1212310
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
SPC_ATUALIZA_LOTE_LIBER
Parameters
Name
Type
Mode
@COLIGADA
smallint
IN
@DATAINICIAL
datetime
IN
@DATAFINAL
datetime
IN
Definition
/* RM Sistemas RM Saldus Tradução do procedimento "AtualizaDataLote" da LRIntegraSaldus.pas para Stored Procedure MSSQL */ CREATE PROCEDURE SPC_ATUALIZA_LOTE_LIBER @COLIGADA SMALLINT, @DATAINICIAL DATETIME, @DATAFINAL DATETIME AS BEGIN UPDATE CLOTE SET DATAINICIAL = @DATAINICIAL, DATAFINAL = @DATAFINAL WHERE CODCOLIGADA = @COLIGADA AND INTEGRAAPLICACAO = 'D' END