Answer Posted / durgaprasad

sp_rename 'tablename.oldcolumnname','newcolumnname'

How to write a query with an inner join in ms sql server?

1047

---

SQL Server Architecture ?

2462

---

What is difference between getdate and sysdatetime in sql server 2008?

1048

---

What is delete query?

941

---

How to retrieve error messages using mssql_get_last_message()?

1054

---

What command is used to rename the database?

1014

---

What are the difference between clustered and a non-clustered index?

1043

---

What are different types of constraints?

923

---

How do you rename a table in sql server?

1026

---

Explain what is log shipping?

1136

---

What are the authentication modes in sql server? How can it be changed?

1130

---

How to create a view on an existing table in ms sql server?

1128

---

What is the significance of master, tempdb and model databases?

1080

---

Tell me can we use custom code in ssrs?

1002

---

What is row_number()?

984

---