魔天记忘语小说,欢乐颂小说在线阅读,欢乐颂第三季

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

更改SQL Server 2005數(shù)據(jù)庫(kù)端口方法

1.如果服務(wù)器的TCP端口更改為其他的端口，那么在客戶(hù)端的配置工具中需要做如下的設(shè)置：

程序－>Microsoft sql server 2005 －>配置工具－>sql server configration manage ,如下圖：

圖片31.png

2.在網(wǎng)絡(luò)配置中選擇SQLEXPRESS協(xié)議如下圖所示：

圖片32.png

3.在右側(cè)的TCP/IP中的屬性中，協(xié)議對(duì)話(huà)框的內(nèi)容，按照如下設(shè)置：

圖片33.png

4.IP地址對(duì)話(huà)框中按照如下所示設(shè)置

圖片34.png

5.IP2中的地址設(shè)置為客戶(hù)端的IP地址,端口更改為服務(wù)器端SQL SERVER開(kāi)發(fā)的端口。

圖片35.png

6.在來(lái)設(shè)置客戶(hù)端的協(xié)議的端口，界面如下所示

圖片36.png

7.彈出的協(xié)議窗口中，更改默認(rèn)的端口，設(shè)置如下圖所示。

圖片37.png

8.所有的設(shè)置完成之后，重新啟動(dòng)SQLEXPRESS服務(wù)。

圖片38.png

9.照以上設(shè)置完成客戶(hù)端端口更改，在程序中的數(shù)據(jù)庫(kù)連接字符串也應(yīng)該做相應(yīng)的更改，否則還是無(wú)法連接打數(shù)據(jù)庫(kù)。

Provider=SQLNCLI.1;Persist Security Info=True;User ID=****;Password=**;Initial Catalog=tablename;Data Source=202.000.000.000,3533.

來(lái)源：景安

Public @ 2012-03-02 15:47:48

云服務(wù)器和VPS的區(qū)別

1.硬件架構(gòu)不同：云服務(wù)器采用的是分布式的物理服務(wù)器，而VPS采用的是虛擬化技術(shù)，在一個(gè)物理服務(wù)器上虛擬出多個(gè)獨(dú)立的虛擬服務(wù)器。 2.資源分配方式不同：云服務(wù)器可以根據(jù)實(shí)際需求自由分配計(jì)算資源、存儲(chǔ)資源和帶寬等資源，而VPS則是在一個(gè)物理主機(jī)中劃分出一定的資源給虛擬服務(wù)器使用，資源分配比較固定。 3.擴(kuò)展性不同：云服務(wù)器的擴(kuò)展性強(qiáng)，可以根據(jù)實(shí)際業(yè)務(wù)需求隨時(shí)增加或減少計(jì)算資源，而VPS則受限于物

Public @ 2023-06-06 23:00:14

VPS/云主機(jī)如何新建增加未指派磁盤(pán)分區(qū)

一般情況下，新建增加未指派磁盤(pán)分區(qū)步驟如下： 1. 連接到你的 VPS/云主機(jī)，使用管理員權(quán)限登錄操作系統(tǒng)。 2. 打開(kāi)磁盤(pán)管理器或命令行（Windows 操作系統(tǒng)中使用 Disk Management 或者 Command Prompt中使用 DiskPart）。 3. 在磁盤(pán)管理器中選中未分配的空間或在命令行中使用select disk和create partition commands

Public @ 2023-06-11 03:00:14

如何避免ASP的SQL的執(zhí)行效率低

以下是一些提高ASP SQL執(zhí)行效率的方法： 1. 編寫(xiě)高效的SQL查詢(xún)：確保SQL查詢(xún)語(yǔ)句是優(yōu)化的，包括選擇合適的索引、避免使用不必要的JOIN操作和子查詢(xún)、避免使用LIKE操作符以及盡可能減少SELECT返回的列數(shù)等。 2. 參數(shù)化查詢(xún)：使用參數(shù)化查詢(xún)而不是拼接字符串來(lái)構(gòu)建SQL查詢(xún)語(yǔ)句，這樣可以避免SQL注入攻擊，并且能夠重復(fù)使用已編譯的查詢(xún)計(jì)劃。 3. 緩存查詢(xún)結(jié)果：如果某些查詢(xún)結(jié)果在一

Public @ 2023-07-31 15:00:28

SQL Server數(shù)據(jù)庫(kù)提示

SQL Server數(shù)據(jù)庫(kù)登陸時(shí)提示報(bào)錯(cuò)如圖:圖片19.png源錯(cuò)誤 :行 135: </roleManager>行 136: </system.web>行 137: <system.serviceModel>行 138: <extensions&g

Public @ 2019-05-16 15:47:44

更多您感興趣的搜索

基本文件流程錯(cuò)誤 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.031650s ] mysql:dbname=briline.net;host=106.14.77.182;port=3306;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ob_article` [ RunTime:0.022226s ]
[ SQL ] SELECT * FROM `ob_article` WHERE `id` = 2414 LIMIT 1 [ RunTime:0.022564s ]
[ 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.021692s ]
[ 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.021665s ]
[ 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.022260s ]
[ 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` = 2414 LIMIT 1 [ RunTime:0.021307s ]
[ 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=2414 [ RunTime:0.022126s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ob_article` WHERE `category_id` = 12 AND `cate` = '威海服務(wù)器/VPS' AND `status` <> -1 LIMIT 1 [ RunTime:0.028032s ]
[ 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.042176s ]
[ 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.032365s ]
[ 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.045492s ]
[ 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.570252s