What is difference between clustered index and non clustered index?
No Answer is Posted For this Question
Be the First to Post Answer
What are the types of lock supported by ?
How to write query to Delete the records in child table and corresponding records in parent table
Explain comment on transactions?
What is the order by used for?
The Difference between 'Count' and 'Count(*)'
How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?
What is Pointer ?
3 Answers Cap Gemini, CarrizalSoft Technologies,
Explain DBCC?
what is meant by sql injection with example and one more question how to catch the errors in sqlserver
What are different types of raid levels?
How to use copy and concatenate commands in SQL?
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