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

SQL SERVER 2005Ïà¹ØÎÊÌâ

Òѳɹ¦Óë·þÎñÆ÷½¨Á¢Á¬½Ó£¬µ«ÊÇÔڵǼǰµÄÎÕÊÖÆڼ䷢Éú´íÎóµÄ´¦Àí·½·¨
      ÔÚÓÃSQL SERVER Óû§µÇ½SQL SERVER 2005ʱ£¬µ¯³öÒ»¸ö¶Ô»°¿ò£¬Ìáʾ" Òѳɹ¦Óë·þÎñÆ÷½¨Á¢Á¬½Ó£¬µ«ÊÇÔڵǼǰµÄÎÕÊÖÆڼ䷢Éú´íÎó",²éÕÒÁËÒ»ÏÂÔ­Òò£¬Ô­À´ÊÇSQL SERVER 2005ʱ½ûÓÃTCP/IPµÇ½ÁË£¬´ò¿ªSQL SERVER 2005²Ëµ¥ÖеÄÅäÖù¤¾ßϵÄSQL SERVER Configuration Manager.µã»÷´°ÌåÖУ¬´ò¿ªSQL SERVER 2005 ÍøÂçÅäÖõÄϽڵ㣬ѡÔñMSSQLSERVERµÄЭÒé¡£°ÑÓұߴ°¿ÚµÄTCP/IPµÄÊôÐÔÒѽûÓ㬸ÄΪÒÑÆôÓ㬾ÍOKÁË¡£
ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL Server µÄÁ¬½Ó)
1. Êý¾Ý¿âÒýÇæûÓÐÆô¶¯¡£
ÓÐÁ½ÖÖÆô¶¯·½Ê½:
(1)¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->SQL Server 2005ÍâΧӦÓÃÅäÖÃÆ÷,ÔÚ´ò¿ªµÄ½çÃæµ¥»÷"·þÎñµÄÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷",ÔÚ´ò¿ªµÄ½çÃæÖÐÕÒµ½Database Engine,µ¥»÷"·þÎñ",ÔÚÓÒ²à²é¿´ÊÇ·ñÒÑÆô¶¯,Èç¹ûûÓÐÆô¶¯¿Éµ¥»÷"Æô¶¯",²¢È·±£"Æô¶¯ÀàÐÍ"Ϊ×Ô¶¯,²»ÒªÎªÊÖ¶¯,·ñÔòÏ´οª»úʱÓÖÒªÊÖ¶¯Æô¶¯;
(2)¿É´ò¿ª:¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß->SQL Server Configuration Manager,Ñ¡ÖÐSQL Server 2005·þÎñÖÐSQL Server(MSSQLSERVER) ,²¢µ¥»÷¹¤¾ßÀ¸ÖеÄ"Æô¶¯·þÎñ"°´Å¥°Ñ·þÎñ״̬¸ÄΪÆô¶¯;
ʹÓÃÉÏÃæÁ½ÖÖ·½Ê½Ê±,ÓÐʱºòÔÚÆô¶¯µÄʱºò¿ÉÄÜ»á³öÏÖ´íÎó,²»ÄÜÆô¶¯,Õâʱ¾ÍÒª²é¿´"SQL Server 2005ÅäÖùÜÀíÆ÷"ÖеÄSQL Server 2005ÍøÂçÅäÖÃ->MSSQLSERVERЭÒéÖеÄVIAÊÇ·ñÒÑÆôÓÃ,Èç¹ûÒÑÆôÓÃ,Ôò°ÑËü½ûÖ¹.È»ºóÔÙÖ´ÐÐÉÏÊöÒ»ÖÖ·½Ê½²Ù×÷¾Í¿ÉÒÔÁË.
2. ÊÇ·ñÒѾ­ÔÊÐíÔ¶³ÌÁ¬½Ó¡£
Õâ¸ö²¿·Ö¿ÉÒÔ¼òµ¥µÄ·ÖΪ4¸ö·½Ã棬·Ö±ðÊÇÔÚ SQL ServerÉÏÆôÓÃÔ¶³ÌÁ¬½Ó¡¢ÆôÓÃSQL Server ä¯ÀÀ·þÎñ¡¢ÔÚWindows ·À»ðǽÖÐΪSQL Server 2005 ´´½¨ÀýÍâºÍÔÚWindows ·À»ðǽÖÐΪ“SQLBrowser”´´½¨ÀýÍâ¡£ÏÂÃæÊǼ¸¸ö¾ßÌåµÄ²Ù×÷·½Ê½£¬Õª×ÔMSDN£¬¸öÈ˾õµÃÎÄÕµĺÚÌ岿·ÖÓ¦µ±ÌرðµÄÒ»ÆðÎÒÃǵÄ×¢Òâ¡£
ÔÚSQLServer ʵÀýÉÏÆôÓÃÔ¶³ÌÁ¬½Ó
1.Ö¸Ïò“¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß->SQL Server ÍâΧӦÓÃÅäÖÃÆ÷”
2.ÔÚ“SQL Server 2005 ÍâΧӦÓÃÅäÖÃÆ÷”Ò³, µ¥»÷“·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷”
3.È»ºóµ¥»÷Õ¹¿ª“Êý¾Ý¿


Ïà¹ØÎĵµ£º

1.The SQL introuduction

Introducing Oracle Database 11g
List the features of Oracle Database 11g
Discuss the basic design, theoretical and physical aspects of a relational database
Categorize the different types of SQL statements
Describe the data set used by the course
Log onto the database using the SQL Develope ......

shopxpÍøÉϹºÎïϵͳ v7.4´æÔÚSQL×¢È멶´

shopxpÍøÉϹºÎïϵͳ v7.4´æÔÚSql×¢È멶´¡£
ÎÊÌâÎļþ£ºxpCatalog_xpDesc.asp£¬xpCatalog_xpsmall_Desc.asp
ÎÊÌâ´úÂ룺
<%
dim shopxpbe_id, anclassname, shopxpse_id, nclassname
dim totalPut
dim CurrentPage, TotalPages
if request("shopxpbe_id")<>"" then
shopxpbe_id=request("shopxpbe_id")
e ......

Ô¶³Ì±¸·ÝsqlÊý¾Ý¿âµ½±¾»ú

 Ìõ¼þ£º
    ÓµÓÐsaȨÏÞ
    ¿ªÆô xp_cmdshell
·½·¨£º
 ¿ªÆô/¹Ø±Õ xp_cmdshell ±ØÐëÔÚ master  ¿âÖ´ÐÐ
EXEC sp_configure 'show advanced options', 1 
RECONFIGURE WITH OVERRIDE 
EXEC sp_configure 'xp_cmdshell', 1 
RECONFIGURE ......

¶ÔSQL˵²»£¡NoSQLµÄÊý¾Ý¿â¼¼Êõ¸ïÃü

¸ÐлÌ῵µÂÂÞ¼ÓµÄͶµÝ
    ¾ÍÏñµ±Ä겨ʿ¶ÙµÄ°®¹úÕßΪ·´¿¹Ó¢¹úÖØË°µÄÐж¯Ò»Ñù£¬NoSQLµÄÖ§³ÖÕßÃÇ´Ó¸÷µØÓ¿À´£¬·ÖÏíËûÃÇÈçºÎÍÆ·­»ºÂý¶ø°º¹óµÄ¹ØϵÊý¾Ý¿âµÄ±©Õþ£¬ÔõÑùʹÓøüÓÐЧºÍ¸ü±ãÒ˵ķ½·¨À´¹ÜÀíÊý¾Ý£¬ËûÃÇ¿ªÊ¼¶ÔSQL˵²»£¡NoSQL×éÖ¯ÉϸöÔÂÔھɽðɽµÄÐж¯ÈÃÈËÎŵ½ÁËÊý¾Ý¿â¸ïÃüµÄζµÀ£¬ºÃÏñÒ»¸öÏÖ´úITÒµ°æµÄ²¨ ......

sql 2005 ·ÖÒ³£¬ÅÅÃûº¯Êý

 WITH V AS(SELECT ROW_NUMBER() OVER(order by fcustid desc) AS RN,*  from  ts_dict AS SourceView)
SELECT * from V WHERE RN BETWEEN 1 AND 10
תÔصØÖ·£ºhttp://www.cnblogs.com/nokiaguy/archive/2009/02/05/1384860.html
ÅÅÃûº¯ÊýÊÇSQL Server2005мӵŦÄÜ¡£ÔÚSQL Server2005ÖÐÓÐÈçÏÂËĸöÅÅÃûº ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ