What are different types of constraints?
No Answer is Posted For this Question
Be the First to Post Answer
check, not null,unique
How many types of Outer Joins?What are they?
Is trigger fired implicitely?
What is the use of SCOPE_IDENTITY() function?
What do you understand by recursive stored procedures?
What are the parts of a function?
What is database isolation in sql server? : sql server database administration
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18
What are the recovery models in sql server 2000?
Can we write a distributed query and get some data which is located on other server and oracle database?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
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)