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'

Which is better statement or preparedstatement?

878

---

How to recompile stored procedure at run time?

1028

---

Give me any three differences between Truncate and Delete.

1061

---

Explain error and transaction handling in sql server?

967

---

What is the recovery model? List the types of recovery model available in sql server?

858

---

What is a user-defined function in the sql server and what is its advantage?

1058

---

Why would you use sql agent?

1233

---

What are the types of ssrs?

143

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

2191

---

What is 2nf normalization form?

1077

---

What happens if the update subquery returns multiple rows in ms sql server?

1079

---

How to edit table in sql server 2017?

890

---

What are user-defined functions (udfs) in sql server?

950

---

What is the difference between Normalization and De-normalization?

1043

---

How to find out what is the default collation in a database?

1079

---