YIXIAO0216的博客

创建表结构。并且添加约束。create table QQUser(QQID bigint primary key,PassWord varchar(50) check(len(PassWord)>=6) not null,LastLogTime datetime not null,Online int check(Online=‘1’ or Online=‘2’ or Online=‘0’),Level int default(0))gocreate table BaseLnfo(

SQL server 第十一章-----连接查询和分组查询课后简答题在前面的NetBar数据库中编写查询语句分别满足以下要求。–一位家长想看看他儿子这个月的上机次数，他儿子的卡号为0023ABC。select CardID, count(1) as 次数from Recordwhere CardID=‘0024_ABD’Group by CardIDgo–查询24小时之内上机的人员姓名列表。select a.[UserNmae]from Card as ainner join R