SQLÊÓÆµ½Ì³Ì
˸øÎÒÍÆ¼öÒ»¸öSQL±È½ÏºÃÒ»µãµÄÊÓÆµ½Ì³Ìѽ! ±¾ÈË×Ôѧ£¬¿´ÊéºÜÍ´¿à£¡ Íû¸ßÈËÖ¸µã ÒÔǰÎÒ¿´21»¥ÁªµÄ½Ì³Ì¿ÉÏÂÔØ²»ÁË£¡ ˻᣿°ïÎÒ£¡
ºÀÃÅÊ¢ÑçϵÁС£ È¥Óſῴ¿´ÒýÓà ˸øÎÒÍÆ¼öÒ»¸öSQL±È½ÏºÃÒ»µãµÄÊÓÆµ½Ì³Ìѽ! ±¾ÈË×Ôѧ£¬¿´ÊéºÜÍ´¿à£¡ Íû¸ßÈËÖ¸µã ÒÔǰÎÒ¿´21»¥ÁªµÄ½Ì³Ì¿ÉÏÂÔØ²»ÁË£¡ ˻᣿°ïÎÒ£¡ ºÃÏówww.itpub.netÉÏÓÐ. .
Ïà¹ØÎÊ´ð£º
sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿ ʲôÒâ˼£¿ ¿ÉÒ﵀ 10¸ö¶¼Ã»ÎÊÌâ ¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã ......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ ÀýÈç£ ......
³¡¾°ÈçÏ£º ¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ôºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......
CREATE PROCEDURE [selectvipcompany] @username varchar(50), @companyname varchar(50), @endtime varchar(1) AS declare @sql varchar(1000) set @sql='' if (@username<>null and @username ......
<table style="width: 1000px"><tr> <td style="height: 38px; width: 35px;"> ÐÕÃû</td> ......