面试记录1
摘要：static void Main(string[] args) { int j = 0; Console.WriteLine("++ j =>" + (++j)); //++ j => 1 int s = 0; Console.WriteLine("s++ =>" + (s++)); //s++ =
阅读全文
posted @
2023-04-18 15:52
诗情寻知己
阅读(13)
推荐(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) 编辑
