Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Need a handful or practice queries for an upcoming live test

Posted on 2008-09-29
2
Medium Priority
?
286 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 60

Accepted Solution

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

Assisted Solution

by:Digitasupport
Digitasupport earned 1000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Suggested Courses

926 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