Loading

varchar declaration in Work_Table

sathish

6y781

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar6y ago
Accepted answer
Hi,

If you want to take Location Column as null then you can use like this,
declare @Emplocation varchar(200)
set @Emplocation = null

SELECT IDENTITY(Int,1,1) RowId,art.Eid as 'EmpID',Ename as 'EmpName',   @Emplocation as Emplocation,0 IsProcessed
INTO WORK_TABLES.DBO.Emptest
FROM Employee(NOLOCK)
0
sathish6y ago
Thanks Jignesh .
+1