Solved

Need a handful or practice queries for an upcoming live test

Posted on 2008-09-29
2
245 Views
Last Modified: 2013-12-07
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
Comment
Question by:newbieweb
2 Comments
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 250 total points
ID: 22602504
0
 
LVL 1

Assisted Solution

by:Digitasupport
Digitasupport earned 250 total points
ID: 22604735
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

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now