ÎÄÕ£¬Í¼Æ¬ÈçºÎ´æ´¢µ½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
Ïà¹ØÎÊ´ð£º
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
´ÓÍøÉϲ鵽µÄ×ÊÁÏ˵£¬ÈκÎÊý¾ÝÀàÐÍÓëNULLÖµ½øÐмÆË㣬½á¹û¶¼½«ÎªNULL.
select null-1
½á¹ûÊÇnull
¿ÉÊÇÏÂÃæÕâ¸ö²éѯΪʲô»á³ö´íÄØ£¿
select isnull(null-1,'test');
¾ÓÈ»±¨´í˵½«varcharתΪintʧ°Ü¡£
Ϊʲô» ......
ÔÚÊý¾Ý¿âÖÐÈÕÆÚÈçÏÂÏÔʾ£º2009-2-27 9:40:47
Õâ¸ö²»ÊÇÎÒÏëÒªµÄ£¬ÎÒÐèÒªÔ·ݺÍʱ¼äÓÃÁ½Î»Êý±íʾ£¬ÉÏÃæµÄÓ¦¸Ãת»»Îª;2009-02-27 09:40:47
ÇëÎÊ
1¡¢ÈçºÎ¶ÔÏÖÓÐÈÕÆÚ½øÐÐת»»£¨Êý¾Ý¿âÖÐÒÑ´æÔÚÐí¶àÀàËÆµÄÖµ£¬ÎÒÐèÒª½«Æä ......
ÓÐһ̨Êý¾Ý¿â·þÎñÆ÷£¬¿Í»§¶ËʹÓÃADO.NETÁ¬½Ósql£¬Ê¹ÓÃExecuteScalarÖ´ÐÐSQL INSERTÓï¾ä£¬È»ºó¿Í»§¶Ëˢв»Äܲéѯµ½ÐÂINSERTµÄÊý¾Ý£¬¹ý10Ãë×óÓÒ²ÅÄܲ鵽ÐÂÊý¾Ý
ʲôÔÒò
Äã×öÁË»º´æÂð£¿
û×ö»º´æ
Ôõô»áÄØ£¡ ......