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 a traditional network library for sql servers? : Sql server database administration

0 Answers  

---

Can we use max in where clause?

0 Answers  

---

how many no of arguments can be passed in procedures and functions

1 Answers   ABC,

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

0 Answers  

---

What is SQL server agent?

2 Answers   HCL, SAP Labs,

---

Does sql server use java?

0 Answers  

---

When cursors are useful?

0 Answers  

---

How do you start single user mode in clustered installations?

0 Answers  

---

What is the difference between resultset and resultsetmetadata?

0 Answers  

---

How do you troubleshoot errors in a SQL Server Agent Job?

0 Answers  

---

what is a join and explain different types of joins? : Sql server database administration

0 Answers  

---

Can you please explain the difference between primary keys and foreign keys?

0 Answers  

---