![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sqlserver
是蓝孩子呀
这个作者很懒,什么都没留下…
展开
-
sqlserver 查询一级部门
WITH cte AS ( SELECT Id, supdepid, departmentname, 0 AS lv FROM HrmDepartment c WHERE id = '当前部门id' UNION ALL SELECT d.Id, d.supdepid, d.departmentname, lv + 1...原创 2018-11-02 10:06:49 · 1189 阅读 · 0 评论 -
Microsoft SQL Server,错误: 924
USE master;GODECLARE @SQL VARCHAR(MAX);SET @SQL=''SELECT @SQL=@SQL+'; KILL '+RTRIM(SPID)FROM master..sysprocessesWHERE dbid=DB_ID('ecology');EXEC(@SQL);GOALTER DATABASE ecology SET MULTI_USER...原创 2018-11-12 10:40:19 · 1797 阅读 · 0 评论 -
sqlserver2008R2 dblink oracle11g
1.查看是否有oracle 的访问接口OraOLEDB.Oracle ,如果没有需要安装oracle 客户端2. exec sp_addlinkedserver '自定义链接名字','Oracle','OraOLEDB.Oracle','数据库地址' exec sp_addlinkedsrvlogin '自定义链接名字', false, null, '账号', '密码'3.修...原创 2019-03-15 17:54:33 · 589 阅读 · 0 评论