Answer / ravikv

SP_Rename 'dbo.table_name.column_name','new column_name'.

Answer / ram&saran

SP_RENAME '<table_name>.<old_column_name>','<new_column_name>'

Answer / praveen kumar.dandu

suppose we had a table name emp and columns ename and sal.

<sql>alter table emp rename column sal to salary;


it wll rename the column sal to salary

What is meant by indexing?

0 Answers  

---

How to list all columns in a table using odbc_columns()?

0 Answers  

---

How to round a numeric value to a specific precision?

0 Answers  

---

How to use “drop” keyword in sql server and give an example?

0 Answers  

---

What is the purpose of linked server configuration in sql server?

0 Answers  

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

What are the commands used in DCL?

0 Answers  

---

Explain about nested stored procedure?

0 Answers  

---

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

4 Answers   Wipro,

---

What are the steps need to be take improve the speed of a SQLDATA Server?

2 Answers   IBM,

---

what is datawarehouse?

0 Answers   Informatica,

---

What is the maximum size per database for sql server express?

0 Answers  

---