Is truncate autocommit?
No Answer is Posted For this Question
Be the First to Post Answer
How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)
What are the main differences between #temp tables and @table variables and which one is preferred?
What is full outer join in sql server joins?
Mention the uses of stored procedures.
Explain trigger classes i.e. Instead of and after trigger?
What are orphan records?
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?
4 Answers Credit Suisse, GCU, Symphony, TCS,
What are subqueries in sql server?
Can you give an example of Stored Procedure?
Do you know nested transaction?
Can a cursor be updated? If yes, how you can protect which columns are updated?
List the different types of joins?
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)