03 2022 档案

摘要：使用MySQL将varchar转换成float是报错 执行语句： SELECT CAST(2000 AS FLOAT) as result 错误信息： 1064 - You have an error in your SQL syntax; check the manual that corresp 阅读全文

摘要：获取当前系统时间并从中依次取出对应的年月日和时间和周 select year(now()) as year; select month(now()) as month; select day(now()) as day; select time(now()) as time; SELECT YEAR 阅读全文

摘要：-- 查询死锁 select request_session_id spid, OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT' order 阅读全文