Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 Server? ÔÊÐíΪ INSERT¡¢UPDATE¡¢DELETE ´´½¨´¥·¢Æ÷£¬¼´µ±ÔÚ±íÖвåÈë¡¢¸üС¢É¾³ý¼Ç¼ʱ£¬´¥·¢Ò»¸ö»òһϵÁÐ T-SQLÓï¾ä¡£
´¥·¢Æ÷¿ÉÒÔÔÚ²éѯ·ÖÎöÆ÷Àï´´½¨£¬Ò²¿ÉÒÔÔÚ±íÃûÉϵãÓÒ¼ü->“ËùÓÐÈÎÎñ”->“¹ÜÀí´¥·¢Æ÷”À´´´½¨ ......

ÓÃÃüÁîÐÐÖ´ÐÐSQL½Å±¾Óï·¨½âÎö

osql   ʵÓù¤¾ß  
  osql   ʵÓù¤¾ßʹÄúµÃÒÔÊäÈë   Transact-SQL   Óï¾ä¡¢ÏµÍ³¹ý³ÌºÍ½Å±¾Îļþ¡£¸ÃʵÓù¤¾ßͨ¹ý   ODBC   Óë·þÎñÆ÷ͨѶ¡£  
   
  Óï·¨  
  osql  
          [-?]   |  
&nb ......

SQL SERVER ÊÓͼ Garin Zhang

ÊÓͼ
SET¡¡NOCOUNT ON;
SET Northwind;
GO
IF OBJECT_ID('dbo.ViewName') IS NOT NULL
    DROP VIEW dbo.ViewName;
GO
CREATE VIEW dbo.Viewname
AS
SELECT * from customer AS C
WHERE EXISTS
    (SELECT * from dbo.Orders AS O
     WHERE O.CustomerI ......

SQL ³£Óú¯Êý ±Ê¼Ç Garin Zhang

SQL³£Óú¯Êý£º
1. ASCII()£º·µ»Ø×Ö·û´®×î×ó¶Ë×Ö·ûµÄASCIIÂë¡£
2. CHAR()£º½«ASCIIת»»³É×Ö·û¡£(0~255)
3. LOWER()ºÍUPPER()¡£
4. STR()£º°ÑÊýÖµÐÍÊý¾Ýת»»Îª×Ö·ûÐÍÊý¾Ý
    SRT(<float_expression>[,length[,<decimal>]])
LTRIM()°Ñ×Ö·û´®Í·²¿¿Õ¸ñÈ¥µô£¬RTRIM()°Ñ×Ö·û´®Î²¿Õ¸ñÈ¥µô¡£
È¡× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ