¼±ÇóÒ»MSSQLÈ¥³ýÖظ´ÏîÓï¾ä
»ù´¡±íA¡¢BÈçͼ£¬ÓÉÓÚÒ»ÌõÐÂÎÅÖпÉÄÜÓжàÕÅͼƬ£¬ËùÒÔBÖлá³öÏÖ¶à¸öͼƬ±àºÅ¶ÔÒ»¸öÐÂÎűàºÅµÄÇé¿ö¡£
Çó´´½¨C±í£¨ÊÓͼ£©µÄsqlÓï¾ä¡£
SQL code:
select
b.pictureid as ͼƬ±àºÅ,a.newstitle as ÐÂÎűêÌâ,a.newurl as ÐÂÎŵØÖ·,b.pictureaddress as ͼƬµØÖ·
from
a
left join
b
on
a.newid=b.newsid
SQL code:
ÊÇÊÓͼ
create view f as
select
b.pictureid as ͼƬ±àºÅ,a.newstitle as ÐÂÎűêÌâ,a.newurl as ÐÂÎŵØÖ·,b.pictureaddress as ͼƬµØÖ·
from
a
left join
b
on
a.newsid=b.newsid
¶àÕÅͼƬµØÖ·ÊÇÔÚÒ»ÁÐÏÔʾ»¹ÊÇÔÚÒ»ÐÐÏÔʾ£¿
Ïà¹ØÎÊ´ð£º
Ò»¸ö×ÜÕ¾.Èý¸ö×ÓÕ¾¹²ËĸöASP¿ª·¢µÄÕ¾µã;Êý¾Ý¿âÊÇMSSQL2000;ËĸöÕ¾¸÷ÓÐ×Ô¼ºµÄÊý¾Ý¿â(ËĸöÕ¾µãµÄ¿â½á¹¹¶¼ÊÇÒ»ÑùµÄ.),¸÷ÓÐ×Ô¼ºµÄÐÅÏ¢Ìí¼Óºǫ́,ËĸöÕ¾ÊǶÀÁ¢µÄ.ËĸöÕ¾¶¼ÔÚͬһ¸ö·þÎñÆ÷ÖÐ.
ÏÖÔÚÐèÒªÏÖʵ:
Ò».ÈçºÎÈÃ×ÜÕ¾ ......
Ö÷»ú
¿Í»§»úc1,c2,c3,c4,c5............
ÒªÇóÈçºÎ±£Ö¤¿Í»§»úÏòÖ÷»úÌá½»Êý¾Ý¾¡Á¿ÊµÊ±.¿ìËÙ.ÍêÕû
Ö±½ÓÓÃinsert ʱ,ËøסÖ÷»úµÄ±í.ËùÒÔ´Ë·½·¨²»¿ÉÐÐ
Çë¸ßÊÖÖ§ÕÐ..
Èç¹ûÖ»²åÈë¶ø²»¶Á£¬Óõ͸ôÀ뼶±ð
Äã²åÄãµÄ,Ëû²å ......
×î½üÏÂÃ淴Ӧ˵³ÌÐòÒì³£
È»ºó´ò¿ªÊý¾Ý¿âÒ»¿´
·¢Ïֺܶà±í¶¼"Ö»¶Á"״̬??
ÓÃsaµÇ½ҲÊÇ...
ºÜÆæ¹Ö°¡..
´óÅ£ÖªµÀÊÇʲôÔÒòÂð?
Ô¸Òâ³ö¸ß·ÖÇó
˽â¾öÁË
¸ø200·Ö!!
Êý¾Ý¿â³öÎÊÌâÁË?
ÒýÓÃ
×î½üÏÂÃæ ......
create db ÊÇн¨Êý¾Ý¿â
create table ÊÇн¨±í
ÄÇн¨×Ö¶ÎÄØ£¿ лл¡£
×Ô¼ºµ½sqlserverÎĵµÖвéÕÒcreateµÄÓ﷨ʾÀý°É
SQL code:
ÏÂÀýÏÔʾ pubs Êý¾Ý¿âÖÐËù´´½¨µÄÈý¸ö±í£¨jobs¡¢employee ºÍ publisher ......
·´ÕýÎÒÊǾ³£·Ö²»Çå¡¡
¼ÌÐøÉ¢·Ö
µÚÒ»¸ö±ÕÔ´£¬µÚ¶þ¸ö¿ªÔ´£¬µÚÈý¸öûŮÈËÔµ¡¡
LZÄ㻹ÓпÉÓ÷Öô£¿
ÒýÓÃ
LZÄ㻹ÓпÉÓ÷Öô£¿
5·Ö
ÒýÓÃ
µÚÒ»¸ö±ÕÔ´£¬µÚ¶þ¸ö¿ªÔ´£¬µÚÈý¸öûŮÈËÔµ¡¡
ÓÐÒâ˼¡£¿´±êÌ ......