sqlserver – SRE笔记

sqlserver uniqueidentifier error

sqlserver 字符转换错误将字符串转换为 uniqueidentifier 时失败不能直接… 继续阅读 sqlserver uniqueidentifier error

key words in sql

数据库关键词转义 — mysql insert into app (name,`key`,secr… 继续阅读 key words in sql

[error] failed to initialize database, got error TLS Handshake failed: tls: server selected unsupported protocol version 301

error: 2022/08/30 21:04:55 D:/Dev/sre/gormSQLServe… 继续阅读 [error] failed to initialize database, got error TLS Handshake failed: tls: server selected unsupported protocol version 301

发表于： 2022-08-30 2022-08-30
作者： JerryMouse, JerryMouse
分类： SRE
标签： bash, sqlserver, tls
发表评论: [error] failed to initialize database, got error TLS Handshake failed: tls: server selected unsupported protocol version 301

com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between “Chinese_PRC_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation.

加一个collate Chinese_PRC_CI_AS SELECT so.name table_… 继续阅读 com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between “Chinese_PRC_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation.

发表于： 2022-02-14 2022-02-14
作者： stnds
分类： SRE
标签： https, jdbc, sql, sqlserver
发表评论: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between “Chinese_PRC_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation.

Cause: com.microsoft.sqlserver.jdbc.SQLServerException: ‘sysdate’ is not a recognized built-in function name. ; uncategorized SQLException; SQL state [S0010]; error code [195]; ‘sysdate’ is not a recognized built-in function name.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: ‘sysdate’ is not a recognized built-in function name.

sysdate 改成getdate

springboot quartz sqlserver 异常 Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR

修改jdbc url： #quartz用到了游标，而sqlserver默认不打开游标 #jdbc.u… 继续阅读 springboot quartz sqlserver 异常 Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR

发表于： 2022-02-13 2022-02-13
作者： stnds
分类： SRE
标签： https, jdbc, springboot, sqlserver
发表评论: springboot quartz sqlserver 异常 Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR

SpringBoot使用SQL Server

pom: <!– SQL server –> <dependency> … 继续阅读 SpringBoot使用SQL Server

System.Data.SqlClient.SqlError: 尚未备份数据库 “test” 的日志尾部。如果该日志包含您不希望丢失的工作，请使用 BACKUP LOG WITH NORECOVERY 备份该日志。请使用 RESTORE 语句的 WITH REPLACE 或 WITH STOPAT 子句来只覆盖该日志的内容。 (Microsoft.SqlServer.Smo) 有关帮助信息，请单击: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=还原+Server&LinkId=20476

System.Data.SqlClient.SqlError: 尚未备份数据库 “test” 的日志… 继续阅读 System.Data.SqlClient.SqlError: 尚未备份数据库 “test” 的日志尾部。如果该日志包含您不希望丢失的工作，请使用 BACKUP LOG WITH NORECOVERY 备份该日志。请使用 RESTORE 语句的 WITH REPLACE 或 WITH STOPAT 子句来只覆盖该日志的内容。 (Microsoft.SqlServer.Smo) 有关帮助信息，请单击: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=还原+Server&LinkId=20476