ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle) ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡£¿ ·Ç³£¸Ðл
Â¥ÉϵÄÏÈл¹ýÁË£¬²»¹ýÕâ¸öºÃÏñ²»¶Ô°É£¿»òÕßÎÒûÓÐÃèÊöÇå³þ ÎÒÏÖÔÚÊÇÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÔÚÒ³ÃæÉÏÁгöÎÄÕµıêÌâÁÐ±í£¬ÆäÖÐÿƪÎÄÕÂÏÂÃæÁгöÊôÓÚ´ËÎÄÕµÄËùÓÐÆÀÂÛÐÅÏ¢¡£ ÕâÑùµÄÓï¾äÔõôд°¡£¿ »òÕßÖ»ÄÜÊǵÚÒ»´ÎÖ»ÊÇÁгöÎÄÕ±êÌ⣬Ȼºóÿ¼ÓÔØÒ»ÌõÎÄÕ¾ÍÈ¥Êý¾Ý¿â²éѯһ´ÎËùÓÐµÄÆÀÂÛ£¿ÕâÑùÈç¹ûÿҳÏÔʾ10ÌõµÄ»°£¬ÄÇÕâ¸öÒ³ÃæÖÁÉÙÒªÁ¬½ÓÊý¾Ý¿â½øÐÐ11´Î£¬ÕâÑùЧÂÊÊDz»ÊÇÓÐЩµÍ°¡£¿ÒýÓà ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛÒýÓà ÆäÖÐÿƪÎÄÕÂÏÂÃæÁгöÊôÓÚ´ËÎÄÕµÄËùÓÐÆÀÂÛÐÅÏ¢¡£ ÒÔÄĸöΪ׼£¿ (²»Òª¸ß¹ÀÄãµÄººÓï±í´ïÄÜÁ¦»òÕßÎҵĺºÓïÀí½âÄÜÁ¦) ½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾ÝÒÔ¼°»ùÓÚÕâЩ²âÊÔÊý¾ÝµÄËù¶ÔÓ¦ÕýÈ·½á¹û¡£ ²Î¿¼Ò»ÏÂÕâ¸öÌù×ÓµÄÌáÎÊ·½Ê½http://topic.csdn.net/u/20091130/20/8343ee6a-417c-4c2d-9415-fa46604a00cf.html 1. ÄãµÄ create table xxx .. Óï¾ä 2. ÄãµÄ insert into xxx ... Óï¾ä 3. ½á¹ûÊÇʲôÑù£¬£¨²¢¸øÒÔ¼òµ¥µÄËã·¨ÃèÊö£© 4. ÄãÓõÄÊý¾Ý¿âÃû³ÆºÍ°æ±¾(¾³£ÓÐÈËÔÚMS SQL server°æÎÊ MySQL) ÕâÑùÏë°ïÄãµÄÈË¿ÉÒÔÖ±½Ó´î½¨ºÍÄãÏàͬµÄ»·¾³£¬²¢ÔÚ¸ø³ö·½°¸Ç°½øÐвâÊÔ£¬±ÜÃâÎÄ×ÖÃèÊöÀí½âÉϵÄÎó²î¡£ Â¥ÉϵIJ»ºÃÒâ˼
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ ÀýÈç£ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
--drop table #T1 --drop table #T2 create Table #T1(ID int, QueryID nvarchar(20), ResultID1 nvarchar(20), ResultID2 nvarchar(20)) create Table #T2(SortNo int, QueryID nvarchar(20), ResultID1 nv ......
CREATE PROCEDURE [selectvipcompany] @username varchar(50), @companyname varchar(50), @endtime varchar(1) AS declare @sql varchar(1000) set @sql='' if (@username<>null and @username ......