Question: Because I just transferred to learning SQL Server from Access, I would like to ask you two questions here: 1. The 'Auto Number field used in Access, what field should be used in SQL Server, if there is no such What kind of way should I do? 2. In Access, set the default value 'now ()', should you set this in SQL Server? Answer: Little demon: The first question can be This field is set to the second question for the Identity field. You can set default (GetDate ()) Xiaolan B: Create Table Tbtest (1, 1), TM DateTime Default getdate ()) Details You can see Books Online, very clear