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 can you check the version of sql server?

0 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

---

What is data source in connection string?

0 Answers  

---

What is multi-statement table-value user-defined function?

0 Answers  

---

Explain the use of containers in ssis?

0 Answers  

---

---

how to control the amount of free space in your index pages? : Sql server database administration

0 Answers  

---

How does normalization work?

0 Answers  

---

How to provide default values to stored procedure parameters?

0 Answers  

---

Explain the difference between clustered and non-clustered index?

0 Answers  

---

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

8 Answers   Intelenet,

---

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

---

Should you normalize audio?

0 Answers  

---