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;

You need to remove the affected rows and dashes. How would you do that?

936

---

How to change varchar(m) to varchar(n) in sybase?

963

---

Must I use multiple devices to take advantage of partitions in sybase?

927

---

How do I turn off marked suspect on my database in sybase?

884

---

Does sybase support row level locking?

876

---

Explain the advantages of data integration suite in sybase.

872

---

Explanation about replication server software?

945

---

How can I improve throughput in sybase?

933

---

Who owns sybase?

849

---

Explain timestemp datatype in sybase.

976

---

How to delete unix files which are more than 3 days old?

900

---

How do I configure identities in sybase?

862

---

List the types of locking?

1012

---

Does table partitioning require user-defined segments in sybase?

800

---

Can two tasks be assigned to the same partition in sybase?

821

---