中国网络(86SQL.COM)企业邮件系统

Tried putting it into 1st, it feels like it’s in 3rd.

If this just seemed to happen for very little reason,its the linkage and if you look under the bonnet and towards the gearbox,you will probably see the link arm thats come off.You can put it back on its socket and with careful changes will last a while Try to replace it as they invariably keep coming off,dont be tempted to tape or wire it on,it makes it worse.I do believe the maestro and montego linkage is the same as they used the vw box,but the linkage may vary.good luck

This question is driving me crazy. Any SQL gurus out there?

Which clause is not allowed in a subquery?
a. From
b. Where
c. Group By
d. Having
e. Order By
f. Is Null
g. Is Not Null
h. Like

(Similar question)
Subqueries cannot
a. Use group by or group functions
b. Be used in multiple and/or predicates of the same outer query
c. Join tables
d. Appear in Select, Update, Delete, Insert statements
e. Retrieve from a table different than the outer query

Some of these answers are obviously wrong, but I cannot find any documentation anywhere about the other possibilities.

First one to show me the way (hyperlink with proof) gets 10 points!

Subqueries cannot use group by or group functions. So "Group By" clause is not allowed in a subquery:

http://www.access-programmers.co.uk/forums/showthread.php?t=99476

Woo Pokemon!!

I have 3 tables. Each contains data about shipments. Several fields are the same, but each has some that are different. I need to be able to pull the distinct SO# (sales order numbers) and WO# (work order numbers) from all 3 tables based on a customer name. I’ve tried joining the tables and selecting out this data, but I apparently don’t know how to do it correctly, because I keep getting errors. Please help.

SELECT DISTINCT CustomerName, ServiceOrderNo, WorkOrderNo
FROM CustomerTable
INNER JOIN WorkOrderTable ON CustomerName.CustomerNo = WorkOrderTable.CustomerNo
INNER JOIN ServiceOrderTable ON CustomerName.CustomerNo = ServiceOrderTable.CustomerNo

If you need futher detail from the tables then use the above as a nested query within the larger query (email me with full details if you need further assistance)

I posted a note by mistake to the wrong group. Luckily the moderator has to approve the first approve the post. I sent an email over to them, but I want to take corrective action first.

if the moderator does approve it, you can delete your own post off the group- over to the left while the post is open to read while on the group, you’ll see delete- this only deletes it off the home page though, members will still get it in their in boxes.
I hope moderator get’s your e-mail to delete it

Can you take the sperm that were caught in the condom and insert into vagina manually right after sex and get pregnant???? Does anyone know?
It’s just a question. I’m not asking what’s easier just curious as to if it can be done. I need serious answers please!!!
some people need to look up how long sperm lives outside the body because it does not die when it hits the air.

You are describing artificial insemination. Sperm can be collected and stored for weeks under the right conditions.

sql and sql server
"structured query language""sql" server this two are same or there is any difference. i ask about sql server they said me that sql server is used for .net.
what is the use of "sql"
only "sql "friends
in oracle also there is a sql and plsql are this all are same
and also "
mysql"
i want to learn only "structure query language" but i confused what name should i say to any institute to learn "sql"
because didnot understand which is correct could you please give me a name which is correct to use

SQL (Structured Query Language) is a coding use to retrieve, modify and update a data on a database. However database varies from operating system, type of application and from server to server. For linux it is usually mySql, windows is MSSQL and also separate for Oracle. If you will use for web development, if your server is linux you cannot use MSSql instead use mySql in combination of Php. For windows server use MSSql using .NET technology.

I am planning to make a career change and hoped that someone might have some advice regarding qualifications etc. I currently work in editing in film/TV and want to make a change to database administration. I will shortly be taking my Comptia a+ exams as a first start and want to know the best study route, ie what exams should I do next MCPs, etc etc? I plan to self study as much as possible. Also any advice about where to look for jobs and applying for them would be great.

If your looking to going database administration the A+ is not really going to help you. It not bad cert but it deals with computer repair and not database.

The MCTS, The oracle certs are also good. Although certs and no replacement for a degree or experience.

I could also take a look at places like http://www.setfocus.com/ Although most places like that require you to understand the basics before you can even get into there programs.

I need to embed text into an image
using either Server side Script or DLL, API calls or TSQL ! etc
This is not putting text on top of an image in an HTML page its similar to adding a permanent watermark.

Can someone supply the code ?

Thanks in advance

I did this in C# /.NET

Essentially…every time someone uploaded a image…the code dynamically makes sure to make a thumbnail for it for preview purposes…including resizing the image and adding text to it.

Good tutorial below:

http://www.codeproject.com/csharp/watermark.asp

My son is now in the process of writing his query letter for a literary agent.
For all the authors, how long should it be?

Approx. 2 paragraphs.

No more than a single page. It should include a summary of the book, word count, genre, and your sons publication history.