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

PL/SQLÓïÑÔ£¨¶þ£©

PL/SQLÓïÑÔ
1¡¢¿ÉÖ´Ðв¿·Ö£¨BEGIN£©
    ×é³ÉÓï¾ä£º
 
±äÁ¿¸³ÖµÓï¾ä¡£
Á÷³Ì¿ØÖÆÓï¾ä¡£
Êý¾Ý²éѯ¡¢Êý¾Ý²Ù×Ý¡¢ÊÂÎñ¿ØÖÆÓï¾ä¡£
ÓαêÓï¾ä¡£
2¡¢¿ÉÖ´Ðв¿·Ö£¬SQLÓï¾äµÄʹÓÃ
ÔÚ¿ÉÖ´Ðв¿·Ö£¬¿ÉÒÔʹÓÃSQLÓï¾ä£¬µ«ÊDz»ÊÇËùÓеÄSQLÓï¾ä¶¼¿ÉÒÔʹÓá£
¿ÉÒÔʹÓõÄÖ÷ÒªÓУºSELECT¡¢INSERT¡¢UPDATE¡¢DELETE¡¢COMMIT¡¢ROLLBACKµÈÊý¾Ý²éѯ¡¢Êý¾Ý²Ù×Ý»òÊÂÎñ¿ØÖÆÃüÁî¡£
²»ÄÜʹÓÃCREATE ¡¢ALTER¡¢DROP¡¢GRANT¡¢REVOKEµÈÊý¾Ý¶¨ÒåºÍÊý¾Ý¿ØÖÆÃüÁî¡£
˵Ã÷£º
     a:ÔÚPL/SQLÖУ¬SELECTÓï¾ä±ØÐëÓëINTO×Ó¾äÏàÅäºÏ£¬ÔÚINTO×Ó¾äºóÃæ¸úÐèÒª¸³ÖµµÄ±äÁ¿¡£
     b:ÔÚʹÓÃSELECT...INTO...ʱ£¬½á¹ûÖ»ÄÜÓÐÒ»Ìõ£¬Èç¹û·µ»ØÁ˶àÌõÊý¾Ý»òûÓÐÊý¾Ý£¬Ôò½«²úÉú´íÎó¡£
     c:ÔÚPL/SQLÖУ¬SQLÓï¾äµÄÓï·¨ºÍ½»»¥ÃüÁîÊÇÒ»ÑùµÄ¡£
3¡¢±í´ïʽ
      ²Ù×÷·û                                                                            ËµÃ÷
      +¡¢-                                                                              Õý¡¢¸º
      +¡¢-¡¢*¡¢/¡¢**                                   &


Ïà¹ØÎĵµ£º

SQL Server 2008Ô¶³ÌÁ¬½Ó

1¡¢ÆôÓÃÔ¶³ÌÁ¬½Ó
¿ªÊ¼——ËùÓгÌÐò——Microsoft SQL Server 2008——ÅäÖù¤¾ß——SQL ServerÅäÖùÜÀíÆ÷
SQL Server NetWork ConfigurationÖÐÑ¡ÔñЭÒ飬"Named pipes"ºÍ"TCP/IP"¶¼Ñ¡ÔñEnable£¬È»ºóµã»÷"TCP/IP"Ñ¡ÊôÐÔ£¬IP Address Ñ¡Ï£¬½«ËùÓÐµÄ TCP¶¯Ì¬¶Ë¿Ú µÄ0È«²¿È¥µô£¬ÔÚ ......

SQL´æ´¢¹ý³ÌÖÐSELECTÓëSET ¶Ô±äÁ¿¸³ÖµµÄÇø±ð

²Î¿¼£ºhttp://gaowenjie7758.blog.163.com/blog/static/5946788920091116244306/
SQL´æ´¢¹ý³ÌÖÐSELECTÓëSET ¶Ô±äÁ¿¸³ÖµµÄÇø±ð
SQL Server ÖжÔÒѾ­¶¨ÒåµÄ±äÁ¿¸³ÖµµÄ·½Ê½ÓÃÁ½ÖÖ£¬·Ö±ðÊÇ SET ºÍ SELECT¡£¶ÔÓÚÕâÁ½ÖÖ·½Ê½µÄÇø±ð£¬SQL Server Áª»ú´ÔÊéÖÐÒѾ­ÓÐÏêϸµÄ˵Ã÷£¬µ«ºÜ¶àʱºòÎÒÃDz¢Ã»ÓÐ×¢Ò⣬ÆäʵÕâÁ½ÖÖ·½Ê½»¹ÊÇÓкܶ ......

SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ

SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ
 
 ÊÕ²Ø
--> Title  : SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ
 
--> Author : wufeng4552
 
--> Date   : 2009-11-11
 
SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ
 
(Ò»)¸ÅÄî:
 
·Ö²¼Ê½ÊÂÎñÊÇÉæ¼°À´×ÔÁ½¸ö»ò¶à¸öÔ´µÄ×ÊÔ´µÄÊÂÎñ¡£Microsoft® SQL Serv ......

SQL Server 2000 Êý¾Ý¿âͬ²½(×ªÔØ)


ΪʲôҪͬ²½SQL Server 2000 Êý¾Ý¿â£¬Ëü¶¼ÓÃÔÚʲô³¡ºÏ
Êý¾Ýʵʱ±¸·Ýͬ²½£¬Êý¾Ý¿â·þÎñÆ÷³öÎÊÌâʱÎÒÃÇÒ²ÓÐÆäÕý³£¹¤×÷ʱµÄ±¸·Ý
Êý¾Ýʵʱ±¸·Ýͬ²½£¬Ò»Ì¨·þÎñÆ÷¸ºÔز»Æðʱ£¬¿ÉÒÔÓÃÀ´×ö¸ºÔؾùºâ
Êý¾Ýʵʱ±¸·Ýͬ²½£¬Êý¾Ý¿â·þÎñÆ÷¿ÉÒÔÎÞ¼ä¶Ï£¬ÎÞËðÊ§Ç¨ÒÆ
Ö÷·þÎñÆ÷±»¹¥»÷»òµ±»úʱÁíһ̨·þÎñͬ²½»ú¿ÉÒÔÓ¦¼±
¡£¡£¡£¡£¡£¿ÉÒÔ˵ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ