insert into table_name values (1,'刘世豪','2017-10-21',1,'666@qq.com')
update table_name set name = '张云飞' where id =1
delete from table_name where id = 1
select * from table_name
select * from table_name where name ='刘世豪'
select * from table_name where name like '孙%'
select * from table_name where name like '%层%'
select * from table_name order by gradeid asc
select * from table_name order by gradeid desc
select count(*) 人数,gradeid 年纪 from table_name group by gradeid
select top 20 * from table_name
select top 20 percent * from table_name
select * from table_name where email is null or email =''
select * from table_name t ,grade g where t.gradeid = g.gradeid
select * from table_name t join grade g on t.gradeid = g.gradeid
select count(*) 人数,gradeid 年纪 ,sex 性别 from table_name group by gradeid,sex
select count(*) 人数,GradeId 年级 from Student group by GradeId having count(*)>15
insert into table_name values (1,'刘世豪','2017-10-21',1,default)
select max(StudentResult) 分数,subjectid 科目 from result group by subjectid
select avg(StudentResult) 分数,subjectid 科目 from result group by subjectid
select min(StudentResult) 分数,subjectid 科目 from result group by subjectid
select StudentNo,sum(studentResult) from result group by StudentNo
select a1.* from (select emp.*,rownum rn from emp where rownum <=5) a1 where rn >=3;
select top 4 * from grade where gradeid not in (select top (4*3)-1 gradeid from grade)
SELECT CHARINDEX('m','My Jbns Course')
SELECT len('My Jbns Course')
SELECT UPPER('my is father');
SELECT ltrim(' 你是谁 ')
SELECT rtrim(' 你是谁 ')
SELECT RIGHT('买卖提5吐尔松',4)
SELECT replace('我是谁','我','你')
SELECT stuff('abcdefg',1,5,'明朝的皇帝是谁?')
SELECT getdate()
SELECT DATEADD(yy,5,'01/01/2009')
SELECT DATEDIFF(yy,'2017-05-08','2019-05-04')
SELECT datename(dw,'2015-05-09')
SELECT datepart(day,'2014-05-09')
SELECT rand()
SELECT ceiling(45.6)
SELECT abs(-8)
SELECT floor(32.8)
SELECT power(5,2)
SELECT round(3.1415926,2)
SELECT sign(-1)
SELECT sqrt(9)
SELECT CONVERT (VARCHAR (5),12345)
SELECT CURRENT_USER
SELECT DATALENGTH ('中国A联盟')
SELECT HOST_NAME()
SELECT SYSTEM_USER
SELECT USER_NAME(1)
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 智能桌面机器人:用.NET IoT库控制舵机并多方法播放表情
· Linux glibc自带哈希表的用例及性能测试
· 深入理解 Mybatis 分库分表执行原理
· 如何打造一个高并发系统?
· .NET Core GC压缩(compact_phase)底层原理浅谈
· 新年开篇:在本地部署DeepSeek大模型实现联网增强的AI应用
· DeepSeek火爆全网,官网宕机?本地部署一个随便玩「LLM探索」
· Janus Pro:DeepSeek 开源革新,多模态 AI 的未来
· 上周热点回顾(1.20-1.26)
· 【译】.NET 升级助手现在支持升级到集中式包管理
2017-12-26 ssm中spring mvc找不到控制器,报错404
2017-12-26 没有注册类 (异常来自 HRESULT:0x80040154 (REGDB_E_CLASSNOTREG))