Maahi

Maahi

  • 1.9k
  • 71
  • 4.6k

Hardcoded values

Sep 15 2017 3:27 AM
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)
 

Brought to you by:

Answers (1)