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)
What is the difference between cross join and natural join?
How to write a query with an inner join in oracle?
What is compound trigger?
What are the different types of database objects?
What are security principals used in sql server 2005?
How do I install microsoft sql?
Which is better Oracle or MS SQL? Why?
How do I make my sql query run faster?
Is it possible to call a stored procedure within a stored procedure?
How to pipe multiline string to isql?
1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????
List the merits of index covering.
What is the simplest way to create a new database in ms sql server?
Explain about thread and memory management process of SQL?
what is the difference between a having clause and a where clause? : Sql dba