SELECT * FROM v_selDipendenti ORDER BY label dbo.stp_Dip2Gruppi_delete dbo.stp_VSDip_getByConditio dbo.stp_VSDip_getByGruppo dbo.stp_VSDip_getByRuolo dbo.stp_getLastDays dbo.stp_getMin dbo.stp_getHours SELECT * FROM v_selProgetti dbo.stp_VSPrj_byConditio dbo.stp_VSPrj_byGruppo dbo.stp_VSPrj SELECT value, label, conditio FROM v_selFasi dbo.stp_VSFasi_ByPrj SELECT * FROM v_selClienti ORDER BY label dbo.stp_VSCli_getByConditio dbo.stp_statsProj SELECT value, label FROM dbo.v_selCodGiust dbo.stp_nextValContatore dbo.stp_VSFasiOpt_ByPrj DELETE FROM [dbo].[AnagKeyValue] WHERE (([nomeVar] = @Original_nomeVar) AND ((@IsNull_valInt = 1 AND [valInt] IS NULL) OR ([valInt] = @Original_valInt)) AND ((@IsNull_valFloat = 1 AND [valFloat] IS NULL) OR ([valFloat] = @Original_valFloat)) AND ((@IsNull_valString = 1 AND [valString] IS NULL) OR ([valString] = @Original_valString)) AND ((@IsNull_descrizione = 1 AND [descrizione] IS NULL) OR ([descrizione] = @Original_descrizione))) INSERT INTO [dbo].[AnagKeyValue] ([nomeVar], [valInt], [valFloat], [valString], [descrizione]) VALUES (@nomeVar, @valInt, @valFloat, @valString, @descrizione); SELECT nomeVar, valInt, valFloat, valString, descrizione FROM AnagKeyValue WHERE (nomeVar = @nomeVar) SELECT nomeVar, valInt, valFloat, valString, descrizione FROM dbo.AnagKeyValue UPDATE [dbo].[AnagKeyValue] SET [nomeVar] = @nomeVar, [valInt] = @valInt, [valFloat] = @valFloat, [valString] = @valString, [descrizione] = @descrizione WHERE (([nomeVar] = @Original_nomeVar) AND ((@IsNull_valInt = 1 AND [valInt] IS NULL) OR ([valInt] = @Original_valInt)) AND ((@IsNull_valFloat = 1 AND [valFloat] IS NULL) OR ([valFloat] = @Original_valFloat)) AND ((@IsNull_valString = 1 AND [valString] IS NULL) OR ([valString] = @Original_valString)) AND ((@IsNull_descrizione = 1 AND [descrizione] IS NULL) OR ([descrizione] = @Original_descrizione))); SELECT nomeVar, valInt, valFloat, valString, descrizione FROM AnagKeyValue WHERE (nomeVar = @nomeVar) dbo.stp_AKV_getByKey SELECT value, label FROM dbo.v_selCodOrario SELECT value, label, ordinal FROM v_selPageSize ORDER BY ordinal dbo.stp_VSProjFasi_search dbo.stp_freqProjByDipPeriodo dbo.stp_VSPF_search SELECT value, label FROM dbo.v_selListVal dbo.stp_listValues_getValidValues SELECT * FROM v_selGruppi ORDER BY label dbo.stp_VSGrp_getByConditio SELECT value, label FROM dbo.v_selTagFasi