Answer Posted / sanjay

ALTER TABLE tablename CHANGE oldname newname varchar (10) ;

Explain how dts is used to extract, transform and consolidate data?

1048

---

How to delete duplicate rows?

1039

---

What is ms sql server service broker?

1044

---

What is the Difference Between Primary and Foreign Key?

1067

---

Can I disable or restrict ssrs export formats (rendering formats)?

155

---

Define inner join in sql server joins?

1125

---

List out different types of normalizations in sql server and explain each of them?

975

---

What is update_statistics command?

1121

---

Can We Use Data-grids For Our Report In Ssrs?

188

---

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1248

---

What is the use of “join” in sql server?

1158

---

Can you use order by when defining a view?

1022

---

What is difference between rollback immediate and with no_wait during alter database?

1134

---

How does stuff differ from the replace function?

1064

---

Explain full-text query in sql server?

1054

---