Visual Database Tools and SQL Server Databases

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