sqlserver
qq_34412985
Coding make me happy.
展开
-
Conversion failed when converting the varchar value ‘No‘ to data type bit. (245)
[22018] [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting the varchar value 'No' to data type bit. (245)sqlserver的sql语句中union all两段sql语句后,一段是字符串类型'no',一段是数字型0或1因此报错,在union all两段sql语句都加上case when c.IS_NULLABLE=0 then原创 2020-10-30 18:27:31 · 2174 阅读 · 0 评论 -
sqlserver采集字段的sql语句
SELECT CAST ( o.name AS VARCHAR ( 1000 ) ) AS TABLE_NAME, CAST ( c.name AS VARCHAR ( 100 ) ) AS COLUMN_NAME, c.column_id AS ORDINAL_POSITION, c.PRECISION AS DECIMAL_PRECISION, c.SCALE AS NUMERIC_SCALE, SCHEMA_NAME( o.schema_id ) AS ...原创 2020-10-30 18:21:27 · 248 阅读 · 0 评论 -
sqlserver建的空表名报错Invalid object name ‘dbo.sqlserve‘.
select count(*) from (select age,'d71a9917c30841a3bc365c856bc702d3' as MAM_DEPARTMENT from dbo.sqlserve test where (age>='2' or age<='1') ) T原创 2020-10-25 22:22:13 · 1025 阅读 · 0 评论 -
sqlserver没有length函数
2020-10-25 21:15:44.326 ERROR com.pc.data.dataqualitycheck.async.AsyncQalityCheckService Line:244 - 'length' is not a recognized built-in function name.java.sql.SQLException: 'length' is not a recognized built-in function name. at net.sourceforge....原创 2020-10-25 21:38:05 · 3644 阅读 · 0 评论 -
Navicat 连接SQLServer 数据库
连接配置方式如图:有时候Navicat并没有初始化安装sqlncli, 所以连接的时候会报 没有默认驱动,如图:解决方法:在navicat目录下找到对应驱动,点击安装即可, 安装过程中设置为全部允许安装...转载 2020-06-23 10:31:52 · 1138 阅读 · 0 评论 -
亲测navicat连接sqlserver报错 [IM002] [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
报错:[navicat premium] [IM002] [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序解决方式:安装navicat自带sqlncli_x64.msi,就在安装目录下,安装后问题解决原创 2020-06-23 10:28:11 · 1541 阅读 · 0 评论 -
docker安装sqlserver 数据库
具备条件:1.服务器需要大于2G内存。如果不够则可能无法正常启动,查看日志报如下错误:This program requires a machine with at least 2000 megabytes of memory2、获取 sqlserver 镜像$ docker pull mcr.microsoft.com/mssql/server:2017-latest镜像下载成功后,运行镜像$ docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=s原创 2020-06-23 10:24:44 · 3492 阅读 · 0 评论