What is history table in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What are the different types of subquery?
What is 1nf 2nf and 3nf?
What is simple indexing method?
Do you know what is similarity and difference between truncate and delete in sql?
How to create dbo table in sql server?
What it means to be triggered?
What is difference between join and natural join?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L
What are various aggregate functions that are available?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
Write a SQL query to delete a table?
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)