HELP - my virtual directory is not working!

When I follow carefully the instruction inside the book,
I cannot access my virtual directory through url query
(404 page not found error). I am sure that I have allowed
the virtual directory to be queried through url. No
matter where I create the actual path to my virtual
directory, I still got error.
Before setting up the virtual directory, I can access the
files in C:\Inetpub\wwwroot\mydb through url, but after
setting up the virtual directory, what I can get is only
404 error. Could anyone help'What I typed is:
http://myservername/mydb?
sql=select+*+from+tablename+for+xml+uto+root=ROOT
I've got a file named index.htm in
C:\Inetpub\wwwroot\mydb, before settting it as virtual
directory, it works, but after, no luck
>--Original Message--
>When I follow carefully the instruction inside the book,
>I cannot access my virtual directory through url query
>(404 page not found error). I am sure that I have
allowed
>the virtual directory to be queried through url. No
>matter where I create the actual path to my virtual
>directory, I still got error.
>Before setting up the virtual directory, I can access
the
>files in C:\Inetpub\wwwroot\mydb through url, but after
>setting up the virtual directory, what I can get is only
>404 error. Could anyone help'
>.
>

Help - I need a book on SQL

Im trying to write a complicated SQL in analyser using several tables and su
b
selects to do some inserts.
I have to do this very often and I only have a limited knowledge of SQL.
Can you recommend a book I can go out and buy that will teach me how to
write involved SQLs for a beginner please.
(The name and author would be great).
Thanks, and frustrated!If there is one book that I would get this would be it
The Guru's Guide to Transact-SQL
by Ken Henderson
http://www.amazon.com/exec/obidos/t...=glance&s=books
and BOL of course
http://sqlservercode.blogspot.com/|||Very good book for writing queries, specifically (as opposed to db design):
"SQL Queries For Mere Mortals" by Hernandez and Viescas
http://www.amazon.com/gp/product/02...glance&n=283155
NOTE: Celko wrote the Forward to this book - AND the book refers to columns
as fields!!! LOL!!!
"JD" <JD@.discussions.microsoft.com> wrote in message
news:ACA8DD1C-E62E-4AA3-910F-82EEEA6CC2F7@.microsoft.com...
> Im trying to write a complicated SQL in analyser using several tables and
> sub
> selects to do some inserts.
> I have to do this very often and I only have a limited knowledge of SQL.
> Can you recommend a book I can go out and buy that will teach me how to
> write involved SQLs for a beginner please.
> (The name and author would be great).
> Thanks, and frustrated!
>