Interested to Buy Any Domain ? << Click Here >> for more details...
How can we add a column to a table without altering the
same?
- 4 Answers
- 21986 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
Explain asa, asa ultralite.
Is sybase a database? Explain.
How do I correct time slice -201?
Tempdb is full. How would you clear it?
What is replication server in sybase?
What command helps you to know the process running on this port, but only su can run this command?
How do I create a database in sybase central?
How do I pipe the output of isql to a file in sybase?
What is the difference in storage type of numeric and decimal data types in sybase ?
How would you list objects in sybase?
What are the important features of sybase?
How do I capture a process s sql in sybase?
Is sybase free?
You need to add a notnull column in a table by using alter command (without using default command). How would you do that?
Explain sybase sql server?
