The Microsoft® Visual Database Tools work transparently with SQL Server databases by producing SQL Server-specific SQL commands, recognizing SQL syntax unique to SQL Server, and so on.
In a few instances, however, you will find it useful to know how the Visual Database Tools differ when you are working with SQL Server databases. For example, you might find it helpful to understand how the Query Designer will treat SQL Server-specific syntax if you enter an SQL command yourself, or what operators you can use.
For more information about | See |
Issues and notes for using the Database Designer with SQL Server databases | Database Designer Considerations for SQL Server Databases |
Issues and notes for using the Query Designer with SQL Server databases | Query Designer Considerations for SQL Server Databases |