Ô¶³ÌÁ¬½Ósql server 2000·þÎñÆ÷µÄ½â¾ö·½°¸
Ô¶³ÌÁ¬½Ósql server 2000·þÎñÆ÷µÄ½â¾ö·½°¸
----ת×Ô£º·ÉºüСÎÝ
ÓÉÓÚÌØ¶¨ÐèÇó£¬×î½üʵÑéÊÒÐèÒªÔ¶³ÌÁ¬½ÓÍâµØµÄsql server 2000·þÎñÆ÷£¬×ʼÔõôÁ¬Ò²Á¬²»ÉÏ£¬³öÏÖÁ˺ܶàÎÊÌ⣬µ«ÊÇÔÚ½ñÌìÉÏÎ磬½èÓÃʵÑéÊҵIJâÊÔÌõ¼þ£¨Ò»¸ö¹«ÍøIP£¬Á½¸ö½ÌÓýÍø¾²Ì¬IP£©£¬ÖÕÓÚµ÷ÊÔͨ¹ý£¬Ò²ËãÊÇÍê³ÉÁËÀÏʦµÄÈÎÎñ£¬ÔÚÕâÀïдÏÂ×Ô¼ºµÄÐĵ㬲ο¼Á˺ܶàÍøÉϵÄÎÄÕºÍÂÛ̳ÀïµÄÎÊÌ⣬ϣÍû¶ÔÓдËÐèÒªµÄÓаïÖú¡£²»ÍêÉÆÖ®´¦£¬Ò²ÇëÁôÑÔ¡£·Ï»°ÉÙ˵£¬½øÈëÖ÷Ìâ¡£
²½Ö裺
Ò» ¿´ping ·þÎñÆ÷IPÄÜ·ñpingͨ¡£
Õâ¸öʵ¼ÊÉÏÊÇ¿´ºÍÔ¶³Ìsql server 2000·þÎñÆ÷µÄÎïÀíÁ¬½ÓÊÇ·ñ´æÔÚ¡£Èç¹û²»ÐУ¬Çë¼ì²éÍøÂ磬²é¿´ÅäÖ㬵±È»µÃÈ·±£Ô¶³Ìsql server 2000·þÎñÆ÷µÄIPƴдÕýÈ·¡£
¶þ ÔÚDos»òÃüÁîÐÐÏÂÊäÈëtelnet ·þÎñÆ÷IP ¶Ë¿Ú£¬¿´ÄÜ·ñÁ¬Í¨¡£
Èçtelnet 202.114.100.100 1433
ͨ³£¶Ë¿ÚÖµÊÇ1433£¬ÒòΪ1433ÊÇsql server 2000µÄ¶ÔÓÚTcp/IPµÄĬÈÏÕìÌý¶Ë¿Ú¡£Èç¹ûÓÐÎÊÌ⣬ͨ³£ÕâÒ»²½»á³öÎÊÌ⡣ͨ³£µÄÌáʾÊÇ“……ÎÞ·¨´ò¿ªÁ¬½Ó,Á¬½Óʧ°Ü"¡£
Èç¹ûÕâÒ»²½ÓÐÎÊÌ⣬Ӧ¸Ã¼ì²éÒÔÏÂÑ¡Ïî¡£
1 ¼ì²éÔ¶³Ì·þÎñÆ÷ÊÇ·ñÆô¶¯ÁËsql server 2000·þÎñ¡£Èç¹ûûÓУ¬ÔòÆô¶¯¡£
2 ¼ì²é·þÎñÆ÷¶ËÓÐûÆôÓÃTcp/IPÐÒ飬ÒòΪԶ³ÌÁ¬½Ó£¨Í¨¹ýÒòÌØÍø£©ÐèÒª¿¿Õâ¸öÐÒé¡£¼ì²é·½·¨ÊÇ£¬ÔÚ·þÎñÆ÷ÉÏ´ò¿ª¿ªÊ¼²Ëµ¥->³ÌÐò->Microsoft SQL Server->·þÎñÆ÷ÍøÂçʵÓù¤¾ß£¬¿´ÆôÓõÄÐÒéÀïÊÇ·ñÓÐtcp/ipÐÒ飬Èç¹ûûÓУ¬ÔòÆôÓÃËü¡£
3 ¼ì²é·þÎñÆ÷µÄtcp/ip¶Ë¿ÚÊÇ·ñÅäÖÃΪ1433¶Ë¿Ú¡£ÈÔÈ»ÔÚ·þÎñÆ÷ÍøÂçʵÓù¤¾ßÀï²é¿´ÆôÓÃÐÒéÀïÃæµÄtcp/ipµÄÊôÐÔ£¬È·±£Ä¬È϶˿ÚΪ1433£¬²¢ÇÒÒþ²Ø·þÎñÆ÷¸´Ñ¡¿òûÓй´ÉÏ¡£
ÊÂʵÉÏ£¬Èç¹ûĬÈ϶˿ڱ»Ð޸ģ¬Ò²ÊÇ¿ÉÒԵ쬵«ÊÇÔÚ¿Í»§¶Ë×ötelnet²âÊÔʱ£¬Ð´·þÎñÆ÷¶Ë¿ÚºÅʱ±ØÐëÓë·þÎñÆ÷ÅäÖõĶ˿ںű£³ÖÒ»Ö¡£Èç¹ûÒþ²Ø·þÎñÆ÷¸´Ñ¡¿ò±»¹´Ñ¡£¬ÔòÒâζ×ſͻ§¶ËÎÞ·¨Í¨¹ýö¾Ù·þÎñÆ÷À´¿´µ½Õą̂·þÎñÆ÷£¬Æðµ½Á˱£»¤µÄ×÷Ó㬵«²»Ó°ÏìÁ¬½Ó£¬µ«ÊÇTcp/ipÐÒéµÄĬÈ϶˿ڽ«±»ÒþʽÐÞ¸ÄΪ2433£¬ÔÚ¿Í»§¶ËÁ¬½Óʱ±ØÐë×÷ÏàÓ¦µÄ¸Ä±ä¡£
4 Èç¹û·þÎñÆ÷¶Ë²Ù×÷ϵͳ´ò¹ýsp2²¹¶¡£¬ÔòÒ
Ïà¹ØÎĵµ£º
1¡¢ÔÚÊý¾Ý¿â½¨±íµÄʱºò×Ö¶ÎÖ±½ÓÉèÖÃΪDATETIMEÀàÐÍ£»
2¡¢Ö´ÐвåÈëµÄʱºòʹÓÃÈçÏÂÓï¾ä£º
PreparedStatement pstmt = conn.prepareStatement("insert into guestbook(gst_user,gst_title,gst_content,gst_ip,gst_time) values(?,?,?,?,getdate())");
3¡¢Òª°ÑÈÕÆÚ´ÓÊý¾Ý¿âÖÐÈ¡³ö£¬Ö´ÐÐÈçÏÂÓï¾ä£º
......
SQLÄ£ºý²éѯÓï¾äºÍEscapeתÒå×Ö·û(2008-09-22 14:26:01)
±êÇ©£ºfrom תÒå×Ö·û sql µ¥ÒýºÅ ͨÅä·û escape it
ͨÅä·ûÃèÊöʾÀý%°üº¬Áã¸ö»ò¸ü¶à×Ö·ûµÄÈÎÒâ×Ö·û´®¡£WHERE title LIKE '%computer%' ½«²éÕÒ´¦ÓÚÊéÃûÈÎÒâλÖõİüº¬µ¥´Ê computer µ ......
±íÖÐÖ÷¼ü±ØÐëΪ±êʶÁУ¬[ID] int IDENTITY (1,1)
1.·ÖÒ³·½°¸Ò»£º(ÀûÓÃNot InºÍSELECT TOP·ÖÒ³)
Óï¾äÐÎʽ£º
SELECT TOP Ò³¼Ç¼ÊýÁ¿ *
from ±íÃû
WHERE (ID NOT IN
(SELECT TOP (ÿҳÐÐÊý*(Ò³Êý-1)) ID
from ±íÃû
ORDER BY ID))
ORDER BY ID
//×Ô¼º»¹¿ÉÒÔ¼ÓÉÏһЩ²éѯ ......
AspNetPagerÊÇÒ»¸ö±È½ÏºÃµÄ·ÖÒ³¿Ø¼þ,¸Ã¿Ø¼þʹÓùý³Ì·Öҳʮ·Ö·½±ã,¹ý³ÌÈçÏÂ:
Create PROCEDURE [dbo].[pt_AspNetPager]
(
@tableName varchar(255), -- ±íÃû
@fieldName varchar(400)= '*', -- ×Ö¶ÎÃû
@strWhere varchar(255) = Null,
@fieldOrder varchar(100), --²»ÄÜΪ¿Õ
@startIndex int ......