含有两个主键的批量删除SQL

请教高手，教教我谢谢。或者可以把下面的改写成ALTER PROCEDURE [dbo].[Sys_DictionaryItemDelete]
(
@DictionaryId AS char(5), --字典Id DictionaryId系统层面的应该对于每家客户都是一样。即可删除重新插入
@ItemId AS char(5) --字典项目Id ItemId系统层面的应该对于每家客户都是一样。即可删除重新插入
)
AS
BEGIN
  BEGIN TRY
BEGIN TRAN
UPDATE Sys_DictionaryItem
SET Status=0
WHERE
[DictionaryId] = @DictionaryId AND [ItemId] = @ItemId     COMMIT TRAN;
     RETURN 0 -- Success!!!
  END TRY
谢谢了