How can we add a column to a table without altering the
same?
- 4 Answers
- 20633 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
How does sybase replication work?
What are the advantages that you can get from mainframe connect in sybase?
What is the use of 'with check' option in views?
Explain mirroring?
Why am I running out of locks on the replicate side in sybase ?
How do I start sybase control center in windows?
How to remove row affected and dashes?
Explain update statistics.
Differences between clustered and non-clustered in sybase?
Is sybase free?
How to check sybase database status in linux?
What is a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?
Explanation about replication server software?
How do I add a sybase driver to sql developer?
What measures are there to increase the db space?
