ÅäÖÃSQL Server 2005 ÒÔÔÊÐíÔ¶³ÌÁ¬½Ó
SQL Server 2005 ¿ª·¢°æ²»ÔÊÐíÔ¶³ÌÁ¬½Ó¡£
¡¡¡¡ÒªÔÊÐíÔ¶³ÌÁ¬½ÓSQL Server 2005 ,ÐèÒªÍê³ÉÒÔϲ½Ö裺
•ÔÚSQLServer ʵÀýÉÏÆôÓÃÔ¶³ÌÁ¬½Ó¡£
•´ò¿ª·þÎñÆ÷ SQLBrowser ·þÎñ¡£
•ÅäÖ÷À»ðǽÒÔÔÊÐíSQLBrowser ·þÎñºÍSQLServer·þÎñÍøÂçͨÐÅ¡£
¡¡¡¡ÔÚSQLServer ʵÀýÉÏÆôÓÃÔ¶³ÌÁ¬½Ó
1.Ö¸Ïò“¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß->SQL Server ÍâΧӦÓÃÅäÖÃÆ÷”
2.ÔÚ“SQL Server 2005 ÍâΧӦÓÃÅäÖÃÆ÷”Ò³, µ¥»÷“·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷”
3.È»ºóµ¥»÷Õ¹¿ª“Êý¾Ý¿âÒýÇ攣¬ Ñ¡ÖГԶ³ÌÁ¬½Ó”£¬ÔÚÓÒ±ßÑ¡ÖГ±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½Ó”£¬
ÔÙÑ¡ÔñҪʹÓõÄÐÒ飬µ¥»÷“Ó¦ÓÔ£¬Äú»á¿´µ½ÏÂÏûÏ¢£º
“Ö±µ½ÖØÐÂÆô¶¯Êý¾Ý¿âÒýÇæ·þÎñºó£¬¶ÔÁ¬½ÓÉèÖÃËù×öµÄ¸ü¸Ä²Å»áÉúЧ¡£”£¬µ¥»÷“È·¶¨”°´Å¥·µ»Ø
4.Õ¹¿ª“Êý¾Ý¿âÒýÇ攣¬ Ñ¡ÖГ·þÎñ”£¬ÔÚÓұߵ¥»÷“Í£Ö¹”£¬µÈµ½ MSSQLSERVER ·þÎñÍ£Ö¹£¬
È»ºóµ¥»÷“Æô¶¯”£¬ÖØÐÂÆô¶¯MSSQLSERVER ·þÎñ¡£
ÆôÓà SQLServer ä¯ÀÀÆ÷·þÎñ
1.Ö¸Ïò“¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß->SQL Server ÍâΧӦÓÃÅäÖÃÆ÷”
2.ÔÚ“SQL Server 2005 ÍâΧӦÓÃÅäÖÃÆ÷”Ò³, µ¥»÷“·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷”
3.È»ºóµ¥»÷Õ¹¿ª“SQL Server Browser”£¬ Ñ¡ÖГ·þÎñ”£¬ÔÚÓұߓÆô¶¯ÀàÐ͔ѡÔñ“×Ô¶¯”£¬
ÔÙµ¥»÷“Æô¶¯”£¬µ¥»÷“È·¶¨”°´Å¥·µ»Ø
ÔÚWindows ·À»ðǽÖÐΪ“SQL Server 2005”´´½¨ÀýÍâ
1.ÔÚ Windows ·À»ðǽÉèÖýçÃæÖУ¬Ñ¡Ôñ“ ÀýÍâ” Ñ¡Ï£¬È»ºóµ¥»÷“Ìí¼Ó³ÌÐò”
2.ÔÚ“Ìí¼Ó³ÌÐò´°¿Ú”Öе¥»÷“ä¯ÀÀ”
3.È»ºóÕÒµ½“C:\ProgramFiles\Microsoft Files\Microsoft SQL Server\ MSSQL.1 \MSSQL\Binn\sqlservr.exe”£¬
µ¥»÷“È·¶¨”·µ»Ø
×¢Òâ £º ·¾¶¿ÉÄÜ»á¸ù¾Ý SQL Server 2005 °²×°²»Í¬¶ø²»Í¬¡£ MSSQL.1 ÊÇռλ·û£¬¶ÔÓ¦Êý¾Ý¿âʵÀýID¡£
4.¶Ôÿ¸öÐèÒª´ò¿ªÔ¶³Ì·ÃÎʵÄSQL Server 2005 ʵÀý£¬Öظ´²½Öè 1 ÖÁ 3¡£
ÔÚWindows ·À»ðǽÖÐΪ“SQLBrowser”´´½¨ÀýÍâ
1.ÔÚ Windows ·À»ðǽÉèÖýçÃæÖУ¬Ñ¡Ôñ“ ÀýÍâ” Ñ¡Ï£¬È»ºóµ¥»÷&l
Ïà¹ØÎĵµ£º
Õâ¸öÌâÄ¿ÌýÆðÀ´Ê®·ÖÞÖ¿Ú£¬Ó¢ÎÄÓ¦¸ÃÕâÑùд“How to find the service pack version installed on SQL Server using”£¬Õâ¸öÎÊÌâÎÒÒ»Ö±ÔÚÕÒ£¬SQL ServerһֱûÓÐÏñÆäËûÈí¼þÒ»Ñù¿ÉÒÔÖ±½Ó²é¿´µ½°æ±¾+²¹¶¡ºÅµÄ·½·¨£¬½ñÌìµ½Ò»¸öÀÏÍâµÄÍøÕ¾ÖÕÓÚÕÒµ½ÁË£º
ÓÐÁ½ÖÖ·½·¨£º
µÚÒ»²½£ºÊ¹ÓÃSQLÓï¾ä²éѯ
select @@version ......
alter session set timed_statistics = true; --¿ÉÑ¡
alter session set max_dump_file_size = unlimited; --¿ÉÑ¡£¬·ÀÖ¹dumpĿ¼·Å²»ÏÂ
-- To enable the trace event 10046
alter session set events '10046 trace name context forever, level 8';
--ÉèÖÃTRACEFILE_IDENTIFIER²ÎÊýÖµ£¬ÈÃtraceÎļþ°üÀ¨MyTrac ......
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØʵÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾ ......
¼òµ¥Ì¸»ùÓÚSQL SERVER ·ÖÒ³´æ´¢¹ý³ÌµÄÑݽø
×÷ÕߣºÖ£×ô
ÈÕÆÚ£º2006-9-30
Õë¶ÔÊý¾Ý¿âÊý¾ÝÔÚUI½çÃæÉϵķÖÒ³ÊÇÀÏÉú³£Ì¸µÄÎÊÌâÁË£¬ÍøÉϺÜÈÝÒ×ÕÒµ½¸÷Ö֓ͨÓô洢¹ý³Ì”´úÂ룬¶øÇÒÓÐЩ»¹¶¨ÖƲéѯÌõ¼þ£¬¿´ÉÏȥʹÓúܷ½±ã¡£±ÊÕß´òËãͨ¹ý±¾ÎÄÒ²À´¼òµ¥Ì¸Ò»Ï»ùÓÚSQL SERVER 2000µÄ·ÖÒ³´æ´¢¹ý³Ì£¬Í¬Ê±Ì¸Ì¸SQL SER ......
µÚÒ»ÖÖ·½·¨: ʹÓÃoutput²ÎÊý
USE AdventureWorks;
GO
IF OBJECT_ID ( 'Production.usp_GetList', 'P' ) IS NOT NULL
DROP PROCEDURE Production.usp_GetList;
GO
CREATE PROCEDURE Production.usp_GetList @product varchar(40)
, @maxprice money
&nb ......