Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÇóÒ»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»ºÃÒâ˼


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

ÇóÒ»ÌõSQL - MS-SQL Server / ÒÉÄÑÎÊÌâ

--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 ......

sql´æ´¢¹ý³Ìʱ¼äÏà¼õ - MS-SQL Server / »ù´¡Àà

CREATE PROCEDURE [selectvipcompany] 
@username varchar(50),
@companyname varchar(50),
@endtime varchar(1)
AS
declare @sql varchar(1000)
set @sql=''
if (@username<>null and @username ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ