How can we add a column to a table without altering the
same?
- 4 Answers
- 20608 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
What is cmaxpktsz good for in sybase?
You need to multiply all values of a single column. How would you do that?
Why do my page locks not get escalated to a table lock after 200 locks?
How do I remove duplicate rows from a table in sybase?
What causes re-resolution of a stored procedure in sybase?
How to check if sybase database is up and running?
Why place tempdb and log on low numbered devices?
What is open server in sybase?
Explain timestemp datatype in sybase.
How do I turn off marked suspect on my database in sybase?
How would you replicate col = col + 1 in sybase?
How to divide by zero and nulls in sybase?
How to remove row affected and dashes?
How would you configure burn factor in sybase?
What is sybase? What are its important features?
