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.