SQL Server Learning Notes (iv)--Creating table tables

1. Create a new database TestDB

2. Create a new table for the TestDB database userinfo

Create a table named UserInfo, including the above fields, where the ID is the primary key and set the identity specification, Nation set the default value "China".

Add some data to the table:

--using the TestDB database use Testdbgo--view data in a userinfo tableSelect* fromUserInfo--add data records for UserInfo insert into UserInfo values ('1001','Zhang San','123','Wuhan Hongshan District','[email protected]','123456789',default) insert into UserInfo (userid,username,userpwd,phone,nation) VALUES ('1002','John Doe','123','987654321','United States') insert into UserInfo values ('1003','Zhang Five','123','Wuhan Qingshan District','[email protected]','123456780',default)

The results show:

SQL Server Learning Notes (iv)--Creating table tables