Missing sql80.col

Hi...
during an installation of SQL Server 2000 I got the message that the file sql80.col cannot be copied. Can someone please mail it to me or tell me where I can find it.
ThanksPerhaps this information from Microsoft will help...

If English Query is not installed with Microsoft SQL Server 2000, the Help system will access English Query Books Online, Eqdoc.chm, instead of SQL Server Books Online, SQL80.col. However, both documentation files contain essentially the same material about English Query and both provide context-sensitive (F1) Help for English Query. Regardless of the installation scenario, English Query Books Online is available from the English Query program group.|||Thanks for the reply, but that's not it. It's a simple matter of damaged CD media, so file cannot be copied. Since only one file is damaged, I don't want to send the disk back, that would take quite a while. I just need someone to send it to me. It should be in 'C:\Program Files\Microsoft SQL Server\80\Tools\Books' folder. If you have it, please mail it to the following address:

luksa@.bigfoot.com

or just attach it in the forum message.

Thanks|||Hello,

Even i have the same problem. I couldnt find the file SQL80.col. If you have got that file please forward it to me.

I would really appreciate you if you could send me the file. Please send it
to ss53@.uakron.edu

thanks

sivaraj

Originally posted by AgentSmith
Thanks for the reply, but that's not it. It's a simple matter of damaged CD media, so file cannot be copied. Since only one file is damaged, I don't want to send the disk back, that would take quite a while. I just need someone to send it to me. It should be in 'C:\Program Files\Microsoft SQL Server\80\Tools\Books' folder. If you have it, please mail it to the following address:

luksa@.bigfoot.com

or just attach it in the forum message.

Thanks|||BOL can be downloaded from MS.
This is from a standard installation (not SP3).

Missing SELECT statement, but where?

Hi
I have created a question in Access and then copied the SQL question from it.
When I try to run it in eg SQL plus I get an error. I can't see what's wrong.
SQL> SELECT MC_POSUM.ID, MC_POLINE.ID, MC_INVTRANS.TQTY_AMT, MC_PCITEM.ITID, MC_INVTRANS.PRSD_DTTM,
MC_EMPLOYEE.AENM
2 FROM ((((((MC_POSUM INNER JOIN MC_POLINE ON MC_POSUM.POSUMOI = MC_POLINE.PO_OI) INNER JOIN MC_P
ODEL ON MC_POLINE.POLNOI = MC_PODEL.POLINE_OI) INNER JOIN MC_INVTRANS ON MC_PODEL.PODELOI = MC_INVTR
ANS.PODEL_OI) INNER JOIN MC_EMPLOYEE ON MC_INVTRANS.AUDT_USER_OI = MC_EMPLOYEE.EMPOI) INNER JOIN MC_
PCITEM ON MC_POLINE.PCITEM_OI = MC_PCITEM.PCITOI) LEFT JOIN MC_STOREROOM ON MC_INVTRANS.STOR_OI = MC
_STOREROOM.STOROI) INNER JOIN MC_EMPLOYEE AS MC_EMPLOYEE_1 ON MC_POSUM.BUY_OI = MC_EMPLOYEE_1.EMPOI
3 WHERE (((MC_EMPLOYEE_1.AENM) Not Like [MC_EMPLOYEE.AENM]) AND ((MC_STOREROOM.STOROI) Not Like 3
2050) AND ((MC_INVTRANS.TRNTYP) Like 5));
FROM ((((((MC_POSUM INNER JOIN MC_POLINE ON MC_POSUM.POSUMOI = MC_POLINE.PO_OI) INNER JOIN MC_PODEL
*
ERROR at line 2:
ORA-00928: missing SELECT keyword
hi christina,
First off this is a SQL Server newsgroup. So try putting your question in some of the oracle
newgroup/forum. However, with some oracle knowledge i've here are little annotations on my
part.
As far as i know ansi sql syntaxes are only available in oracle from oracle9i so if you are
using oralce8i this is not supported.
Also, enclosing identifiers in square brackets is syntactically correct in SQL Server and not
in Oracle. See following corrected query(should work in oracle9i).
SELECT MC_POSUM.POSUMOI
FROM
--one bracket missing below
(((((((MC_POSUM INNER JOIN MC_POLINE ON MC_POSUM.POSUMOI = MC_POLINE.PO_OI) INNER JOIN
MC_PODEL ON MC_POLINE.POLNOI = MC_PODEL.POLINE_OI) INNER JOIN MC_INVTRANS ON MC_PODEL.PODELOI
= MC_INVTRANS.PODEL_OI) INNER JOIN MC_EMPLOYEE ON MC_INVTRANS.AUDT_USER_OI =
MC_EMPLOYEE.EMPOI) INNER JOIN MC_PCITEM ON MC_POLINE.PCITEM_OI = MC_PCITEM.PCITOI) LEFT JOIN
MC_STOREROOM ON MC_INVTRANS.STOR_OI = MC_STOREROOM.STOROI) INNER JOIN MC_EMPLOYEE
MC_EMPLOYEE_1 ON MC_POSUM.BUY_OI = MC_EMPLOYEE_1.EMPOI) --remove as
WHERE (((MC_EMPLOYEE_1.AENM) Not Like MC_EMPLOYEE.AENM) AND ((MC_STOREROOM.STOROI) Not Like
32050) AND ((MC_INVTRANS.TRNTYP) Like 5)) --no square bracket required.
--End of query
MC_PODEL
Also once where clause is over it is syntactically incorrect to use FROM clause again.
Vishal Parkar
vgparkar@.yahoo.co.in