a506602491的专栏

SELECT表名 = case when a.colorder = 1 then d.name else '' end,表说明 = case when a.colorder = 1 then isnull(f.value, '') else '' end,字段序号 = a.colorder,字段名 = a.name,标识 = case when COLUMNPROPERTY(a.id, a.name, 'IsIdentity')= 1 then '√'else '' end,主键 = case

sql判断是否数字ISNUMERICSELECT aaa=case when ISNUMERIC(aaa)=1 then aaa else null endfrom prj_project

Datax执行命令后出现中文乱码的解决办法：控制台出现乱码：直接输入CHCP 65001回车，直到打开新窗口出现Active code page: 65001，然后再输入python datax.py E:\job\20200701120251.json即可

SELECT NEWID(),a.RYBH,NULL,NULL,SUBSTRING(a.ZCZY, b.number, CHARINDEX(',', a.ZCZY+',', b.number)-b.number) AS Specialty,a.ZCZYFROM DataCenter.dbo.XXZX_YPTQY_T_QY_ZYJSRYZCXX a JOIN MASTER.dbo.spt_va...