Is Sybase DB Syntax Same As Sql Server Database

原文地址：https://www.mypassionfor.net/2016/04/21/is-sybase-db-syntax-same-as-sql-server-database/

Sybase is another Relational Database Management System (RDBMS), it has long well established history.  Today Sybase is part of SAP (Since November 2012). But in earlier days Sybase and Microsoft has worked together.

In 1986 Microsoft and Sybase worked together to build a product called Ashton-Tate/SQL Server 1.0. Later in 1993 they dissolved partnership and Microsoft got the code base of SQL Server side of the product and continued their investments into it to have it more adaptable for Windows.

As Sybase and SQL Server has same roots and the core code base which is closely tied with each other then it’s safe to assume that their syntax is very close to each other if it is not 100% same to same.

Besides, I have worked on Oracle in quite detailed level and then I completely focused on Microsoft Technologies. While working with SQL Sever I learned that all databases are derived from some standards like ANSI SQL. Hence, syntax of any two database won’t be much different and besides all of those have support for same database constructs like JOINS, SETS, Query Operators etc. including db objects like Tables, Indexes, Views, Triggers, Stored Procedures etc.

However, I can say that some database may showcase different syntax over another, for example I recall that in Oracle 7.3 for Left Outer Join the operator was “*= ” whereas in SQL Server you can say “LEFT OUTER JOIN”.

So, if someone is really focused on Syntax part and hard core fundamentals concept then it is very easy to reduce the learning curve of any new technology.

About Author

I am Vidya Vrat Agarwal, Software Architect, Author, Microsoft MVP, C# Corner MVP, Speaker, Mentor, and Microsoft .NET Purist. I am TOGAF Certified Architect and a Certified Scrum Master (CSM). Currently working as Principal Architect at T-Mobile Inc. USA. I started working on Microsoft .NET with its 1st beta release.I am passionate about .NET technology and love to contribute to the .NET community. I can be reached at vidya_mct@yahoo.com or twitter @dotnetauthor