How can we add a column to a table without altering the
same?
- 4 Answers
- 22439 Views
- BNP Paribas, I also Faced
- E-Mail Answers
Answer Posted / shoaib
you can add new column by using CAST keyword.
Eg:
Suppose your existing table say #EMP contain the following
Columns:
empid,
empname,
empaddr
you want to add empsal columns.
Query:
select
empid,
empname,
empaddr,
(null as decimal(18,2))empsal
from #EMP
into #EMP1;
| Is This Answer Correct ? | 18 Yes | 10 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
