Notice (8): file_put_contents(): Write of 274 bytes failed with errno=28 No space left on device [CORE/src/Log/Engine/FileLog.php, line 140]

        if (!$mask) {
            file_put_contents($pathname, $message . "\n", FILE_APPEND);

file_put_contents - [internal], line ??
Cake\Log\Engine\FileLog::log() - CORE/src/Log/Engine/FileLog.php, line 140
Cake\Log\Log::write() - CORE/src/Log/Log.php, line 392
Cake\Log\Log::warning() - CORE/src/Log/Log.php, line 477
DebugKit\ToolbarService::isSuspiciouslyProduction() - ROOT/vendor/cakephp/debug_kit/src/ToolbarService.php, line 169
DebugKit\ToolbarService::isEnabled() - ROOT/vendor/cakephp/debug_kit/src/ToolbarService.php, line 105
DebugKit\Plugin::bootstrap() - ROOT/vendor/cakephp/debug_kit/src/Plugin.php, line 48
Cake\Http\BaseApplication::pluginBootstrap() - CORE/src/Http/BaseApplication.php, line 182
Cake\Http\Server::bootstrap() - CORE/src/Http/Server.php, line 111
Cake\Http\Server::run() - CORE/src/Http/Server.php, line 79
[main] - ROOT/webroot/index.php, line 40

Notice (8): SplFileObject::fwrite() [<a href='https://secure.php.net/splfileobject.fwrite'>splfileobject.fwrite</a>]: Write of 284 bytes failed with errno=28 No space left on device [CORE/src/Cache/Engine/FileEngine.php, line 141]

Code Context

        $success = $this->_File->ftruncate(0) &&
            $this->_File->fwrite($contents) &&
            $this->_File->fflush();

SplFileObject::fwrite() - [internal], line ??
Cake\Cache\Engine\FileEngine::set() - CORE/src/Cache/Engine/FileEngine.php, line 141
Cake\I18n\TranslatorRegistry::get() - CORE/src/I18n/TranslatorRegistry.php, line 206
Cake\I18n\I18n::getTranslator() - CORE/src/I18n/I18n.php, line 148
__ - CORE/src/I18n/functions.php, line 45
App\Controller\NewsController::view() - APP/Controller/NewsController.php, line 3420
Cake\Controller\Controller::invokeAction() - CORE/src/Controller/Controller.php, line 539
Cake\Controller\ControllerFactory::handle() - CORE/src/Controller/ControllerFactory.php, line 140
Cake\Controller\ControllerFactory::invoke() - CORE/src/Controller/ControllerFactory.php, line 115
Cake\Http\BaseApplication::handle() - CORE/src/Http/BaseApplication.php, line 317
Cake\Http\Runner::handle() - CORE/src/Http/Runner.php, line 77
Cake\Http\Middleware\CsrfProtectionMiddleware::process() - CORE/src/Http/Middleware/CsrfProtectionMiddleware.php, line 164
Cake\Http\Runner::handle() - CORE/src/Http/Runner.php, line 73
Cake\I18n\Middleware\LocaleSelectorMiddleware::process() - CORE/src/I18n/Middleware/LocaleSelectorMiddleware.php, line 61
Cake\Http\Runner::handle() - CORE/src/Http/Runner.php, line 73
Cake\Http\Middleware\BodyParserMiddleware::process() - CORE/src/Http/Middleware/BodyParserMiddleware.php, line 157
Cake\Http\Runner::handle() - CORE/src/Http/Runner.php, line 73

Notice (8): unserialize() [<a href='https://secure.php.net/function.unserialize'>function.unserialize</a>]: Error at offset 65513 of 65525 bytes [APP/Controller/NewsController.php, line 5571]

Code Context

               {
                      $a=unserialize($line2);
               }

unserialize - [internal], line ??
App\Controller\NewsController::action_cache() - APP/Controller/NewsController.php, line 5571
App\Controller\NewsController::cache_action() - APP/Controller/NewsController.php, line 5281
App\Controller\NewsController::article_show() - APP/Controller/NewsController.php, line 4290
App\Controller\NewsController::view() - APP/Controller/NewsController.php, line 3822
Cake\Controller\Controller::invokeAction() - CORE/src/Controller/Controller.php, line 539
Cake\Controller\ControllerFactory::handle() - CORE/src/Controller/ControllerFactory.php, line 140
Cake\Controller\ControllerFactory::invoke() - CORE/src/Controller/ControllerFactory.php, line 115
Cake\Http\BaseApplication::handle() - CORE/src/Http/BaseApplication.php, line 317
Cake\Http\Runner::handle() - CORE/src/Http/Runner.php, line 77
Cake\Http\Middleware\CsrfProtectionMiddleware::process() - CORE/src/Http/Middleware/CsrfProtectionMiddleware.php, line 164
Cake\Http\Runner::handle() - CORE/src/Http/Runner.php, line 73
Cake\I18n\Middleware\LocaleSelectorMiddleware::process() - CORE/src/I18n/Middleware/LocaleSelectorMiddleware.php, line 61
Cake\Http\Runner::handle() - CORE/src/Http/Runner.php, line 73
Cake\Http\Middleware\BodyParserMiddleware::process() - CORE/src/Http/Middleware/BodyParserMiddleware.php, line 157
Cake\Http\Runner::handle() - CORE/src/Http/Runner.php, line 73
Cake\Routing\Middleware\RoutingMiddleware::process() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 161

Notice (8): unserialize() [<a href='https://secure.php.net/function.unserialize'>function.unserialize</a>]: Error at offset 69621 of 69621 bytes [APP/Controller/NewsController.php, line 5571]

Code Context

               {
                      $a=unserialize($line2);
               }

unserialize - [internal], line ??
App\Controller\NewsController::action_cache() - APP/Controller/NewsController.php, line 5571
App\Controller\NewsController::cache_action() - APP/Controller/NewsController.php, line 5281
App\Controller\NewsController::article_show() - APP/Controller/NewsController.php, line 4310
App\Controller\NewsController::view() - APP/Controller/NewsController.php, line 3822
Cake\Controller\Controller::invokeAction() - CORE/src/Controller/Controller.php, line 539
Cake\Controller\ControllerFactory::handle() - CORE/src/Controller/ControllerFactory.php, line 140
Cake\Controller\ControllerFactory::invoke() - CORE/src/Controller/ControllerFactory.php, line 115
Cake\Http\BaseApplication::handle() - CORE/src/Http/BaseApplication.php, line 317
Cake\Http\Runner::handle() - CORE/src/Http/Runner.php, line 77
Cake\Http\Middleware\CsrfProtectionMiddleware::process() - CORE/src/Http/Middleware/CsrfProtectionMiddleware.php, line 164
Cake\Http\Runner::handle() - CORE/src/Http/Runner.php, line 73
Cake\I18n\Middleware\LocaleSelectorMiddleware::process() - CORE/src/I18n/Middleware/LocaleSelectorMiddleware.php, line 61
Cake\Http\Runner::handle() - CORE/src/Http/Runner.php, line 73
Cake\Http\Middleware\BodyParserMiddleware::process() - CORE/src/Http/Middleware/BodyParserMiddleware.php, line 157
Cake\Http\Runner::handle() - CORE/src/Http/Runner.php, line 73
Cake\Routing\Middleware\RoutingMiddleware::process() - CORE/src/Routing/Middleware/RoutingMiddleware.php, line 161

SQLServer实现跨库跨服务器访问的方法

数据库操作教程 2022-09-23 16:43:26 转载来源: 网络整理/侵权必删

前言我们经常会遇到一个数据库要访问另一个数据库，或者一台服务器要访问另一台服务器里面的数据库。那么这个如何实现的呢？相信看完这篇文章你就懂了！同一台服务器跨库访问实现1.首先创建两个数据库CrossLibraryTable1，CrossLibraryTable2--创建CrossLibraryTable1脚本：usemaster--打开master数据库，一般的创建语句都在master中执行.goifexists(select*fromsysdatabaseswherename='CrossLibraryTable1')dropdatabaseCrossLibraryTable1/*检查有没有这个数据库，如果有就删除它

前言

我们经常会遇到一个数据库要访问另一个数据库，或者一台服务器要访问另一台服务器里面的数据库。那么这个如何实现的呢？相信看完这篇文章你就懂了！

同一台服务器跨库访问实现

1. 首先创建两个数据库CrossLibraryTable1，CrossLibraryTable2

--创建CrossLibraryTable1脚本：

use master --打开master数据库，一般的创建语句都在master中执行.goif exists (select * from sysdatabases where name='CrossLibraryTable1') drop database CrossLibraryTable1 /*检查有没有这个数据库，如果有就删除它。*/gocreate database CrossLibraryTable1on primary(name='CrossLibraryTable1_data', ------------ 养成好习惯,数据文件加_datafilename='F:代码存放数据库CrossLibraryTable1_data.mdf', ------------ 一定要是.mdf的文件,代表主数据文件size=5mb, --默认数据库大小maxsize=100mb, --最大容量filegrowth=1mb --增长量)log on(name='CrossLibraryTable1_log', ------------ 养成好习惯,日志文件加_logfilename='F:代码存放数据库CrossLibraryTable1_log.ldf', ------------ 一定要是.ldf的文件,代表日志文件size=1mb, --默认数据库大小filegrowth=10% --增长量)

--创建CrossLibraryTable2脚本：

use master --打开master数据库，一般的创建语句都在master中执行.goif exists (select * from sysdatabases where name='CrossLibraryTable2') drop database CrossLibraryTable2 /*检查有没有这个数据库，如果有就删除它。*/gocreate database CrossLibraryTable2on primary(name='CrossLibraryTable2_data', ------------ 养成好习惯,数据文件加_datafilename='F:代码存放数据库CrossLibraryTable2_data.mdf', ------------ 一定要是.mdf的文件,代表主数据文件size=5mb, --默认数据库大小maxsize=100mb, --最大容量filegrowth=1mb --增长量)log on(name='CrossLibraryTable2_log', ------------ 养成好习惯,日志文件加_logfilename='F:代码存放数据库CrossLibraryTable2_log.ldf', ------------ 一定要是.ldf的文件,代表日志文件size=1mb, --默认数据库大小filegrowth=10% --增长量)

然后，执行完脚本后，刷新一下就可以看到刚刚创建的数据库了：

2.接下来在两个数据库里面分别创建一个CrossTest1和一个CrossTest2表用于跨库查询

--创建CrossTest1脚本：

 use CrossLibraryTable1 create table CrossTest1( Id int primary key identity, Name nvarchar(20) )

--创建CrossTest2脚本:

 use CrossLibraryTable2 create table CrossTest2( Id int primary key identity, Name nvarchar(20) )

表创建好后，我们再添加几条数据进去:

use CrossLibraryTable1  insert into CrossTest1 values('跨库1测试数据1')  insert into CrossTest1 values('跨库1测试数据2') use CrossLibraryTable2  insert into CrossTest2 values('跨库2测试数据1')  insert into CrossTest2 values('跨库2测试数据2')

切换到CrossLibraryTable1下面查询CrossLibraryTable2的数据可以看到报如下错误

修正代码：

PS：像上面那样是可以进行查询，然而在项目中使用上面的代码格式就会引发一些问题，那什么问题呢？比如另一个数据库的名称改变了，我们就需要把所有用到这个的地方都得改掉，这样就很麻烦，那么有什么解决方案么，使得改一处就好了？当然有，用数据库同义词就可以轻松搞定！

创建同义词步骤如下：

不同服务器跨库访问实现

当数据库在不同服务器上面，用上面的方法就不行了，那如何实现跨服务器访问呢？很简单，看下面↓↓↓

好了，SQL Server跨库跨服务器访问实现就到这了，如果按照步骤一步一步操作的话，相信您也已经实现了，下一篇文章就来谈谈分库分表实现。

总结

以上就是这篇文章的全部内容了，希望本文的内容对大家的学习或者工作具有一定的参考学习价值，谢谢大家对脚本之家的支持。

标签: SQLServer 实现跨库服务器访问方法

声明：本文内容来源自网络，文字、图片等素材版权属于原作者，平台转载素材出于传递更多信息，文章内容仅供参考与学习，切勿作为商业目的使用。如果侵害了您的合法权益，请您及时与我们联系，我们会在第一时间进行处理！我们尊重版权，也致力于保护版权，站搜网感谢您的分享！

上一篇: SQLServer日期和时间的内部存储过程

上一篇: Navicat导出.sql文件方法

娱乐休闲

工商与经济

电脑与网络

公司与企业

教育与培训

文学

艺术

体育与健身

新闻与媒体

卫生与健康

科学/文化

生活与服务

社会性别研究

地球科学

媒体活动

综合网站

健身资料

政治学

地图

棋牌类

综合网站

购物

图书/书店

综合/其他

SQLServer实现跨库跨服务器访问的方法

热门文章

热点

标签列表

分享到:

Copyright @ 2007~2025 All Rights Reserved.

Powered By 站长搜索

SQLServer实现跨库跨服务器访问的方法

猜您喜欢

热门文章

热点

标签列表

分享到:

Copyright @ 2007~2025 All Rights Reserved.

Powered By 站长搜索