How to create indexed view?

0 Answers  

---

How do you test your database? : sql server database administration

0 Answers  

---

What are the default system databases in sql server 2000?

0 Answers  

---

Explain the purpose of indexes?

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   HCL, Wipro,

---

---

What is the difference between a check constraint and a rule?

0 Answers  

---

How can I get data from a database on another server?

0 Answers  

---

You want to implement the many-to-many relationship while designing tables. How would you do it?

0 Answers  

---

What are different types of subquery?

0 Answers  

---

What are the different methods available under sqlcommand class to access the data?

0 Answers   UGC Corporation,

---

How many databases instances are there in sql server 2000?

0 Answers  

---

Can group functions be used in the order by clause in ms sql server?

0 Answers  

---