Answer Posted / rajkumar v

select convert(varchar,getdate(),105)

What is the difference between row_number and dense_rank?

442

---

What is trigger explain with program?

539

---

What are page splits?

585

---

What is page-level compression?

558

---

how to use DTS package in 2000,2005,2008 in sql server

1456

---

---

List out a number of the wants to setup a SQL Server failover cluster?

585

---

How retrieve field names from the table in SQL through JAVA code?

1403

---

What are the steps to insert a table?

541

---

Explain database normalization?

649

---

Can you explain what are commit and rollback in sql?

491

---

What do you think of this implementation? Can this be implemented better?

535

---

Can you use order by when defining a view?

575

---

Explain datetime2 data type in sal server 2008?

549

---

What are examples of triggers?

617

---

What it means to be triggered?

506

---