1
Reply

Hardcoded values

Maahi

Maahi

Sep 15 2017 3:27 AM
153
In sql i have employee master table.
 
Select empname,empid, empdeparment
from tblemployeemaster
 
How can i add one more columns without creating an static column in table with 4 hardcode values is an script how to bind this employee master.
 
SELECT *
FROM (VALUES('Client '),('Stakeholders'),
('Peers'),('E-Mail ')
) AS sub(Reviewer)
 

Answers (1)