Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: RE: sql_language digest: March 27, 2001


Message #1 by "Rick Dobson" <rddcab@i...> on Tue, 27 Mar 2001 07:56:46 -0500
Hi Rick,

Thanks for the message.

> In any event, my Professional SQL
> Server Development with Access 2000 includes numerous ASP sample scripts for
> paged datasheets, select boxes, unbound forms, and retrieving graphic
> images.

To be honest all that is basic stuff that I don't need to learn.

I have used VI for creating tables and Queries in SQL and using the query 
builders in Access or VI can do most of what I want.

The problem areas I have are:-

1. Confusion over SQL datatypes - there seem to be a few more than in Access!! 
And it's difficult to know which one to use.

2. Stored Procedures, I've never done these before and would like to learn how 
to trigger them from ASP as well as pass parameters to them.

Overall I would like to have a good reference book that covers the above as 
well as provides a better understanding of the querying language so that I 
don't need to rely on the query builders so much, particularly for Update and 
Insert queries.

Cheers,

Julian Voelcker
The Virtual World (UK) Limited
Cirencester, United Kingdom



  Return to Index