SELECT value, label FROM dbo.v_selScheda dbo.stp_VSS_getByConditio dbo.stp_VSS_getByLang SELECT value, label FROM dbo.v_selListVal dbo.stp_listValues_getValidValues SELECT value, label FROM dbo.v_selFamMacc SELECT value, label FROM dbo.v_selMacchine dbo.stp_VSMac_searchLike SELECT value, label, conditio FROM dbo.v_selElencoDossier dbo.stp_VSED_getByConditio SELECT value, label FROM dbo.v_selFasi dbo.stp_VSF_getByDossier dbo.stp_VSF_getPrev 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_selLingue DELETE FROM [dbo].[Vocabolario] WHERE (([Lingua] = @Original_Lingua) AND ([Lemma] = @Original_Lemma) AND ([Traduzione] = @Original_Traduzione)) INSERT INTO [dbo].[Vocabolario] ([Lingua], [Lemma], [Traduzione]) VALUES (@Lingua, @Lemma, @Traduzione); SELECT Lingua, Lemma, Traduzione FROM Vocabolario WHERE (Lemma = @Lemma) AND (Lingua = @Lingua) SELECT Lingua, Lemma, Traduzione FROM dbo.Vocabolario UPDATE [dbo].[Vocabolario] SET [Lingua] = @Lingua, [Lemma] = @Lemma, [Traduzione] = @Traduzione WHERE (([Lingua] = @Original_Lingua) AND ([Lemma] = @Original_Lemma) AND ([Traduzione] = @Original_Traduzione)); SELECT Lingua, Lemma, Traduzione FROM Vocabolario WHERE (Lemma = @Lemma) AND (Lingua = @Lingua) voc.stp_getByLinguaLemmaLike DELETE FROM [dbo].[tblFiles] WHERE (([idxFile] = @Original_idxFile) AND ([FiltKey] = @Original_FiltKey) AND ([DataMod] = @Original_DataMod) AND ([FileName] = @Original_FileName) AND ([ContentType] = @Original_ContentType) AND ((@IsNull_Size = 1 AND [Size] IS NULL) OR ([Size] = @Original_Size))) INSERT INTO [dbo].[tblFiles] ([FiltKey], [DataMod], [FileName], [ContentType], [Data]) VALUES (@FiltKey, @DataMod, @FileName, @ContentType, @Data); SELECT idxFile, FiltKey, DataMod, FileName, ContentType, Data, Size FROM tblFiles WHERE (idxFile = SCOPE_IDENTITY()) SELECT * FROM dbo.tblFiles UPDATE [dbo].[tblFiles] SET [FiltKey] = @FiltKey, [DataMod] = @DataMod, [FileName] = @FileName, [ContentType] = @ContentType, [Data] = @Data WHERE (([idxFile] = @Original_idxFile) AND ([FiltKey] = @Original_FiltKey) AND ([DataMod] = @Original_DataMod) AND ([FileName] = @Original_FileName) AND ([ContentType] = @Original_ContentType) AND ((@IsNull_Size = 1 AND [Size] IS NULL) OR ([Size] = @Original_Size))); SELECT idxFile, FiltKey, DataMod, FileName, ContentType, Data, Size FROM tblFiles WHERE (idxFile = @idxFile) dbo.stp_file_DeleteQuery dbo.stp_file_getByFiltKey dbo.stp_file_getByKey dbo.stp_file_InsertQuery dbo.stp_file_UpdateQuery SELECT value, label, conditio FROM dbo.v_selRev dbo.stp_VSR_getByDF