What are Magic Table?
Answers were Sorted based on User's Feedback
Answer / sonu
show me where Microsoft write about magic table?
This is just interview question that u guys ask.
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / prakash
magic table are thouse on which we manuclate on data
| Is This Answer Correct ? | 10 Yes | 40 No |
Answer / khalid roshan
Update and Delete are the 2 Magic Tables..
| Is This Answer Correct ? | 47 Yes | 79 No |
Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500
What are the Advantages of using CTE in sql server?
What is difference statement and preparedstatement?
What are the purpose of Normalisation?
What is blocking and how would you troubleshoot it?
How many columns can exist together per table?
What is a view?
Explain few examples of stored procedure over triggers?
What is the difference between char and varchar2 datatype in sql?
What are the new security features added in sql server 2012? : sql server security
Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.
Describe in brief sql server monitoring ways.
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)