Answer Posted / kshirsagar sambhaji

ALTER TABLE table_name
RENAME COLUMN old_name to new_name;

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

3758

---

What are date and time data types in ms sql server?

529

---

What is the return type of executeupdate ()?

525

---

Difference between aggregate functions of sql?

653

---

What is sql server locking?

553

---

---

What is an example of a foreign key?

509

---

How to Update from select query in sql server?

549

---

What do you understand by a stored procedure?

605

---

what stored procedure can you use to display the current processes? : Sql server administration

530

---

What is the purpose of the master database?

602

---

Can we deploy SSRS reports on our personal website?

123

---

What is the maximum number of index per table?

566

---

Relational calculus is what type of language?

579

---

What is log ldf?

555

---

how to take backup bcp out for a column in table in sql server?

1640

---