When to use Inner join & when to use subquery?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Explain the concept of recursive stored procedure.

0 Answers  


OPTIMIZATION OF SP,CURSOR,TRIGGERS

0 Answers  


Why SQL Agent is used?

0 Answers   Abacus,


What does REVERT do in SQL Server 2005?

0 Answers   HCL,


How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

15 Answers   Leo Technologies, Mannar Company, Synechron,






how can we use a composite key for two tables and how can we represent it

1 Answers   BoA,


What is user-defined scalar function?

0 Answers  


How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  


What is importing utility?

0 Answers  


What is normalization and what are the different forms of normalizations?

2 Answers  


What are the pre-defined functions in the sql server?

0 Answers  


How are the unique and primary key constraints different?

0 Answers  


Categories