Going to Access to learn SQL Server

zhaozj2021-02-08  211

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

转载请注明原文地址:https://www.9cbs.com/read-2091.html

New Post(0)