1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| CREATE PROCEDURE dbo.NewUpdateCommand
(
@CodePostalID uniqueidentifier,
@CodePostal nvarchar(15),
@Ville nvarchar(80),
@Pays nvarchar(50),
@DateCreation datetime,
@DateModification datetime,
@ModifieParID uniqueidentifier,
@CreeParID uniqueidentifier,
@Original_CodePostalID uniqueidentifier,
@IsNull_CodePostal nvarchar(15),
@Original_CodePostal nvarchar(15),
@IsNull_Ville nvarchar(80),
@Original_Ville nvarchar(80),
@IsNull_Pays nvarchar(50),
@Original_Pays nvarchar(50),
@IsNull_DateCreation datetime,
@Original_DateCreation datetime,
@IsNull_DateModification datetime,
@Original_DateModification datetime,
@IsNull_ModifieParID uniqueidentifier,
@Original_ModifieParID uniqueidentifier,
@IsNull_CreeParID uniqueidentifier,
@Original_CreeParID uniqueidentifier
)
AS
SET NOCOUNT OFF;
UPDATE [dbo].[CodePostal] SET [CodePostalID] = @CodePostalID, [CodePostal] = @CodePostal, [Ville] = @Ville, [Pays] = @Pays, [DateCreation] = @DateCreation, [DateModification] = @DateModification, [ModifieParID] = @ModifieParID, [CreeParID] = @CreeParID WHERE (([CodePostalID] = @Original_CodePostalID) AND ((@IsNull_CodePostal = 1 AND [CodePostal] IS NULL) OR ([CodePostal] = @Original_CodePostal)) AND ((@IsNull_Ville = 1 AND [Ville] IS NULL) OR ([Ville] = @Original_Ville)) AND ((@IsNull_Pays = 1 AND [Pays] IS NULL) OR ([Pays] = @Original_Pays)) AND ((@IsNull_DateCreation = 1 AND [DateCreation] IS NULL) OR ([DateCreation] = @Original_DateCreation)) AND ((@IsNull_DateModification = 1 AND [DateModification] IS NULL) OR ([DateModification] = @Original_DateModification)) AND ((@IsNull_ModifieParID = 1 AND [ModifieParID] IS NULL) OR ([ModifieParID] = @Original_ModifieParID)) AND ((@IsNull_CreeParID = 1 AND [CreeParID] IS NULL) OR ([CreeParID] = @Original_CreeParID)));
SELECT CodePostalID, CodePostal, Ville, Pays, DateCreation, DateModification, ModifieParID, CreeParID FROM CodePostal WHERE (CodePostalID = @CodePostalID) |
Partager