You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the rollup operator?
What are cursors? Explain different types of cursors?
Can an extended stored procedure be called from inside a user-defined function?
Explain the role of indexing in databases?
In which table collections errors are stored.
How long can an error message be in raiseerror function?
Define candidate key, alternate key, composite key?
30 Answers IAS, IBM,
Why does this query return 0?
What is bit datatype and what's the information that can be stored inside a bit column?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
How would you design a database for an online site, which would average a million hits a day?
what is Normalization?