Re: Suggestions for FREE tutorials or online books/articles for SQL

Jens Schilling wrote:
> Hi, Bob
> 
> Bob Alston wrote:
>> I am trying to upsize to SQL for the first time.
>> Anyone have suggestions of FREE tutorials or online books/articles?
> 
> Taken from my link collection :
> 
> You could start here :
> http://www.aspfaq.com/show.asp?id=2182
> 
> You can find a  miscellaneous collection of do***ents in the download
named 
> "SQL Upsize Docs" here :
> http://www.amazecreations.com/datafast/Download.aspx
> 
> Here's an other article :
> Upsizing to SQL Server
> http://www.aldex.co.uk/sqlupsizing.html
> 
> Here you can find an upsize tool ( which I don't know)
> http://www.andycouch.prodigynet.co.uk/UpsizingTool.htm
> 
> Regards
> Jens
> 
> 
Thanks.

I am still looking for things to help me figure out several things:

1) When I need a query to act as the source for an updatable form, 
should I construct the sql statement in VBA code, adding the selection 
criteria and then enter it as the form source?

2) Use a standard query without criteria as the form source and set the 
filter in the form def

3) same as above for the re****t source?

4) If I am wanting to use a nonupdatable query with parameters,
a)What is the syntax of the stored procedure?
b)What is the syntax of the  query that calls the stored procedure?
    Is this an Access query or a pass through query?

5) I have some multi-layer queries to do summarizations and joins and so 
forth to produce data for re****ts.  Are these best replaced as stored 
procedures or functions?  Need an example.

6) How can I see what is being passed when I execute a form, query or 
re****t so I can evaluate if I have it written correctly for performance?

Thanks

bob
Thanks.