sql server Json简单操作
摘要：操作环境： SQL Server Management Studio 15.0.18424.0SQL Server 管理对象 (SMO) 16.100.47021.0+7eef34a564af48c5b0cf0d617a65fd77f06c3eb1Microsoft Analysis Service
阅读全文
posted @
2023-05-22 10:50
诗情寻知己
阅读(110)
推荐(0) 编辑
sql server 联表查询删除相关数据
摘要：delete a from tb_a a inner join ( select i.id from tb_a i inner join tb_b b on i.id = b.id ) c on a.id=c.id
阅读全文
posted @
2023-04-14 08:24
诗情寻知己
阅读(61)
推荐(0) 编辑
Sql Server 表列内容逗号隔开转行显示
摘要：兼容中英文逗号：，, SELECT a.id, b.Content FROM ( SELECT id, Content = CAST('<v>' + replace(Content, ',', '</v><v>') + '</v>' AS XML) FROM tb_Content ) a OUTER
阅读全文
posted @
2023-04-13 13:30
诗情寻知己
阅读(261)
推荐(0) 编辑
sql 分页
摘要：declare @pageIndex int = 1, @pageSize int =10 select * from (select row_number() over(order by 排序字段 asc) as num,* from 表名) temp_row where num between
阅读全文
posted @
2022-06-02 08:20
诗情寻知己
阅读(18)
推荐(0) 编辑
