ÇósqlÓï¾ä
Ñ¡³öÊý¾Ý¿âÖÐÈ«²¿µÄ ÒÔ el_ ¿ªÍ·µÄ ´æ´¢¹ý³ÌÃû
ÒÔ¿Õ¸ñ¸ô¿ªÒýÓà ÒÔ¿Õ¸ñ¸ô¿ª SQL code: declare @s varchar(8000) select @s=isnull(@s+' ','')+name from sys.objects where type='P' and name like 'el_%' select @s
Ïà¹ØÎÊ´ð£º
Á½ÖÖ´íÎó£º 1.Èç¹ûÎÒÕâÑùÉêÃ÷£ºResultSet rs;´íÎóÌáʾÈçÏ£º An error occurred at line: 51 in the jsp file: /index.jsp The local variable rs may not have been initialized 48: ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8 ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£ ½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë ÇëÎÊÎÊÌâÔÚÄÄ£¿ ×°¸öÖÐÎÄÈí¼þ¼´¿É. ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......
ÎÒÓÐÒ»Õűí Create table abc (ID int primary key, A varchar(20), B varchar(20)); Êý¾Ý¿âÖÐAºÍB×ֶβ»ÄÜÖØ¸´£¬Ò²¾ÍÊDZÈÈçÎÒ²åÈëÒ»Ìõ¼Ç¼ £ºinsert into abc(ID, A, B) values(1, abc123, abc456); ÎÒÔÚ²åÈëµÚ¶ ......
PHP code: ½«Êý¾Ý¿âÖеÄproc¶¼Ö´ÐÐÒ»±é ²»»áÊÇ EXEC sp_MSforeachtable£¿¿Ï¶¨²»ÊÇÀ²£¬ÊÇÊ²Ã´ÄØ£¿ 這個²»Ì«現實°É,ÓеÄÓÐ參數ÓеÄ沒ÓÐÔõ麼辦? Èç¹ûË ......