Answer Posted / ramesh5782

ALTER TABLE table_name
RENAME COLUMN old_name to new_name;

What are drilldown reports?

86

---

Write a SQL query in order to merge two different columns into single column?

629

---

What is difference between createstatement and preparedstatement?

563

---

How can you find out how many rows returned in a cursor?

559

---

What happens if strings are casted into wrong code pages in ms sql server?

570

---

---

What are distinctive joins find as a part of sql?

560

---

What is data file in computer?

547

---

How does the report manager work in SSRS?

116

---

how we use window authentication connection with sql server.?

634

---

What is the cartesian product of the table?

554

---

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

89

---

Explain Normalization and DE normalization

610

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

560

---

please differentiate between delete and truncate?

560

---

What happens if ntwdblib.dll is missing on your machine?

639

---