Forward data type mappings - Microsoft SQL Server example

When creating federated objects, you can use the sample forward type mapping provided for Microsoft SQL Server.

You need to create these mappings before you create a nickname or federated procedure.

CREATE TYPE MAPPING FROM LOCAL TYPE timestamp(3)
   TO SERVER TYPE mssqlserver REMOTE TYPE “datetime”;

CREATE TYPE MAPPING FROM LOCAL TYPE timestamp(0)
   TO SERVER TYPE mssqlserver REMOTE TYPE “smalldatetime”;