MS SQL Server ODBC - HELP: migrating/learning T-SQL... from SQL woes :S

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

HELP: migrating/learning T-SQL... from SQL woes :S

KevinGPO

2005-11-13, 1:23 pm

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?

Sponsored Links