Rob Verschoor

In Babelfish, the DATEDIFF() BIF does not recognize the 'weekday' and 'dw' units. All of the below examples are valid in SQL Server. NB. 'weekday' seems to be undocumented: [https://github.com/MicrosoftDocs/sql-docs/blob/live/docs/t-sql/functions/datediff-transact-sql.md.](http://example.com/)...

Babelfish modifies certain identifiers in order to map T-SQL names to PG-compatible names. Examples include index names (which get a hash appended to make them unique in a schema) and...

T-SQL allows referencing objects in remote servers through a 4-part object name as follows: server_name.[database_name].[schema_name].object_name. Babelfish currently supports read access to remote table/views through 4-part names. However, modifying a remote...

T-SQL allows referencing objects in remote servers through a 4-part object name as follows: `server_name.[database_name].[schema_name].object_name`. Babelfish currently supports read access to remote table/views through 4-part names. However, execution of a...

In T-SQL, it is allowed to call a stored procedure, but specify its name in a variable. Reference: https://github.com/MicrosoftDocs/sql-docs/blob/live/docs/t-sql/language-elements/execute-transact-sql.md

The HIERARCHYID datatype is not currently supproted in Babelfish. Reference: https://github.com/MicrosoftDocs/sql-docs/blob/live/docs/t-sql/data-types/hierarchyid-data-type-method-reference.md

DROP TRIGGER currently only supports a single trigger in Babelfish, but multiple triggers can be specified in SQL Server. Reference: https://github.com/MicrosoftDocs/sql-docs/blob/live/docs/t-sql/statements/drop-trigger-transact-sql.md

DROP INDEX currently only supports a single index in Babelfish, but multiple indexes can be specified in SQL Server. Reference: https://github.com/MicrosoftDocs/sql-docs/blob/live/docs/t-sql/statements/drop-index-transact-sql.md

DROP DATABASE currently only supports a single database in Babelfish, but multiple databases can be specified in SQL Server. Reference: https://github.com/MicrosoftDocs/sql-docs/blob/live/docs/t-sql/statements/drop-database-transact-sql.md

In T-SQL, it is possible to drop multiple tables in a single DROP statement. When one of the objects specified does not exist, the others are dropped anyway. However, in...