marco
128 lines
2.6 KiB
Transact-SQL
128 lines
2.6 KiB
Transact-SQL
set xact_abort on;
|
|
go
|
|
|
|
begin transaction;
|
|
go
|
|
|
|
alter table AnagKeyValue alter column
|
|
valString nvarchar(250);
|
|
go
|
|
|
|
alter table AnagKeyValue add
|
|
constraint DF_AnagKeyValue_valInt default ((0)) for valInt,
|
|
constraint DF_AnagKeyValue_descrizione default ('-') for descrizione,
|
|
constraint DF_AnagKeyValue_valFloat default ((0)) for valFloat,
|
|
constraint DF_AnagKeyValue_valString default ('') for valString;
|
|
go
|
|
|
|
commit;
|
|
go
|
|
|
|
|
|
set xact_abort on;
|
|
go
|
|
|
|
begin transaction;
|
|
go
|
|
|
|
alter table Dipendenti add
|
|
dataAssunzione date constraint DF_Dipendenti_dataAssunzione default ('1900-01-01'),
|
|
dataCessazione date constraint DF_Dipendenti_dataCessazione default ('9999-12-31'),
|
|
attivo bit constraint DF_Dipendenti_attivo default ((1));
|
|
go
|
|
|
|
update Dipendenti set dataAssunzione=('1900-01-01'),dataCessazione=('9999-12-31'),attivo=((1));
|
|
go
|
|
|
|
set ANSI_NULLS on;
|
|
go
|
|
|
|
-- =============================================
|
|
-- Author: S.E. Locatelli
|
|
-- Create date: 2013-03-25
|
|
-- Description: Recupero elenco dip attivi
|
|
-- =============================================
|
|
create PROCEDURE stp_Dip_getAttivi
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT *
|
|
FROM Dipendenti
|
|
WHERE (attivo = 1)
|
|
go
|
|
|
|
commit;
|
|
go
|
|
|
|
|
|
set xact_abort on;
|
|
go
|
|
|
|
begin transaction;
|
|
go
|
|
|
|
set ANSI_NULLS on;
|
|
go
|
|
|
|
/**********************************************************
|
|
* STORED stp_AKV_getByKey
|
|
*
|
|
* elenco valori da chiave x tab anagrafica key/val
|
|
*
|
|
* mod: S.E.L. 2013.03.25
|
|
*
|
|
**********************************************************/
|
|
create PROCEDURE stp_AKV_getByKey
|
|
(
|
|
@nomeVar NVARCHAR(50)
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT nomeVar
|
|
,ISNULL(valInt,0) AS valInt
|
|
,ISNULL(valFloat,0) AS valFloat
|
|
,ISNULL(valString,'') AS valString
|
|
,ISNULL(descrizione,'') AS descrizione
|
|
FROM AnagKeyValue
|
|
WHERE nomeVar = @nomeVar
|
|
go
|
|
|
|
commit;
|
|
go
|
|
|
|
set xact_abort on
|
|
go
|
|
|
|
begin transaction
|
|
go
|
|
|
|
UPDATE dbo.AnagKeyValue SET
|
|
valFloat=0, valString=N''
|
|
WHERE nomeVar=N'minutiRound'
|
|
UPDATE dbo.AnagKeyValue SET
|
|
valFloat=0, valString=N''
|
|
WHERE nomeVar=N'minutiRoundDay'
|
|
UPDATE dbo.AnagKeyValue SET
|
|
valFloat=0, valString=N''
|
|
WHERE nomeVar=N'minutiRoundExtraFascia'
|
|
INSERT INTO dbo.AnagKeyValue
|
|
VALUES (N'appMode', 0, 0, N'runtime', N'modalità applicazione (runtime)')
|
|
INSERT INTO dbo.AnagKeyValue
|
|
VALUES (N'installazione', 0, 0, N'ETS', N'nome installazione')
|
|
INSERT INTO dbo.AnagKeyValue
|
|
VALUES (N'ETS', 10, 0, N'+FBqyG1V4kqbqYe/IO7KywpmR9YzujB0', N'licenze e codice auth applicativo')
|
|
go
|
|
|
|
commit transaction
|
|
go
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-- registro versione...
|
|
INSERT INTO [dbo].[LogUpdateDb] ([Versione],[Data]) VALUES(320, GETDATE())
|
|
GO
|
|
SELECT * FROM LogUpdateDb ORDER BY Versione DESC
|