Answer Posted / mt

select getdate();

Can truncate be rolled back?

545

---

How do I find my localdb version?

497

---

What are the advantages of mirroring?

572

---

What do you mean by collation recursive stored procedure?

593

---

How to change parameter value inside the report?

104

---

---

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

601

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

638

---

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

607

---

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

555

---

What are the types of sql server?

521

---

Write a SQL query to delete a table?

655

---

How to connect Azure federated root database and apply federation in entity framework?

87

---

How to enforce security in sql server? : sql server security

623

---

How to recompile stored procedure at run time?

569

---

Explain some stored procedure creating best practices or guidelines?

524

---