ÎÄÕ£¬Í¼Æ¬ÈçºÎ´æ´¢µ½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
Ïà¹ØÎÊ´ð£º
СµÜÏÖÔÚSwingÔÚÁ¬½ÓÊý¾Ý¿âÉÏÓöµ½Ò»µãÎÊÌ⣬ÇëÎÊSwingÀïÃæµÄʼþºÍSQLserverÊý¾Ý¿âµÄÁ¬½ÓÓÐʲôºÃµÄ×ÊÁÏÊéÍÆ¼öÂð£¿
Õâ¸öÓ¦µ±Ã»ÓÐÊ²Ã´ÌØ±ð,ÓëÆäËûµÄ±à³ÌÒ»Ñù.
JDBC
ÇëÎÊÔÚSwingÖмÓÔØ±³¾°Í¼Æ¬ÊÇÔõô¼ÓµÄ£¿
......
sql serverÖ±½ÓµÄÎļþ±¸·ÝºÍÓÃsqlserverµÄ±¸·ÝÓÐÊ²Ã´Çø±ð?
´ó¼Ò˵Ïêϸһµã
²»Ã÷°×~~~
Ö±½Ó±¸·ÝÎļþµÄÓõķÖÀëÊý¾ÝºÍ¸½¼ÓÊý¾Ý¿â
sqlserver±¸·ÝµÄÓõı¸·ÝÊý¾Ý¿âºÍ»¹ÔÊý¾Ý¿â
Ö±½ÓÎļþ±¸·ÝÄãµÃÍ£·þÎñ»òÕßÍÑ ......
´ÓÍøÉϲ鵽µÄ×ÊÁÏ˵£¬ÈκÎÊý¾ÝÀàÐÍÓëNULLÖµ½øÐмÆË㣬½á¹û¶¼½«ÎªNULL.
select null-1
½á¹ûÊÇnull
¿ÉÊÇÏÂÃæÕâ¸ö²éѯΪʲô»á³ö´íÄØ£¿
select isnull(null-1,'test');
¾ÓÈ»±¨´í˵½«varcharתΪintʧ°Ü¡£
Ϊʲô» ......
sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É
identity?ɶÒâ˼£¿
IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......