Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Set only when variable has value
Message
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2014
Application:
Web
Divers
Thread ID:
01615910
Message ID:
01615911
Vues:
54
This message has been marked as the solution to the initial question of the thread.
Update column value by itself when @Location is empty
CASE WHEN @Location <> '' THEN @Location ELSE Location END
>
>I have a SQL Stored procedure where a certain value is passed as character, as follows:
>
>
>@Location char(20) = '',
>
>
>Then the store procedure should update fields of a table; one of the fields is Location. But the field Location should be updated only if the passed variable @Location has value (not empty).
>
>Can I do it in one SQL Command (instead of using IF)? That is, how would I change the following expression?
>
>update MyTable set Field1 = @Field1, Field2 = @Field2, Location = @Location where Table_pk = 12
>
>
>TIA
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform