摘要:
CREATE TABLE UserLog( UserId INT NOT NULL, UpdateDate DATETIME NOT NULL DEFAULT GETDATE(), [Action] VARCHAR(300) NOT NULL)GOINSERT INTO UserLog(UserId,[Action])VALUES(1,'开始')INSERT INTO UserLog(UserId,[Action])VALUES(1,'麦仁')INSERT INTO UserLog(UserId,[Action])VALUES(1,'理事')IN 阅读全文
摘要:
CREATE TABLE Menu( Id INT IDENTITY(1,1), Parent INT NOT NULL, [Name] VARCHAR(20) NOT null)GOINSERT INTO Menu(Parent,[Name]) VALUES(0,'字典')INSERT INTO Menu(Parent,[Name]) VALUES(1,'人')INSERT INTO Menu(Parent,[Name]) VALUES(2,'男人')INSERT INTO Menu(Parent,[Name]) VALUES(2,'女 阅读全文