How to include date and time values in sql statements?

0 Answers  

---

Can we add a cpu to sql server?

0 Answers  

---

What is 2nf example?

0 Answers  

---

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

0 Answers  

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

Difference between Inner vs outer joins?

0 Answers  

---

What are the operating modes in which database mirroring runs?

0 Answers  

---

What is lock escalation and what is its purpose?

0 Answers  

---

What are page splits? : SQL Server Architecture

0 Answers  

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers  

---

how to invoke a trigger on demand? : Sql server database administration

0 Answers  

---

What is indexed view?

0 Answers  

---