Answer Posted / muhammadrashidmughal

select *
from table
where date between '01/01/2003' and '12-31-2008'

or

today is 09-08-2008

select *
from table
where year(date)=year(getdate)-5 and month(date)= '08' and
day(date) ='09'

or

select *
from table
where date >='09-08-2003'
and date<='09-08-2008'

How to query multiple tables jointly?

995

---

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1037

---

What is save transaction and save point?

1210

---

Explain sql delete command?

1062

---

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

150

---

Can I delete event logs?

929

---

A trigger can reference objects outside the current database? State true or false.

1015

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

1012

---

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

977

---

How do you improve the performance of a SQL Azure Database?

137

---

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1120

---

Is it safe to delete log files?

926

---

What is a self join in sql server?

1141

---

What are indexers?

1090

---

What is advantage data architect?

929

---