• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 287
  • Last Modified:

Need a handful or practice queries for an upcoming live test

I'm  studying  for a live test in  which I'll be put in front of  a  computer and given queries to write.  This is not for a DBA position, it's a C# developer's role.

What kinds of questions would you pose?

I'd love to see them and see how many I could write without getting stumped.  I expect at least a few joins, and imagine at least one where the query is embedded in another querie.  (What's that  called?)



thnks  for  the help,
newbieweb
0
newbieweb
Asked:
newbieweb
2 Solutions
 
Kevin CrossChief Technology OfficerCommented:
0
 
DigitasupportCommented:
What you are referring to is called a 'Nested query'
A query within a query
You need to look at possibly the following query methods:-
Simple selects
Joins (Left , right , inner , outer , Union)
Nested queries.
Updates , Inserts , Deletes , maybe you need to know how to updtae system catalogues as well.
As mentioned above , W3schoools is good , but the beolw i feel is more relavant to you:-
http://msdn.microsoft.com/en-us/library/ms189826.aspx
This is where i would start to research certain query methods , as this will go by the 'Microsoft grian'
Hope that helps you:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now