How optimize sql query with multiple joins in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Please differentiate between a local and a global temporary table?
Explain few examples of RDBMS?
What is dml command?
What is difference between TRUNCATE and DELETE statement
What is the command used to recompile the stored procedure at run time?
What is data file in computer?
What are the difference between data length and length in SQL Server-2008?
how to insert the values in 5 table at a time Using any single statement ?
6 Answers Infosys, Value Labs,
i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..
Explain having clause?
Explain what are the authentication modes in sql server?
What is user-defined multi-statement table-valued function?
Oracle (3253)
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)