TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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
Reply
Answers (
2
)
store procedur in Sql Server
How to separate values by stick when Feature values for C and X is dif