ÎÄÕ£¬Í¼Æ¬ÈçºÎ´æ´¢µ½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
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥ÁË°¡£¿
......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃ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Ã ......
ÓÐһ̨Êý¾Ý¿â·þÎñÆ÷£¬¿Í»§¶ËʹÓÃADO.NETÁ¬½Ósql£¬Ê¹ÓÃExecuteScalarÖ´ÐÐSQL INSERTÓï¾ä£¬È»ºó¿Í»§¶Ëˢв»Äܲéѯµ½ÐÂINSERTµÄÊý¾Ý£¬¹ý10Ãë×óÓÒ²ÅÄܲ鵽ÐÂÊý¾Ý
ʲôÔÒò
Äã×öÁË»º´æÂð£¿
û×ö»º´æ
Ôõô»áÄØ£¡ ......