Search code examples
sqlcalculated-columns

SQL Computed Column Formula Syntax

I have 3 columns in table name CONTROLLER:

CONTROLLER_ID int, CONTROLLER varchar(10) and VID,

I wanted VID Column to be a calculated column and this syntax works as a query but not when I enter into the Computed Column Formula

SELECT CASE 
         WHEN (CONTROLLER = 'Intel') THEN '666' WHEN (CONTROLLER = 'Mellanox')    
           THEN '777' 
         ELSE '888' 
       END AS VID FROM CONTROLLER

Any help would be much appreciated :-)

Solution

  • The following create table statement works fine for me on MS Sql Server 2017:

    CREATE TABLE CONTROLLER (
  CONTROLLER VARCHAR(10),
  VID AS CASE 
    WHEN (CONTROLLER = 'Intel') THEN '666' 
    WHEN (CONTROLLER = 'Mellanox') THEN '777' 
    ELSE '888' 
  END
)