Feeds:
Posts
Comments

Archive for the ‘Sql Server’ Category

SELECT
CASE WHEN SEX = ‘M’ THEN ‘Male’ ELSE ‘Female’ end as SEX,
CASE WHEN MARITAL_STATUS = ‘M’ THEN ‘Married’ ELSE ‘Unmarried’ end as MARITAL_STATUS,
* FROM  tbl_employeemanagement WHERE     (PkEmpId = 5022)

Advertisements

Read Full Post »