Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
- 0 Answers
- 712 Views
- I also Faced
- E-Mail Answers
Explain for xml explicit mode?
How to locate and take substrings with charindex() and substring() functions?
What is row_number () and partition by in sql server?
How to use the inserted and deleted pseudo tables?
Distinguish between commit and rollback?
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h
Can you explain different types of joins?
What is a transact-sql statement batch in ms sql server?
select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.
Explain what is lock escalation and what is its purpose?
How to convert numeric values to integers in ms sql server?
What is a view?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
