Samuele E. Locatelli
45 lines
701 B
Transact-SQL
45 lines
701 B
Transact-SQL
set xact_abort on
|
|
go
|
|
|
|
begin transaction
|
|
go
|
|
|
|
set ANSI_NULLS on
|
|
go
|
|
|
|
/*************************************
|
|
* STORED PROCEDURE stp_STM_setInsEnabled
|
|
* imposta stato amcchian x permettere o meno caricamento
|
|
*
|
|
* modif.: S.E.L.
|
|
* il: 2014.01.10
|
|
**************************************/
|
|
create PROCEDURE stp_STM_setInsEnabled
|
|
(
|
|
@idxMacchina NVARCHAR(50),
|
|
@insEnabled BIT
|
|
)
|
|
AS
|
|
|
|
-- ATTIVO/DISATTIVO il caricamento degli eventi
|
|
UPDATE DatiMacchine
|
|
SET insEnabled = @insEnabled
|
|
WHERE IdxMacchina = @IdxMacchina
|
|
|
|
RETURN
|
|
go
|
|
|
|
commit
|
|
go
|
|
|
|
|
|
|
|
|
|
|
|
-- registro versione...
|
|
INSERT INTO [dbo].[LogUpdateDb] ([Versione],[Data]) VALUES(414, GETDATE())
|
|
GO
|
|
|
|
SELECT TOP 10 * FROM LogUpdateDb ORDER BY Versione DESC
|
|
GO
|