Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jopp289/domains/progmans.net/public_html/engine/modules/show.short.php on line 160 CASE » Шпаргалки

Заголовок

SQL, T-SQL, Transact-SQL, CASE, WHEN, Условие

Разное

DECLARE @TypeID INT
SET @TypeID = 2

SELECT
CASE
      WHEN @TypeID = 0 THEN 'Тип=0'
      WHEN @TypeID = 1 THEN 'Тип=1'
    ELSE 'х.з.' END

Теги: SQL, T-SQL, Transact-SQL, CASE, WHEN, Условие