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.È»ºóµ¥»÷Õ¹¿ª“Êý¾Ý¿
Ïà¹ØÎĵµ£º
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×¢È멶´¡£
ÎÊÌâÎļþ£º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 ......
Ìõ¼þ£º
ÓµÓÐsaȨÏÞ
¿ªÆô xp_cmdshell
·½·¨£º
¿ªÆô/¹Ø±Õ xp_cmdshell ±ØÐëÔÚ master ¿âÖ´ÐÐ
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
EXEC sp_configure 'xp_cmdshell', 1
RECONFIGURE ......
¸ÐлÌ῵µÂÂÞ¼ÓµÄͶµÝ
¾ÍÏñµ±Ä겨ʿ¶ÙµÄ°®¹úÕßΪ·´¿¹Ó¢¹úÖØË°µÄÐж¯Ò»Ñù£¬NoSQLµÄÖ§³ÖÕßÃÇ´Ó¸÷µØÓ¿À´£¬·ÖÏíËûÃÇÈçºÎÍÆ·»ºÂý¶ø°º¹óµÄ¹ØϵÊý¾Ý¿âµÄ±©Õþ£¬ÔõÑùʹÓøüÓÐЧºÍ¸ü±ãÒ˵ķ½·¨À´¹ÜÀíÊý¾Ý£¬ËûÃÇ¿ªÊ¼¶ÔSQL˵²»£¡NoSQL×éÖ¯ÉϸöÔÂÔھɽðɽµÄÐж¯ÈÃÈËÎŵ½ÁËÊý¾Ý¿â¸ïÃüµÄζµÀ£¬ºÃÏñÒ»¸öÏÖ´úITÒµ°æµÄ²¨ ......
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ÖÐÓÐÈçÏÂËĸöÅÅÃûº ......