- 博客(5)
- 收藏
- 关注
原创 IDEA操作技巧
IDEA全局搜索快捷键失效@ctrl+shift+FIDEA全局搜索失效首先要考虑快捷键冲突 比如搜狗输入法的简体繁体切换快捷键就是ctrl+shift+F;我把它改为J了,然后IDEA就可以正常使用全局搜索了
2020-09-09 10:09:34 63
原创 SQL-update from首次尝试
update from -sql server## 首次尝试select b.ity_sto_id,b.ity_id,a.oda_ity_id, a.oda_whi_id from dbo.m_order_detail as aleft join dbo.m_inventory as b on a.oda_ity_id = b.ity_idwhere ity_sto_id !=''order by oda_id desc UPDATE aSET a.oda_whi_id = b.ity_
2020-07-22 10:44:21 107
转载 SQL无视约束删除数据
SQL Server 删除当前数据库中所有数据库 ,无视约束-转、自存SQL语句SQL语句EXEC sp_MSForEachTable ‘ALTER TABLE ? NOCHECK CONSTRAINT ALL’EXEC sp_MSForEachTable ‘ALTER TABLE ? DISABLE TRIGGER ALL’EXEC sp_MSForEachTable ‘DELETE FROM ?’EXEC sp_MSForEachTable ‘ALTER TABLE ? CHECK CONST
2020-05-23 08:09:38 433
原创 SQL ZOO-Self join Quiz
2. Select the code that shows the stops that are on route.num ‘2A’ which can be reached with one bus from Haymarket?SELECT S2.id, S2.name, R2.company, R2.num FROM stops S1, stops S2, route R1, rout...
2019-10-09 16:40:31 172
原创 SQLZOO Self join 第十题,这里留下了我的尸体
SQLZOO Self join10.Find the routes involving two buses that can go from Craiglockhart to Lochend.Show the bus no. and company for the first bus, the name of the stop for the transfer,and the bus no. a...
2019-10-09 16:20:23 1320 1
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人