SELECT value, label FROM dbo.v_selListVal dbo.stp_listValues_getValidValues DELETE FROM [tblFiles] WHERE (([idxFile] = @Original_idxFile) AND ([Gruppo] = @Original_Gruppo) AND ([IdxPaziente] = @Original_IdxPaziente) 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 [tblFiles] ([Gruppo], [IdxPaziente], [DataMod], [FileName], [ContentType], [Data]) VALUES (@Gruppo, @IdxPaziente, @DataMod, @FileName, @ContentType, @Data); SELECT idxFile, Gruppo, IdxPaziente, DataMod, FileName, ContentType, Data, Size FROM tblFiles WHERE (idxFile = SCOPE_IDENTITY()) SELECT * FROM tblFiles UPDATE [tblFiles] SET [Gruppo] = @Gruppo, [IdxPaziente] = @IdxPaziente, [DataMod] = @DataMod, [FileName] = @FileName, [ContentType] = @ContentType, [Data] = @Data WHERE (([idxFile] = @Original_idxFile) AND ([Gruppo] = @Original_Gruppo) AND ([IdxPaziente] = @Original_IdxPaziente) 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, Gruppo, IdxPaziente, DataMod, FileName, ContentType, Data, Size FROM tblFiles WHERE (idxFile = @idxFile) dbo.stp_file_DeleteQuery dbo.stp_file_getByKey dbo.stp_file_getByPaziente dbo.stp_file_InsertQuery dbo.stp_file_UpdateQuery SELECT value, label, conditio FROM dbo.v_selLabel dbo.stp_labels_getByCond