Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-12-30 : 05:04:18
|
| remmas writes "i would like to know what the difference is between the trasact-sql that comes with SyBase and the one that comes with SQL 2000. I just got a book that was published in 1997 by Sybase. Its a book thats teachers the Transact-sql laguage. What my really question is; if i were to study this and learn it, would i be wasting time or the transact-sql that comes with SyBase is compatible with the one of SQL 2000. can i know of any difference that might exist between the transact-sql that comes with MS SQL 2000 and the one that comes with SyBase Adaptive server Enterprise. thank you so much" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-01 : 11:58:47
|
| If you are going to be using SQL Server only, then I don't think that book will help you. There are differences between Sybase and SQL Server, as SQL Server 7.0 and higher have been redesigned by Microsoft and introduced a number of features that differ substantially from its original Sybase roots.The best reference for T-SQL syntax is Books Online. It is installed on your hard drive along with SQL Server, and you can download and/or read it online here:http://www.microsoft.com/sql/techinfo/productdoc/2000/default.asp |
 |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2003-01-02 : 13:06:49
|
| I just finished porting our entire SQL Server code base to Sybase. While the differences are small, I still agree with robvolk that this book will not help you. Instead, learn ANSI SQL and then pick up a book on the specific product that you are interested in. I would recommend this approach.***************************************Death must absolutely come to enemies of the code! |
|
|
|
|
|
|
sybase transact-sql vs sql 2000 transact-sql