Sql Server doesn't have date data type. You can use datetime data type with NULL's instead of empty dates.

>I want to convert a vfp db to a sqlserver db manually.
>How can i know the type of field for sqlserver
>
>like the date type
>
>VFP
>----
>DATE
>
>SQLSERVER
>---------
>?????????