Answer / Payal Agrawal

The model database serves as a template for creating new databases in SQL Server. It contains default settings and system objects that will be used when a new database is created.

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

1 Answers   HCL, Wipro,

---

What is the use of MOVE keyword in restore command

3 Answers   IBM,

---

Difference between: - Delete & Truncate - Table & View - Constraints & Triggers

1 Answers   United Healthcare,

---

Why olap is used?

1 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

5 Answers   Aptech, HCL, Perpetual, SAIC,

---

how many type of subquery?

2 Answers  

---

What is table constraint?

1 Answers  

---

What is the purpose of floor function?

1 Answers  

---

How to create nested stored procedure?

1 Answers  

---

What is the use of stored procedure?

1 Answers  

---

How do you rebuild an identity column?

1 Answers  

---

Determine when to use stored procedure to complete sql server tasks?

1 Answers  

---