RE: Learning SQL Server

Peter,

How does the site interact with the Access database? Is it mostly dynamic
SQL, i.e. are the SQL statements generated in the ASP and then sent to the
DB, or are they using parameterized queries?

The answer to that question will determine what path you need to take to
migrate to SQL.

As far as books, do a search for SQL at amazon.com and you should be able to
find more than you could read.


"Peter Byers" wrote:

> Good Morning
> Any recommendations on books (or Web Sites/Pages) as a quick lead in
> to using SQL Server in ASP pages please.
>
> I have a big web site to migrate from Access DataBases to SQL Server
>
> Thank you
> Pete (Northolt UK)
>
>
.

Relevant Pages

  • Re: ASP, looping, and stored procedures.... error 800a0bb9 ...
    ... > page PER loop. ... The looping goes by month from and to dates selected ... > In pure ASP the page takes about 15 seconds. ... > Oh, and by the way, the test box has SQL server and IIS on it. ...
    (microsoft.public.inetserver.asp.db)
  • Only want to insert a record
    ... I'm trying again to develop my web application locally using IIS and asp ... scripting with a local MS Access database. ... The sql works fine within Access itself. ...
    (microsoft.public.data.ado)
  • Re: SQL beginner help
    ... statements that are embedded in the code(Sorta like how I can use SQL ... statements to the server)? ... with the Asp code it will decide what how to handle what the user is able ... But I still need some client side execution;/ I think I got a good picture ...
    (microsoft.public.sqlserver)
  • Re: forum erstellen
    ... >> abhängt ob das Forum funktioniert und weniger von den ASP Kenntnissen ... SQL Abfragen. ... mal Beiträge löschen kann, ...
    (microsoft.public.de.inetserver.iis.asp)
  • Re: SQL beginner help
    ... statements that are embedded in the code(Sorta like how I can use SQL ... statements to the server)? ... so its up to the asp front end to manage security(I guess its better ... But I still need some client side execution;/ I think I got a good picture ...
    (microsoft.public.sqlserver)