What is the difference between lock, block and deadlock? : sql server database administration
No Answer is Posted For this Question
Be the First to Post Answer
What are some examples of schemas?
how to count datewise data in sqlserver
4 Answers CarrizalSoft Technologies, IndusInd Bank,
Working with TLogs
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is the difference between a stored procedure and a user defined function?
What is the default value of CHAR type?
What is mscorsvw.exe - process - microsoft .net framework ngen?
What are 3 ways to get a count of the number of records in a table?
what is sql injection?
How to select some specific columns from a table in a query in ms sql server?
What is SQL Profiler and the use of it?
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
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)