DELETE FROM [dbo].[ListValues] WHERE (([TableName] = @Original_TableName) AND ([FieldName] = @Original_FieldName) AND ([value] = @Original_value) AND ((@IsNull_label = 1 AND [label] IS NULL) OR ([label] = @Original_label)) AND ((@IsNull_ordinal = 1 AND [ordinal] IS NULL) OR ([ordinal] = @Original_ordinal))) INSERT INTO [dbo].[ListValues] ([TableName], [FieldName], [value], [label], [ordinal]) VALUES (@TableName, @FieldName, @value, @label, @ordinal); SELECT TableName, FieldName, value, label, ordinal FROM ListValues WHERE (FieldName = @FieldName) AND (TableName = @TableName) AND (value = @value) SELECT TableName, FieldName, value, label, ordinal FROM dbo.ListValues UPDATE [dbo].[ListValues] SET [TableName] = @TableName, [FieldName] = @FieldName, [value] = @value, [label] = @label, [ordinal] = @ordinal WHERE (([TableName] = @Original_TableName) AND ([FieldName] = @Original_FieldName) AND ([value] = @Original_value) AND ((@IsNull_label = 1 AND [label] IS NULL) OR ([label] = @Original_label)) AND ((@IsNull_ordinal = 1 AND [ordinal] IS NULL) OR ([ordinal] = @Original_ordinal))); SELECT TableName, FieldName, value, label, ordinal FROM ListValues WHERE (FieldName = @FieldName) AND (TableName = @TableName) AND (value = @value) dbo.stp_listValues_delete dbo.stp_listValues_getByTable dbo.stp_listValues_getDistTable dbo.stp_listValues_insNew dbo.stp_listValues_update SELECT value, label FROM dbo.v_selListVal dbo.stp_listValues_getValidValues dbo.stp_listValues_getValidValuesTrad DELETE FROM [Config] WHERE (([chiave] = @Original_chiave)) INSERT INTO [Config] ([chiave], [valore], [valoreStd], [note]) VALUES (@chiave, @valore, @valoreStd, @note); SELECT chiave, valore, valoreStd, note FROM Config WHERE (chiave = @chiave) SELECT * FROM Config UPDATE [Config] SET [chiave] = @chiave, [valore] = @valore, [valoreStd] = @valoreStd, [note] = @note WHERE (([chiave] = @Original_chiave)); SELECT chiave, valore, valoreStd, note FROM Config WHERE (chiave = @chiave) dbo.stp_confByKey dbo.stp_config_updateQuery DELETE FROM [dbo].[ConfigTmp] WHERE (([sorgente] = @Original_sorgente) AND ([chiave] = @Original_chiave) AND ([valore] = @Original_valore) AND ([note] = @Original_note)) INSERT INTO [dbo].[ConfigTmp] ([sorgente], [chiave], [valore], [note]) VALUES (@sorgente, @chiave, @valore, @note); SELECT sorgente, chiave, valore, note FROM ConfigTmp WHERE (chiave = @chiave) AND (sorgente = @sorgente) SELECT sorgente, chiave, valore, note FROM dbo.ConfigTmp UPDATE [dbo].[ConfigTmp] SET [sorgente] = @sorgente, [chiave] = @chiave, [valore] = @valore, [note] = @note WHERE (([sorgente] = @Original_sorgente) AND ([chiave] = @Original_chiave) AND ([valore] = @Original_valore) AND ([note] = @Original_note)); SELECT sorgente, chiave, valore, note FROM ConfigTmp WHERE (chiave = @chiave) AND (sorgente = @sorgente) dbo.stp_confTemp_getBySorgente dbo.stp_confTemp_insertQuery dbo.stp_confTemp_reset