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

Ò»´ò¿ª SQL Server Management Studio ²éѯËÙ¶ÈÌØÂý

Êý¾Ý¿âSQL2005£¬Î´½øÐйýÈκÎÉý¼¶

ÒÔǰºÃºÃµÄ£¬×î½üÒ»¸öÐÇÆÚÒÔÀ´£¬
Ö»ÒªÒ»´ò¿ªSQL Server Management Studio£¬
ÄÇôͨ¹ý¿Í»§¶Ë½øÐÐËùÓвÙ×÷£¨Ôöɾ¸Ä²é£©ËÙ¶È»á±äµÄÌØ±ðÂý£¬ÄÄÅÂ×î¼òµ¥µÄ²éѯҲÂýµÄÒªËÀ£¬
ÔÚSQL Server Management StudioÖÐÖ´ÐÐSQLÓï¾äҲͬÑùÂý£¬
Ö»ÒªÒ»¹ØµôSQL Server Management StudioËÙ¶ÈÁ¢¼´¾Í¿ìÆðÀ´£¬
²»ÖªµÀÊÇʲôԭÒò£¬Çë¸÷λ°ï°ïæ

ɾ³ý֨װÊÔÊÔ

³ÌÐòÖж¾ÁË£¿

Ŀǰ¿ÉÒԿ϶¨µØÅųýÖж¾»òÖÐľÂíµÄÔ­Òò£¬ÊµÔÚ²»Ïë֨װ°¡£¬×Ü»áÓÐÔ­ÒòµÄ°É£¬ÓôÃÆ


ÒýÓÃ
Êý¾Ý¿âSQL2005£¬Î´½øÐйýÈκÎÉý¼¶

ÒÔǰºÃºÃµÄ£¬×î½üÒ»¸öÐÇÆÚÒÔÀ´£¬
Ö»ÒªÒ»´ò¿ªSQL Server Management Studio£¬
ÄÇôͨ¹ý¿Í»§¶Ë½øÐÐËùÓвÙ×÷£¨Ôöɾ¸Ä²é£©ËÙ¶È»á±äµÄÌØ±ðÂý£¬ÄÄÅÂ×î¼òµ¥µÄ²éѯҲÂýµÄÒªËÀ£¬
ÔÚSQL Server Management StudioÖÐÖ´ÐÐSQLÓï¾äҲͬÑùÂý£¬
Ö»ÒªÒ»¹ØµôSQL Server Management StudioËÙ¶ÈÁ¢¼´¾Í¿ìÆðÀ´£¬
²»ÖªµÀÊÇʲôԭÒò£¬Çë¸÷λ°ï°ïæ

ûÓöµ½ÕâÖÖÇé¿ö,°ï¶¥.

´òÉÏ2005µÄ²¹¶¡ÊÔÊÔ

ÊÔÊÔsp3µÄ²¹¶¡

лл¸÷λ
ÎÊÌâ½â¾ö
ÕæÊÇÓеã¼ú£¬²»ÌáÎʾͲ»Ô¸Òâ×ÐϸµØ²éÔ­Òò£¬
ºÇºÇ

½â¾ö°ì·¨ÈçÏ£º
ÔÚÅäÖùÜÀíÆ÷ÖУ¨SQL Server Configuration Manager)£¬
SQL Server2005 ÍøÂçÅäÖÃ-->SQL2005 µÄЭÒ飬
²»ÖªµÀʲôʱºòÖ»¿ªÆôÁËÒ»¸öЭÒ飨Shared Memory),
TCP/IPЭÒ龹Ȼ먦Æô
È»ºó¿ªÆôÁËTCP/IP¼°ÃüÃû¹ÜµÀ£¬
ÎÊÌâ½â¾ö

лл´ó¼ÒÁË

´òSP3²¹¶¡

ÒýÓÃ


Ïà¹ØÎÊ´ð£º

ÃÅÍ⺺ÇóÖú...¹ØÓÚºǫ́+SQL+ASP

....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷Ô­À´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

sql server ´æ´¢¹ý³ÌÑ­»·¸³ÖµµÄÎÊÌâ

СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......

Çë½Ì¸÷λ´ó¸çÒ»¸öSqlÎÊÌ⣬Äĸö°à¼¶µÄ½Ìʦ´ýÓö×î¸ß£¿

СµÜ×î½üÓöµ½Ò»¸öÎÊÌ⣬ҪÇóµÃ³öÄĸö°à¼¶µÄ½Ìʦ´ýÓö×î¸ß£¬°Ñͬһ¸ö°à¼¶µÄ½Ìʦ´ýÓöºÏ¼ÆÆðÀ´


°à¼¶±í                  ½Ìʦ±í

°à¼¶ID    & ......

C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿

C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}

Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£

ÒýÓÃ
try
{
connection.connect( ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ