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;

What is the use of 'with check' option in views?

868

---

A single operation is failing to escalate?

776

---

Explain coalesce. What is the equivalent of oracle/db2 coalesce function in sybase?

807

---

List different types of sybase index.

835

---

Who owns sybase?

806

---

How to check if sybase database is up and running?

801

---

Can I run any transact-sql command on a partitioned table in sybase?

804

---

Explain the advantages of data integration suite in sybase.

843

---

What is server replication?

929

---

How do I open a sybase database?

919

---

How do I force an index to be used in sybase?

799

---

How can I tell the datetime my server started?

916

---

What command helps you to know the process running on this port, but only su can run this command?

868

---

How to connect to sybase database from linux?

929

---

Differentiate between db-lib and ct-lib?

931

---