随笔分类 -  sql server

sqlserver FOR XML PATH 函数用法以及转义字符正常显示
摘要：SELECT *, STUFF( (SELECT TOP 2 '_' + value FROM dbo.SplitString(COE,'_') FOR XML PATH ('row'), ROOT('root'), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, 阅读全文
posted @ 2024-07-12 16:13 暖暖De幸福 阅读(39) 评论(0) 推荐(0)
sqlserver修改实例名称
摘要：if serverproperty('servername') <> @@servername begin declare @server sysname set @server = @@servername exec sp_dropserver @server = @server set @ser 阅读全文
posted @ 2024-06-13 16:29 暖暖De幸福 阅读(271) 评论(0) 推荐(0)
CTE 递归 The statement terminated. The maximum recursion 100 has been exhausted before statement completion.
摘要：The statement terminated. The maximum recursion 100 has been exhausted before statement completion. 解释： 递归超出了最大递归次数，即100，也就是说递归调用的层数超过了100。 解决方法 在使用递归 阅读全文
posted @ 2024-02-05 14:53 暖暖De幸福 阅读(328) 评论(0) 推荐(0)