If you are working on a SQL database and if suddenly a
developer changes the code and your queries results start
giving errors,how will you check using a T-SQL query (on
system tables) that what has changed in the database.
Answers were Sorted based on User's Feedback
Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What are the restraints imposed on the table design by a merge replication?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
what are constraints? Explain different types of constraints? : Sql server database administration
What is join query?
What is an indexing strategy?
Can the query output be sorted by multiple columns in ms sql server?
what is a self join? Explain it with an example? : Sql server database administration
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)