ÎÄÕ£¬Í¼Æ¬ÈçºÎ´æ´¢µ½SQLSERVERÖÐ
ͼƬÔÚSQLSERVERÖд洢µÄÊÇ·¾¶
¶ÔÂð£¿
ÒªÊDz»Êǵϰ£¬ÄÇÊÇÔõô´æµÄ£¿
»¹ÓУ¬ÎÒÒªÏë´æ´¢Ò»ÆªÎÄÕ£¨4£¬5ǧ×Ö£©
ÄǸÃÈçºÎ´æ´¢ÄØ£¿¡¢
ͼƬÔÚSQLSERVERÖд洢µÄÊÇ·¾¶
¶ÔÂð£¿
ÒªÊDz»Êǵϰ£¬ÄÇÊÇÔõô´æµÄ£¿ //image Õâ¸öÊý¾ÝÀàÐÍ£¬½«Í¼¶Á³É¶þ½øÖÆÁ÷
»¹ÓУ¬ÎÒÒªÏë´æ´¢Ò»ÆªÎÄÕ£¨4£¬5ǧ×Ö£©
ÄǸÃÈçºÎ´æ´¢ÄØ£¿¡¢//text
ͼƬÔÚSQLSERVERÖд洢µÄÊÇ·¾¶¶ÔÂ𣿠һ°ã¶¼ÊÇ´æÂ·¾¶¡£
ÒªÊDz»Êǵϰ£¬ÄÇÊÇÔõô´æµÄ£¿ ½«Í¼¶Á³É¶þ½øÖÆÁ÷´æÈëÊý¾Ý¿â¡£imageÊý¾ÝÀàÐÍ¡£
»¹ÓУ¬ÎÒÒªÏë´æ´¢Ò»ÆªÎÄÕ£¨4£¬5ǧ×Ö£© ÄǸÃÈçºÎ´æ´¢ÄØ£¿ Ò»Ñù´æ´¢£¬textÊý¾ÝÀàÐÍ
Ò»°ãÔÚÊý¾Ý¿âÖд洢ͼƬ·¾¶
´æ´¢Í¼Æ¬ÒÔ¶þ½øÖÆÁ÷·½Ê½
ÎÄÕÂÓà text ÀàÐÍÍêÈ«¿ÉÒԸ㶨
ͼÏñ´æ´¢µÄÊǶþ½øÖÆÊý¾ÝÁ÷£¡
Ò»°ãͼƬ´æÂ·¾¶
ÎÄÕÂÄÚÈÝÒ»°ã¶¼ÓÃtext
ͼƬ¿ÉÒÔ´æÂ·¾¶£¬Ò²¿ÉÒÔ´æ¶þ½øÖÆÁ÷¡£¡£¡£¡£×îºÃµÄ×ö·¨µ±È»ÊÇ ´æ ·¾¶ÁË£¬ÎÞÂÛ´æÈ¡¶¼±È½Ï·½±ã¡£¡£¡£
ÖÁÓÚÎÄÕÂÂ¿ÉÒÔÖ±½Ó´æÔÚ textÊý¾ÝÀàÐÍ µÄ×Ö¶ÎÀïÃæ£¬Ò²¿ÉÒÔ·ÅÔÚXML»òÕß txtÎļþÀïÃæ£¬È»ºó½øÐÐÎļþ¶Áд£¬µ±Ì¸Ç°ÕßÒª¼òµ¥ºÜ¶à£¬¾ÍÒ»¸ö×ֶξͺÃÁË£¬ºóÕߵϰ²Ù×÷±È½ÏÂé·³£¬µ«³ÌÐòЧÂÊÒª±ÈǰÕ߸ߡ£¡£¡£
ͼƬÔÚSQLSERVERÖд洢µÄÊÇ·¾¶ ¶ÔÂð£¿
===¶Ô
ÒªÊDz»Êǵϰ£¬ÄÇÊÇÔõô´æµÄ£¿
===¿ÉÒÔ°ÑͼƬ±äΪ¶þ½øÖÆÁ÷ ´æ £¬Êý¾Ý¿â×Ö¶Î ÀàÐÍΪ image
»¹ÓУ¬ÎÒÒªÏë´æ´¢Ò»ÆªÎÄÕ£¨4£¬5ǧ×Ö£© ÄǸÃÈçºÎ´æ´¢ÄØ£¿¡¢
=====-ÎÄÕÂÒ»°ã¶¼ÊÇ Êý¾Ý¿â×Ö¶Î ÀàÐÍΪ text£¬ ntext
Ïà¹ØÎÊ´ð£º
ÎÒ¿´Á˺ܶàÎÄÕ£¬Ð´µÄ̫רҵ£¬Äܲ»ÄÜÓôó°×»°½²½²£¬¾ÍÊÇÔõô¹¹½¨Ë÷ÒýµÄ£¬²éµÄʱºòÊÇÔõôÑùµÄ²½Ö裬Ϊʲô±Èlike¿ì£¬ÊDz»ÊÇÖ»ÒªÓÃcontect£¬¾ÍÒ»¶¨»áÈ¥²é£¬±ÈÈç
select * from table where contect('sdfsd',sdf) and ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£
ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ
ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£
SQLSERVER 2000Ã ......
һ̨SqlServer·þÎñÆ÷ winxp
һ̨oracle·þÎñÆ÷ windows 2003
ÏëÔÚoracle·þÎñÆ÷ÀûÓÃ͸Ã÷Íø¹ØÁ¬½Óµ½SqlServer¡£
ÅäÖÃ͸Ã÷Íø¹ØµÄ²ÎÊýÎļþinitXXXXX.oraµÄʱºò£¬
1¡¢ÉèÖà HS_FDS_TRANSA ......
ÏÖÔÚÓÉÓÚÐÂÊÖÎó²Ù×÷£¬ÏÖÔÚֻʣÏÂÈÕÖ¾ÎļþÁË£¬ÇëÎʸßÊÖÄܲ»Äָܻ´£¬Ð»Ð»£¡
SQL code:
ÊDz»ÊÇÍêÕû»Ö¸´Ä£Ê½??
ʹÓÃLog Explorer²é¿´ºÍ»Ö¸´Êý¾Ý
Log Explorer 4.1.¿ÉÓÃÓÚSQL Server2005µÄÈÕÖ¾²é¿´¹¤¾ß
ÏÂÔØµØÖ·:
......