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

Visual StudioºÍSQL ServerµÄ°²×°Ë³ÐòÎÊÌâ

ÔÚ°²×°Visual Studio+SQL ServerµÄ¿ª·¢»·¾³µÄʱºòÍùÍù»áÓкܶà´íÎ󣬯äÖÐ×îÂé·³µÄÒ»Ìõ¾ÍËÀ°²×°Íê³ÉÖ®ºóûÓÐÊý¾Ý¿â¹ÜÀí¹¤¾ß£¬¼´Ã»ÓÐSQL Server 2005 Management Studio¡£³öÏÖÕâÑùµÄÎÊÌâÖ÷ÒªÓÐÁ½¸öÔ­Òò£¬Ò»ÊÇϵͳÒѾ­´æÔÚÆäËû°æ±¾µÄSQLÊý¾Ý¿â»òÕßExpress°æ±¾£¬¶þÊǰ²×°»·¾³µÄʱºòÏñÎÒÒ»ÑùÏȰ²×°ÁËVisual Studio 2005/2008£¬È»ºóһ·¿ñµãÏÂÒ»²½£¬½á¹û°²×°ÁËVS×Ô´øµÄExpress¼òÒ×°æÊý¾Ý¿â¡£
Èç¹û°²×°ÁËExpress°æÊý¾Ý¿â£¬¿ÉÒÔ°²×°Microsoft SQL Server Management Studio Express¹ÜÀí¹¤¾ßÀ´¹ÜÀíÕâ¸ö¼¯³ÉµÄСÊý¾Ý¿â£¬²»¹ýÕâ¸öÊý¾Ý¿âÖ»Äܵ¼³ö±íµÄ½á¹¹£¬²»Äܵ½´¦±íÀïÃæµÄÊý¾Ý£¬Êµ¼ùÖ¤Ã÷¿ÉÒÔ°ÑC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DataÀïÃæµÄ.mdfÎļþÈ¡³öÀ´¼´¿É»ñȡij¸öÊý¾Ý¿â¡£
²»¹ýºÜ¶àÈËÓ¦¸Ã¶¼²»ÏëֻʹÓÃÒ»¸öExpress°æ±¾µÄÊý¾Ý¿â£¬¼ÈÈ»ÎÒ¶¼¸ãµ½ÁËProfessiobal Edition°æ±¾µÄ£¬²»ÓþͶԲ»Æð΢ÈíµÄÒ»Æ¬ÕæÇéÁË£¬Ò»°ã½â¾öûÓÐÊý¾Ý¿â¹ÜÀí¹¤¾ßµÄ·½·¨ÈçÏ£º
1.ÏȰ²×°SQL Server 2005£¬ÔÙ°²×°vsÏà¹ØÈí¼þ¡£
2.ÔÚ°²×°vs2005»òvs2008ʱ£¬²»Òª°²×°SQL Server 2005 Express,VS°²×°ÍêºóÔÙ°²×°SQL Server 2005¡£
3.Èç¹ûÏȰ²×°ÁË vs2005 »ò vs2008ÇÒ°²×°ÁË×Ô´øµÄSQL Server Express 2005µÄ»°£¬µÃ°ÑÒÔǰµÄSQL Server 2005 ExpressÈ«²¿Ð¶Ôظɾ»£¬È»ºóÔÙ°²×°SQL Server 2005¡£
×îºó¾Í²»·¢ÐòÁкÅÁË£¬ÓÐÐèÒªµÄÕÒGoogle¼´¿É¡£


Ïà¹ØÎĵµ£º

¼òµ¥µÄsqlÊý¾Ý¿â´¥·¢Æ÷ʵÀý

--ͨ¹ýsqlÆóÒµ¹ÜÀíÆ÷Ð޸ĺÍɾ³ýa±íÖÐÊý¾Ýʱ»á³öÏÖ´íÎó
--sqlÆóÒµ¹ÜÀíBug£¬Í¨¹ý³ÌÐò»òÖ´ÐÐsqlÓï¾ä¸üÐÂa±íÊý¾ÝûÓÐÎÊÌâ
--Ìí¼Ó
Insert a (FName, FCode, FOther) Values('11','2222','33')
--ÐÞ¸Ä
Update a Set FName='22_Edit' Where FCode='22'
--ɾ³ý
Delete a Where FCode='22'
--²é¿´a/b±íÊý¾Ý
Select * from a ......

SQL ¼Ü¹¹

¼Ü¹¹£¨Schema£©¡£Î¢ÈíµÄ¹Ù·½ËµÃ÷£¨MSDN£©£º
"Êý¾Ý¿â¼Ü¹¹ÊÇÒ»¸ö¶ÀÁ¢ÓÚÊý¾Ý¿âÓû§µÄ·ÇÖØ¸´ÃüÃû¿Õ¼ä£¬Äú¿ÉÒÔ½«¼Ü¹¹ÊÓΪ¶ÔÏóµÄÈÝÆ÷"£¬Ïêϸ²Î¿¼
http://technet.microsoft.com/zh-cn/library/ms190387.aspx.ÎÒÃÇÖªµÀ£¬ÔÚJAVAÖУ¬ÃüÃû¿Õ
¼äÃûÆäʵ¾ÍÊÇÎļþ¼ÐÃû¡£Òò´ËÎÒÃǷdz£Ã÷È·Ò»µã£ºÒ»¸ö¶ÔÏóÖ»ÄÜÊôÓÚÒ»¸ö¼Ü¹¹£¬¾ÍÏ ......

SQL »ù±¾²Ù×÷ ɾ³ý ÐÞ¸Ä Ë¢Ð Ð޸İæ

C# Êý¾Ý¿âÖ®ÂÃ……
¼ÌÐø½ø¹¥²ã³ö²»ÇîµÄproblems
ÔÚÉÏһƪÄÚÈݵĻù´¡ÉÏ£¬ÎÒÓÖ×÷ÒԸĽø£¬ÏÖÔÚµÄÇé¿öÊÇÕâÑùµÄ£º
 //In Browseuser form
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System ......

·À·¶sql×¢Èë¹¥»÷£¨ÉÏ£©

ͬ²½Ò»ÏÂÎÒbaiduµÄblog£ºhttp://hi.baidu.com/ncheng/blog/item/bc65f82a1a6a7c335343c11c.html
Sql×¢ÈëÊÇÒ»ÖÖÈëÃż«µÍÆÆ»µ¼«´óµÄ¹¥»÷·½Ê½¡£Èç¹ûsqlÊÇÓÃ×Ö·û´®Æ´½Ó³öÀ´µÄ»°£¬ÄÇô¿Ï¶¨»á±»×¢Èë¹¥»÷£¬Ç°¶Îʱ¼ä»¹´«³öÁËij¹úÍâ´óÐÍÉç½»ÍøÕ¾±»SQL×¢Èë¹¥»÷¡£
Sql×¢Èë¹¥»÷µÄ·½Ê½£¬À´ÕâÀï¿´µÄͬ־ÃÇÓ¦¸ÃºÜÇå³þÁË£¬¾ÍÊÇÔÚÆ´½Ó×Ö·û´ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ