Answer Posted / durgaprasad

sp_rename 'tablename.oldcolumnname','newcolumnname'

What are ddl (data definition language) statements for tables in ms sql server?

1080

---

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

1075

---

What is scheduled job and how to create it?

967

---

What is the use of =,==,=== operators?

990

---

What are the dis_advantages of stored procedures, triggers, indexes?

2202

---

What is the use of sign function?

1093

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

887

---

How can we rewrite sub-queries into simple select statements or with joins?

964

---

List down some advantages of sql stored procedure?

945

---

What is log cache in sql server?

1021

---

Tell me when is the update_statistics command used?

1082

---

What happens if time-only values are provided as date and time literals?

994

---

How to replace null values in expressions using isnull()?

1080

---

What are the advantages dts has over bcp?

979

---

State the difference between union and union all?

918

---