最好看的小说排行,完美世界辰东小说,武道至尊帝临小说

国产成人精品999视频&日本一区二区亚洲人妻精品&久久久精品国产99久久精&99热这里只有成人精品国产&精品国产剧情av一区二区&成人亚洲精品久久久久app&国产精品美女高潮抽搐A片

SQL Server 2005附加數(shù)據(jù)庫方法

1.在重裝數(shù)據(jù)庫sqlserver2005后，要想把之前的數(shù)據(jù)庫附加到新安裝的數(shù)據(jù)庫上，需要先安裝sqlserver 2005 sp4補(bǔ)丁

2.打開sql2005管理工具

開始 —> 程序 —> Microsoft SQL Server 2005 —> SQL Server Management Studio

圖片24.png

3.連接數(shù)據(jù)庫

圖片25.png

4.找到數(shù)據(jù)庫，點(diǎn)擊附加

圖片26.png

5.在“附加數(shù)據(jù)庫”窗口的左邊中間位置找到“添加”按鈕單擊

圖片27.png

6.在彈出的框中，選擇要附加的數(shù)據(jù)庫文件，點(diǎn)擊“確定”。

圖片28.png

7.回到，第一個窗口處，繼續(xù)“確定”，OK，大功告成。

圖片29.png

8.然后查看導(dǎo)入是否成功。

圖片30.png

來源：景安

Public @ 2014-02-16 15:47:47

windows2003系統(tǒng)一鍵開啟IIS的GZIP方法

威海服務(wù)器/VPS 威海Gzip
2229

iis7、iis8、iis10默認(rèn)支持啟用了gzip下載地址：http://download.myhostadmin.net/IIS6-SET-GZIP.rar （請登錄您在我司的服務(wù)器/VPS下載）下載GZIP批處理文件，解壓到任意位置，如果您是中國電信機(jī)房服務(wù)器,請先雙擊打開運(yùn)行UNSIIS.bat,運(yùn)行后再雙擊打開運(yùn)行IIS6-SET-GZIP.cmd。如果您是香港或者美國機(jī)房，則直接雙擊運(yùn)

Public @ 2021-04-25 16:09:42

Windows Server 2008系統(tǒng)服務(wù)器安全狗的配置

: 1、安裝安全狗：（1）安裝安全狗控制臺將安全狗控制臺安裝程序 SetupSecurityDogCtrl.exe 傳輸至服務(wù)器上，雙擊該程序完成安裝，并在安裝完成后輸入激活碼，安裝完成后即可在服務(wù)器中尋找安全狗控制臺圖標(biāo)。（2）安裝安全狗驅(qū)動將安全狗驅(qū)動安裝程序 SetupSecurityDog.exe 傳輸至服務(wù)器上，雙擊該程序安裝安全狗驅(qū)動，安裝完成后可以在服務(wù)器中找到安全狗驅(qū)動程

Public @ 2023-02-26 16:00:54

SQL Server 2008數(shù)據(jù)庫連接報錯:值不能為null

這個錯誤通常意味著您的SQL Server 2008數(shù)據(jù)庫的某個列已經(jīng)定義為不允許空值，但是您正在嘗試將一個null值插入該列中。解決此問題的方法有以下幾種： 1. 在插入數(shù)據(jù)之前，檢查您要插入的列是否允許為空值，并確保不插入空值。 2. 如果該列允許為空值，但是仍然收到“值不能為null”的錯誤，請使用默認(rèn)值或空字符串作為該列的值。 3. 檢查您的數(shù)據(jù)庫表定義，確保所有必需的列

Public @ 2023-04-15 03:50:19

關(guān)于SQL Server的若干注意事項

如果你正在負(fù)責(zé)一個基于SQL Server的項目，或者你剛剛接觸SQL Server，你都有可能要面臨一些數(shù)據(jù)庫性能的問題，這篇文章會為你提供一些有用的指導(dǎo)（其中大多數(shù)也可以用于其它的DBMS）。在這里，我不打算介紹使用SQL Server的竅門，也不能提供一個包治百病的方案，我所做的是總結(jié)一些經(jīng)驗----關(guān)于如何形成一個好的設(shè)計。這些經(jīng)驗來自我過去幾年中經(jīng)受的教訓(xùn)，一直來，我看到許多同樣的設(shè)計錯

Public @ 2015-10-11 15:47:51

更多您感興趣的搜索

基本文件流程錯誤 SQL 調(diào)試

/www/wwwroot/briline.net/public/index.php ( 0.79 KB )
/www/wwwroot/briline.net/public/public.php ( 1.08 KB )
/www/wwwroot/briline.net/thinkphp/start.php ( 0.73 KB )
/www/wwwroot/briline.net/thinkphp/base.php ( 2.66 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Loader.php ( 19.47 KB )
/www/wwwroot/briline.net/vendor/composer/autoload_namespaces.php ( 0.21 KB )
/www/wwwroot/briline.net/vendor/composer/autoload_psr4.php ( 0.84 KB )
/www/wwwroot/briline.net/vendor/composer/autoload_classmap.php ( 0.14 KB )
/www/wwwroot/briline.net/vendor/composer/autoload_files.php ( 0.42 KB )
/www/wwwroot/briline.net/vendor/qiniu/php-sdk/src/Qiniu/functions.php ( 7.10 KB )
/www/wwwroot/briline.net/vendor/qiniu/php-sdk/src/Qiniu/Config.php ( 0.70 KB )
/www/wwwroot/briline.net/vendor/topthink/think-captcha/src/helper.php ( 1.59 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Route.php ( 59.82 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Config.php ( 6.03 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Validate.php ( 40.27 KB )
/www/wwwroot/briline.net/vendor/topthink/think-queue/src/config.php ( 0.77 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Console.php ( 21.22 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Error.php ( 3.59 KB )
/www/wwwroot/briline.net/thinkphp/convention.php ( 10.31 KB )
/www/wwwroot/briline.net/thinkphp/library/think/App.php ( 21.04 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Request.php ( 50.94 KB )
/www/wwwroot/briline.net/app/config.php ( 11.25 KB )
/www/wwwroot/briline.net/app/database.php ( 1.41 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Hook.php ( 4.76 KB )
/www/wwwroot/briline.net/app/tags.php ( 1.16 KB )
/www/wwwroot/briline.net/app/common/behavior/InitBase.php ( 8.17 KB )
/www/wwwroot/briline.net/app/common.php ( 23.29 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Env.php ( 1.25 KB )
/www/wwwroot/briline.net/thinkphp/helper.php ( 17.86 KB )
/www/wwwroot/briline.net/app/function.php ( 0.78 KB )
/www/wwwroot/briline.net/app/extend.php ( 13.29 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Debug.php ( 7.06 KB )
/www/wwwroot/briline.net/app/common/model/Config.php ( 0.78 KB )
/www/wwwroot/briline.net/app/common/model/ModelBase.php ( 12.18 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Model.php ( 66.83 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Db.php ( 6.54 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Log.php ( 5.84 KB )
/www/wwwroot/briline.net/thinkphp/library/think/db/connector/Mysql.php ( 3.94 KB )
/www/wwwroot/briline.net/thinkphp/library/think/db/Connection.php ( 29.97 KB )
/www/wwwroot/briline.net/thinkphp/library/think/db/Query.php ( 86.80 KB )
/www/wwwroot/briline.net/thinkphp/library/think/db/builder/Mysql.php ( 2.16 KB )
/www/wwwroot/briline.net/thinkphp/library/think/db/Builder.php ( 30.47 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Cache.php ( 6.17 KB )
/www/wwwroot/briline.net/thinkphp/library/think/cache/driver/File.php ( 7.46 KB )
/www/wwwroot/briline.net/thinkphp/library/think/cache/Driver.php ( 5.52 KB )
/www/wwwroot/briline.net/app/common/behavior/InitHook.php ( 1.25 KB )
/www/wwwroot/briline.net/app/common/model/Hook.php ( 0.77 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Lang.php ( 6.95 KB )
/www/wwwroot/briline.net/thinkphp/lang/zh-cn.php ( 3.85 KB )
/www/wwwroot/briline.net/app/route.php ( 0.91 KB )
/www/wwwroot/briline.net/app/index/config.php ( 0.96 KB )
/www/wwwroot/briline.net/app/index/common.php ( 0.68 KB )
/www/wwwroot/briline.net/app/index/controller/Wiki.php ( 2.44 KB )
/www/wwwroot/briline.net/app/index/controller/IndexBase.php ( 1.10 KB )
/www/wwwroot/briline.net/app/common/controller/ControllerBase.php ( 4.75 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Controller.php ( 6.20 KB )
/www/wwwroot/briline.net/thinkphp/library/traits/controller/Jump.php ( 4.97 KB )
/www/wwwroot/briline.net/thinkphp/library/think/View.php ( 6.86 KB )
/www/wwwroot/briline.net/thinkphp/library/think/view/driver/Think.php ( 5.61 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Template.php ( 46.46 KB )
/www/wwwroot/briline.net/thinkphp/library/think/template/driver/File.php ( 2.24 KB )
/www/wwwroot/briline.net/app/index/logic/Wiki.php ( 6.16 KB )
/www/wwwroot/briline.net/app/index/logic/IndexBase.php ( 0.79 KB )
/www/wwwroot/briline.net/app/common/logic/LogicBase.php ( 0.83 KB )
/www/wwwroot/briline.net/app/common/model/Article.php ( 0.78 KB )
/www/wwwroot/briline.net/app/common/model/ArticleTongji.php ( 0.79 KB )
/www/wwwroot/briline.net/thinkphp/library/think/paginator/driver/Bootstrap.php ( 5.90 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Paginator.php ( 9.45 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Collection.php ( 8.63 KB )
/www/wwwroot/briline.net/runtime/temp/ead4923c25a6b3f986358f7070f93dfa.php ( 56.51 KB )
/www/wwwroot/briline.net/thinkphp/library/think/Response.php ( 8.64 KB )
/www/wwwroot/briline.net/thinkphp/library/think/debug/Html.php ( 4.27 KB )

[ DB ] CONNECT:[ UseTime:0.026248s ] mysql:dbname=briline.net;host=106.14.77.182;port=3306;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ob_article` [ RunTime:0.018654s ]
[ SQL ] SELECT * FROM `ob_article` WHERE `id` = 2412 LIMIT 1 [ RunTime:0.017721s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] select * from `ob_article_tongji` where category_id=12 and mark_type='cate' order by times desc limit 15 [ RunTime:0.017889s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article_tongji', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 608, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] select * from `ob_article_tongji` where category_id=12 and mark_type='tags' order by times desc limit 100 [ RunTime:0.018386s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article_tongji', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 608, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] select * from `ob_article_tongji` where category_id=12 and mark_type='tags' order by rand() limit 30 [ RunTime:0.018662s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article_tongji', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 608, 'extra' => 'Using where; Using temporary; Using filesort', ) ]
[ SQL ] SELECT * FROM `ob_article` WHERE `id` = 2412 LIMIT 1 [ RunTime:0.017903s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] update `ob_article` set views=views+1 where id=2412 [ RunTime:0.018548s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ob_article` WHERE `category_id` = 12 AND `cate` = '威海服務(wù)器/VPS' AND `status` <> -1 LIMIT 1 [ RunTime:0.024987s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 9562, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `ob_article` WHERE `category_id` = 12 AND `cate` = '威海服務(wù)器/VPS' AND `status` <> -1 ORDER BY rand() LIMIT 0,2 [ RunTime:0.040455s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 9562, 'extra' => 'Using where; Using temporary; Using filesort', ) ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ob_article` WHERE `category_id` = 12 AND `tags` = '威海SQL Server' AND `status` <> -1 LIMIT 1 [ RunTime:0.024571s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 9562, 'extra' => 'Using where', ) ]
[ SQL ] SELECT * FROM `ob_article` WHERE `category_id` = 12 AND `tags` = '威海SQL Server' AND `status` <> -1 ORDER BY rand() LIMIT 0,2 [ RunTime:0.034919s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_article', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 9562, 'extra' => 'Using where; Using temporary; Using filesort', ) ]

0.476594s