• 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.
FROM (VALUES('Client '),('Stakeholders'),
('Peers'),('E-Mail ')
) AS sub(Reviewer)

Brought to you by:

Answers (1)