daifeng的博客

一：问题及原图问题：查询某一列（字符串，逗号隔开）是否包含某个值。实际生产中问题：查询部门权限二、Mysql的解决办法——FIND_IN_SET函数SQL语句：SELECT dept_id FROM sys_dept WHERE FIND_IN_SET (211, ancestors)查询结果：三、SqlServer的解决办法——charindex函数SQL语句：SELECT dept_id FROM sys_dept WHERE 1=1 and char.

sql中如何把A表某列update成B表某列数据？？update [dbo].[OrderWithDraw] set finishDate=a.update_at from [dbo].AccountsRecord a inner join [dbo].[OrderWithDraw] b on a.RecordID=b.RecordID