How optimize sql query with multiple joins in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
How can you start sql server in different modes?
What are the types of model in sql server and explain
What are the advantages of stored procedure in sql server?
Explain transaction server auto commit?
Define right outer join?
Can you index views?
Describe triggers features and limitations?
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
What stored by the msdb?
What is the difference between composite index and covering index?
Explain different types of self contained sub query?
How to concatenate two strings in SQL Server.
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)