quote:

---

Originally posted by peace

can you explain how it actually works?

there are no need for select statement right?

---

CREATE TABLE ABC
(
Name varchar(10),
DOB datetime,
Sex bit,
age as case when DATEDIFF(YY,DOB, getdate()) between 50 and 100 then 'Senior Citizen' Else 'Unknown' End, 
Gender as case when Sex = 1 then 'M' Else 'F' End
)

insert ABC (Name,DOb,Sex)
values('John','19870221',1),
('Mary','19780516',0),
('Joseph','19220103',1)


SELECT * FROM ABC



output
-----------------------------------------
Name	DOB	Sex	age	Gender
-----------------------------------------
John	1987-02-21 00:00:00.000	1	Unknown	M
Mary	1978-05-16 00:00:00.000	0	Unknown	F
Joseph	1922-01-03 00:00:00.000	1	Senior Citizen	M

CREATE TABLE testCase
(
id int,
name varchar(10),
DOB date,
sex int,
age as case when DATEDIFF(YY,DOB, getDate()) between 50 and 100 then 'Senior Citizen' Else 'Unknown' End, 
Gender as case when Sex = 1 then 'M' Else 'F' End
)

--Observe this. you are NOT providing data for age and Gender columns
insert into testCase(id, name, DOB, sex) values(1, 'aaa', '1953-10-27', 2)

--Here you can see data for age and Gender columns
SELECT * FROM testCase