摘要:
Program using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Data.SqlClient;nam 阅读全文
摘要:
use Myschool--查询对应年级下的人数SELECT COUNT(1) AS '人数' FROM Student WHERE GradeId=1SELECT COUNT(1) AS '人数' FROM Student WHERE GradeId=2SELECT COUNT(1) AS '人数 阅读全文
摘要:
USE Myschool %:匹配0-n个任意字符_:匹配单个字符[]:匹配区间内的值:如[13][^]:不匹配区间内的值 --模糊查询:查询学生表中性"张"的学生记录 SELECT * FROM Student WHERE StudentName LIKE '张' SELECT * FROM St 阅读全文
摘要:
use Myschool--查询GradeId为1的SELECT * FROM Student WHERE GradeId=1--查询学生姓名和年级名称SELECT Student.StudentName,Grade.GradeNema FROM Student,Grade WHERE Studen 阅读全文