Differentiate between a primary key and a unique key.

0 Answers  

---

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers  

---

what is bit data type? and what are the information that can be stored inside a bit column?

2 Answers  

---

Explain a differential backup?

0 Answers  

---

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  

---

Why we should not use triggers?

0 Answers  

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

0 Answers  

---

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 Answers  

---

Write a program using SQL queries to find a unique entry in a table.

0 Answers   Tech Mahindra,

---

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

How can we improve performance by using SQL Server profiler?

0 Answers   QuestPond,

---

What is the difference between temp table and table variable?

8 Answers   Microsoft,

---