TSQL - d'Attribuer de la valeur à partir d'une requête à la variable si l'enregistrement existe en une seule sélectionnez

Comment je peux améliorer le code ci-dessous pour utiliser "select" qu'une seule fois?

IF EXISTS (SELECT [NUMBER] FROM [TABLE] WHERE [ID_RECORD] = @id_record
BEGIN
   DECLARE @tmp_variable
   SELECT @tmp_variable = [NUMBER] FROM [TABLE] WHERE [ID_RECORD] = @id_record

   SET @other_variable = @tmp_variable
END
ELSE
BEGIN
   SET @other_variable = 0
END

OriginalL'auteur rgb | 2013-05-16

  1. 18

    Essayez Ceci : 

     DECLARE @tmp_variable INT
 SET @tmp_variable = ISNULL(( SELECT    [NUMBER]
                              FROM      [TABLE]
                              WHERE     [ID_RECORD] = @id_record
                             ), 0)

    OriginalL'auteur Behrouz Bakhtiari

  2. 6

    D'essayer cette solution:

    DECLARE @tmp_variable int
SET @tmp_variable = null
SELECT @tmp_variable = [NUMBER] FROM [TABLE] WHERE [ID_RECORD] = @id_record

IF @tmp_variable is not null
BEGIN           
   SET @other_variable = @tmp_variable
END
ELSE
BEGIN
   SET @other_variable = 0
END

    OriginalL'auteur Parado