![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQLServer
ac227161
这个作者很懒,什么都没留下…
展开
-
Run SSMS as different Windows user
方法一: shift + 鼠标右击 选择 Run as different user 方法二:Run, 输入以下内容 RunAs /user:DOMAIN\UserName ProgramName 1. 点击 【运行】 2. 输入 RunAs /user:DOMAIN\UserName SSMS.exe, 然后输入该用户密码。 获得更多RunAS参数,在cmd中输入 R原创 2012-09-04 14:10:45 · 832 阅读 · 0 评论 -
FOR XML PATH
I would like to share the approach of ‘FOR XML PATH’. We can use ‘FOR XML PATH’ to concatenate rows, if you have the database 'AdventureWorks' in SQLServer, you can run the following statement, for原创 2012-09-10 10:42:41 · 314 阅读 · 0 评论