title: Conditional operator in Transact-sql
body: <p>Is there a way to do this shorter, for instance using some sort of conditional operator in Transact-sql?</p>
  
  <pre><code>IF @ParentBinaryAssetStructureId = -1
  BEGIN
      SET @ParentBinaryAssetStructureId = NULL
  END
  
  UPDATE  BinaryAssets.BinaryAssetStructures 
  SET     ParentBinaryAssetStructureId = @ParentBinaryAssetStructureId
  WHERE   BinaryAssetStructureId = @OriginalBinaryAssetStructureId
  </code></pre>