Just wondering a few queries about the differences between programming SQL
for MS Access, and programming T-SQL for SQL Server.

1. Is it possible to use the same general SQL statements/commands from a ASP
page that was used with a MS Access DB, for a SQL Server DB? (Basically can
you program normal SQL in SQL Server?) If not, what major changes are needed
to convert 'MS Access ASP' pages to 'SQL Server ASP' pages?

2. Does anyone know any good tutorial sites about programming for SQL
Server... with assumption of normal SQL knowledge (eg. MySQL, MS Access).
I've googled/searched around but haven't found anything very useful. If
there isn't any good tutorial/learning sites for T-SQL programming, any
recommendations on a good T-SQL book with references to SQL Server & ASP?

How about if you learn how to post to ONE group next time, instead of
spamming every one with your question? Go buy a book.


--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--


"KevinGPO" <kevingpo@hotmail.com> wrote in message
news:%23zBm3%23H6FHA.1248@TK2MSFTNGP14.phx.gbl...
> Just wondering a few queries about the differences between programming SQL
> for MS Access, and programming T-SQL for SQL Server.
>
> 1. Is it possible to use the same general SQL statements/commands from a
> ASP page that was used with a MS Access DB, for a SQL Server DB?
> (Basically can you program normal SQL in SQL Server?) If not, what major
> changes are needed to convert 'MS Access ASP' pages to 'SQL Server ASP'
> pages?
>
> 2. Does anyone know any good tutorial sites about programming for SQL
> Server... with assumption of normal SQL knowledge (eg. MySQL, MS Access).
> I've googled/searched around but haven't found anything very useful. If
> there isn't any good tutorial/learning sites for T-SQL programming, any
> recommendations on a good T-SQL book with references to SQL Server & ASP?
>
>
>
>
>