SQL共4篇
排序
SQL根据查询结果更新数据
一、SQL SERVER 情形1:根据关联字段更新 UPDATE Table_A SET Table_A.col1 = Table_B.col1, Table_A.col2 = Table_B.col2 FROM Some_Table AS Table_A INNER JOIN Other_Table AS Table_B ON Ta...
4年前SQL SERVER插入数据（主键列自增）
插入数据SQL示例： SET IDENTITY_INSERT [dbo].[tb_peidang_rijihua] ON INSERT INTO [dbo].[tb_peidang_rijihua]([id], [chuangjianrenbianhao], [chuangjianshijian], [rijihuabianhao], [riq...
4年前SQL SERVER连接Secure Sockets Layer (SSL) 错误
今天java项目连接sql server突然连接不上了，报如下错误： com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Se...
4年前
MySQL max_allowed_packet错误解决
MySQL查询报错： ### Error querying database. Cause: com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (2,482 > 2,048). You can change this value ...
4年前