marco
27 lines
577 B
Transact-SQL
27 lines
577 B
Transact-SQL
set xact_abort on
|
|
go
|
|
|
|
begin transaction
|
|
go
|
|
|
|
UPDATE dbo.AnagKeyValue SET
|
|
descrizione=N'arrotondamento standard valori'
|
|
WHERE nomeVar=N'minutiRound'
|
|
INSERT INTO dbo.AnagKeyValue
|
|
VALUES (N'minutiRoundDay', 15, NULL, NULL, N'arrotondamento giornaliero')
|
|
INSERT INTO dbo.AnagKeyValue
|
|
VALUES (N'minutiRoundExtraFascia', 15, NULL, NULL, N'arrotondamento periodi fuori fascia ingresso/uscita')
|
|
go
|
|
|
|
commit transaction
|
|
go
|
|
|
|
|
|
|
|
|
|
|
|
-- registro versione...
|
|
INSERT INTO [dbo].[LogUpdateDb] ([Versione],[Data]) VALUES(314, GETDATE())
|
|
GO
|
|
SELECT * FROM LogUpdateDb ORDER BY Versione DESC
|