¼±ÇóÒ»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
¶àÕÅͼƬµØÖ·ÊÇÔÚÒ»ÁÐÏÔʾ»¹ÊÇÔÚÒ»ÐÐÏÔʾ£¿
Ïà¹ØÎÊ´ð£º
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
ÔÚvbscriptÖв»ÓÃon error resume nextÈçºÎÅжÏmssqlÓï·¨´íÎó£¡
TRY CATCH?
»òÕßʹÓÃÁ÷³Ì¿ØÖÆÓï¾ä
if
else
²»ÓÃon error ÓÃÄǸöÎҾͲ»ÐèÒªÔÚÕâÀïÑ°ÕÒ´ð°¸
ÒýÓÃ
²»ÓÃon error ÓÃÄǸöÎҾͲ»Ðè ......
ÎÒÔÀ´ÊÇÓÉaccessת³ÉmssqlµÄ..ÔÀ´µÄ×ÔÔö×Ô¶¯Ã»ÓÐÁË
ÎÒÔõôÓÃsqlÀ´×ª»¯ÄØ£¿£¨²»ÏëÔÚÆóÒµÃæ°å¹ÜÀíÖÐ¸Ä ±íÌ«¶à..£©
»¹ÓÐsmalldateµÄĬÈÏÖµ¸Ä³Égetdate()µÄÓï¾äÒªÔõôд..ллÁË
accessת³ÉmssqlµÄ..ÔÀ´µÄ×ÔÔö×Ô¶ ......
ÀýÈ磺select a.* from (select id,code from b left join c on b.id=c.id)a where id=1
ÕâÀïµÄwhere ÔÚÖ´ÐеÄʱºò£¬ where »áÓÅ»¯ÊÇ·ñ½øÈ뵽СÀ¨ºÅÀïÃæÖ´ÐÐ?????
SQL code:
select id,code from b left join ......
·´ÕýÎÒÊǾ³£·Ö²»Çå¡¡
¼ÌÐøÉ¢·Ö
µÚÒ»¸ö±ÕÔ´£¬µÚ¶þ¸ö¿ªÔ´£¬µÚÈý¸öûŮÈËÔµ¡¡
LZÄ㻹ÓпÉÓ÷Öô£¿
ÒýÓÃ
LZÄ㻹ÓпÉÓ÷Öô£¿
5·Ö
ÒýÓÃ
µÚÒ»¸ö±ÕÔ´£¬µÚ¶þ¸ö¿ªÔ´£¬µÚÈý¸öûŮÈËÔµ¡¡
ÓÐÒâ˼¡£¿´±êÌ ......