日期型的字段很多都因为超出范围而写不进Sql server里
---------------------------------------------------------------
U can generate a Test Data Profiles for your datetime typecolumn.
First step u can select the datetime column properties of table,
then U can select Test data parameter ... ,and select Test Data Profile Properties
In Detail page, U can define the test data rang of this column
just as :
Date rang
From: Y 2000 M 1 D 1 Values
To: Y 2002 M 12 D 31 * Random
Following U can use Ctr+Shift+D ,Generate Test data script
U can get what u want,that is OK! :)