SQL SERVERµÄÉó¼Æ¹¦ÄÜ
ÆôÓÃc2ÉóºËÃüÁîÈçÏ£º
EXEC sp_configure 'c2 audit mode', '1' RECONFIGURE
SQL ServerÒÔ128KB´óСµÄ¿éΪµ¥Î»°ÑÊý¾ÝдÈë¸ú×ÙÎļþ¡£Òò´Ë£¬µ±SQL Server·ÇÕý³£Í£Ö¹Ê±£¬×î¶à¿ÉÄܶªÊ§128
KBµÄÈÕÖ¾Êý¾Ý¡£¿ÉÒÔÏëÏ󣬰üº¬ÉóºËÐÅÏ¢µÄÈÕÖ¾Îļþ½«ÒԺܿìµÄËÙ¶ÈÔö´ó¡£ÀýÈ磬ij´ÎÊÔÑéÖ»·ÃÎÊÁËÈý¸ö±í£¬¸ú×ÙÎļþÒѾ³¬¹ýÁË1MB¡£µ±¸ú×ÙÎļþ³¬¹ý
200MBʱ£¬C2ÉóºË½«¹Ø±Õ¾ÉÎļþ²¢´´½¨ÐÂÎļþ¡£Ã¿´ÎSQL ServerÆô¶¯µÄʱºò£¬Ëü»á´´½¨Ò»¸öеĸú×ÙÎļþ¡£Èç¹û´ÅÅ̿ռ䲻×㣬SQL
Server½«Í£Ö¹ÔËÐУ¬Ö±ÖÁÎÒÃÇΪÉóºËÈÕÖ¾Êͷųö×ã¹»µÄ´ÅÅ̿ռ䲢ÖØÐÂÆô¶¯SQL ServerʵÀý¡£ÔÚSQL
ServerÆô¶¯µÄʱºò£¬¿ÉÒÔʹÓÃ-f²ÎÊý½ûÓÃÉóºË¡£
Ïà¹ØÎĵµ£º
SQLÓï·¨ÊÖ²á
Select
ÓÃ;£º
´ÓÖ¸¶¨±íÖÐÈ¡³öÖ¸¶¨µÄÁеÄÊý¾Ý
Óï·¨£º
SELECT column_name(s) from table_name
½âÊÍ£º
´ÓÊý¾Ý¿âÖÐÑ¡È¡×ÊÁÏÁУ¬²¢ÔÊÐí´ÓÒ»»ò¶à¸ö×ÊÁϱíÖУ¬Ñ¡È¡Ò»»ò¶à¸ö×ÊÁÏÁлò×ÊÁÏÐС£SELECT ³ÂÊöʽµÄÍêÕûÓï·¨Ï൱¸´ÔÓ£¬µ«Ö÷Òª×Ó¾ä¿ÉժҪΪ£º
SELECT select_ ......
SELECT TOP 10 *
from HumanResources.Employee
WHERE EmployeeID NOT IN (SELECT TOP 0 EmployeeID from HumanResources.Employee ORDER BY EmployeeID desc)
ORDER BY EmployeeID desc
—————————————————&md ......
×Ô£ºhttp://blog.csdn.net/AJAXBloger/archive/2007/08/29/1764506.aspx
×Ó²éѯ£º
ʹÓÃ×Ó²éѯµÄÔÔò
1.Ò»¸ö×Ó²éѯ±ØÐë·ÅÔÚÔ²À¨ºÅÖС£
2.½«×Ó²éѯ·ÅÔڱȽÏÌõ¼þµÄÓÒ±ßÒÔÔö¼Ó¿É¶ÁÐÔ¡£
×Ó²é
ѯ²»°üº¬ ORDER BY ×Ӿ䡣¶ÔÒ»¸ö SELECT Óï¾äÖ»ÄÜÓÃÒ»¸ö ORDER BY ×Ӿ䣬
²¢ÇÒÈç¹ûÖ¸¶¨ÁËËü¾Í±ØÐë·ÅÔÚÖ÷
SELECT Óï¾äµÄ×î ......
char¡¢varchar¡¢textºÍnchar¡¢nvarchar¡¢ntext
charºÍvarcharµÄ³¤¶È¶¼ÔÚ1µ½8000Ö®¼ä£¬ËüÃǵÄÇø±ðÔÚÓÚcharÊǶ¨³¤×Ö·ûÊý¾Ý£¬¶øvarcharÊDZ䳤×Ö·ûÊý¾Ý¡£Ëùν¶¨³¤¾ÍÊdz¤¶È¹Ì¶¨
µÄ£¬µ±ÊäÈëµÄÊý¾Ý³¤¶ÈûÓдﵽָ¶¨µÄ³¤¶Èʱ½«×Ô¶¯ÒÔÓ¢ÎÄ¿Õ¸ñÔÚÆäºóÃæÌî³ä£¬Ê¹³¤¶È´ïµ½ÏàÓ¦µÄ³¤¶È£»¶ø±ä ......
¡¶SQL Sever 2005 Êý¾Ý¿â»ù´¡¼°Ó¦Óü¼Êõ½Ì³ÌÓëʵѵ ¡· ÖÜÆæ
SQL Server 2005µÄ°æ±¾£º
1. SQL Server 2005 Enterprise Edition ÆóÒµ°æ(32λºÍ64λ)
ÊÊÓÃÓÚ³¬´óÐÍÆóÒµ¡£Enterprise Edition ÊÇ×îÈ«ÃæµÄSQL Server°æ±¾£¬Êdz¬´óÐÍÆóÒµµÄÀíÏëÑ¡Ôñ£¬Äܹ»Âú×ã×ÔÓµÄÒªÇ󡣸ð汾»¹Í ......