Answer Posted / manoj pandey

DELETE vs TRUNCATE
Check: http://sqlwithmanoj.wordpress.com/2009/02/22/difference-between-truncate-delete-and-drop-commands/

~Manoj

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

2241

---

Explain about link server in sql server?

1059

---

What are data regions?

135

---

Where the sql logs gets stored?

986

---

List the ways in which dynamic sql can be executed?

1014

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1120

---

How do you use a subquery to find records that exist in one table and do not exist in another?

1049

---

Are resultset updatable?

953

---

Explain can you implement data mining in ssrs?

158

---

What is difference between stored procedure and user defined function?

1106

---

Is t sql the same as sql server?

975

---

What is sub-query in sql server? Explain its properties.

1092

---

How to find index size for each index on table?

1003

---

How do database indexes work?

1010

---

What is model database? : SQL Server Architecture

1131

---