Answer / vikneswaran

cannot change column name

but can change size of the data type

Answer / desh deepak

sp_rename 'tablename.oldcolumnname',tablenamename.newcolumnn
ame

Answer / kshirsagar sambhaji

ALTER TABLE table_name
RENAME COLUMN old_name to new_name;

How do you delete duplicate rows in sql server?

1 Answers  

---

How can I create a plain-text flat file from SQL Server as input to another application?

2 Answers  

---

What are dml triggers and types of dml triggers?

1 Answers  

---

What is auditing in sql server?

1 Answers  

---

how can i store resumes in database?

3 Answers   HCL,

---

What do you think of this implementation? Can this be implemented better?

1 Answers  

---

Is resultset an interface?

1 Answers  

---

what is cluster and nin-cluster index?

4 Answers  

---

How many columns can exist together per table?

1 Answers   Cap Gemini,

---

How can you tell if a database object is invalid?

1 Answers   MCN Solutions,

---

How to execute stored procedure and set temp table in sql server?

1 Answers  

---

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?

2 Answers   IBM,

---