Re: Upgrade from SQL Server 7.0 to 2000

On May 29, 12:41 pm, myright...@xxxxxxxxx wrote:
On May 29, 11:23 am, "Roy.N.Lat...@xxxxxxxxx" <Roy.N.Lat...@xxxxxxxxx>
wrote:

On May 28, 4:03 pm, myright...@xxxxxxxxx wrote:

I am not able to get detail information from what as changed from SQL
Server 7.0 to 2000 from T-SQL commands, statements, syntax etc
standpoint. any help, whitepaper, URL will be highly appreciated.

Thanks

A place to start is BOL (Books On Line) in the "What's New in
Microsoft SQL Server 2000".
You can download the latest BOL from Microsoft.

Roy

Roy:
Thanks for your reply, but i am looking for changes from SQL Server
7.0 to SQL Server 2000 thatinformation is not there from T-SQL
standpoint.

Thanks


Sorry, section I cited groups the enhancements and the links take you
to T-SQL changes.

Alternatively, in BOL:
* set Active Subset to "SQL Programmer: Transact-SQL"
* open up "Transact-SQL reference"
* New and Enhanced Features in Transact-SQL

Roy

.

Relevant Pages

  • Re: Full text setup questions
    ... this is SQL Server T-SQL ... To create the catalog in the IS MMC go to ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Upsize to SQL Server
    ... I feel that with such a model, it will not be easy for me to use the power of T-SQL; I feel uneasy about interjecting an additional connection layer between the app and the db; I feel uneasy about the many posts here about problems associated with this model. ... I use T-SQL when it gives me some positive advantage over Access, enough of an advantage to justify the extra work. ... I can either use T-SQL on the server to create a view or I can write a pass-through query in Access and send raw SQL up to the server. ...
    (comp.databases.ms-access)
  • Re: db restore + transaktionsprotokoll
    ... >> angenommen der server geht kaputt. ... >> nun wie kann ich das via enterprise manager wiederherstellen? ... > verwende T-SQL. ... Dann kannst Du als Rücksicherung from ...
    (microsoft.public.de.sqlserver)
  • Re: Custom Row Functions: Access vs. SQL Server
    ... When compared with other "time" issues like the speed of data over the wire, what other tasks the server might be performing when you ask it to call the function etc, I think I am not going to worry about it, barring Steve coming up with something I have overlooked. ... Is T-SQL really that slow? ... performance is great, but Access works slightly better with the MS SQL Server back-end, and you have to make sure your ODBC settings are just right, for PostgreSQL to work correctly with Access on the front-end. ...
    (comp.databases.ms-access)
  • Re: CONTAINS "irgendwas"?
    ... Aus irgendeinem Grund kann ich nach Auswahl des fraglichen Feldes als Operator nur noch ausschließlich "contains" oder "does not contain" verwenden. ... hast Du einmal einen SQL Server Trace gestartet und beobachtet, was an den Server tatsächlich als T-SQL Statement geschickt wird, wenn Du Deine Eingaben machst. ...
    (microsoft.public.de.sqlserver)
Loading