复制--创建表 CREATE TABLE dbo.Tab ( ID int NOT NULL IDENTITY (1,解决句 1), Y varchar(20) NOT NULL, X datetime NOT NULL ) GO --插入数据 INSERT INTO Tab(Y, X) values(BBB, 2007-10-23 11:11:11) INSERT INTO Tab(Y, X) values(BBB, 2007-10-23 11:11:11) INSERT INTO Tab(Y, X) values(BBB, 2007-10-23 10:10:10) INSERT INTO Tab(Y, X) values(AAA, 2007-10-23 12:12:12) INSERT INTO Tab(Y, X) values(AAA, 2007-10-23 10:10:10) INSERT INTO Tab(Y, X) values(AAA, 2007-10-23 11:11:11) GO 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16. |
喜欢
讨厌