sathish

sathish

  • NA
  • 263
  • 0

varchar declaration in Work_Table

Sep 27 2020 2:42 AM
Hi,
 
 I just want to know how to declare the varchar column in dynamic worktable population
 
SELECT IDENTITY(Int,1,1) RowId,art.Eid as 'EmpID',Ename as 'EmpName', Emplocation,0 IsProcessed
INTO WORK_TABLES.DBO.Emptest
FROM Employee(NOLOCK)
 
In the above example I need to declare one empty column next to EmpName as EmpLocation as 'varchar' (same as default Isprocessed column) and to be update later, since the location details are not available in Employee table.
 
Thanks
Sathish 
 
 

Answers (2)