![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sqlserver
cathylife
终身学习,极致利他
展开
-
SqlServer查询数据库所有的表名称,表说明以及字段详细信息
引用:https://www.cnblogs.com/yujian90/p/11803147.html SELECT 表名称= d.name, 表说明= isnull(f.value,''), 排序号= a.colorder, 列名称= a.name, 列说明= isnull(g.[value],''), 标识列= case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then 1 ...转载 2020-11-24 14:49:53 · 1946 阅读 · 1 评论 -
Sql Server中实现Mysql中的group_concat函数效果
SELECT stuff((select ',' + PUD_Dept from PB_User_Dept t where PUD_User = PUB_ID for xml path('')) , 1 , 1 , '') FROM [dbo].[PB_User_Base] 演绎: SELECT s.order_id,s.goods_id,[sbarcode]=stuff((select ','+[sbarcode] from sbrcode_detail twhere t.order_id...转载 2020-07-31 14:50:06 · 1313 阅读 · 0 评论