CREATE PROCEDURE dbo.my AS
set nocount on
begin
select * into #ls1 from
(select * from a where f_yf='2') t
go
¼ÙÉèÎÒµÄsqlÒѾÓÐÁËÕâÑùµÄÒ»¸ö´¢´æ¹ý³Ì,aspÍøÒ³µ÷ÓÃÕâ¸ö´¢´æ¹ý³Ìmy.
Äܲ»ÄÜÖ¸µãÏÂÕâ¸öf_yf='2' ¿ÉÒÔÓÉÍøÒ³ÊäÈë½øÈëÕâ¸ö´¢´æ¹ý³ÌÂð? ±ÈÈçÒ»¸öÏÂÀ²Ëµ¥ÓÐ1-12µÄÊý×ÖÑ¡Ïî,Ñ¡Ôñ1È»ºó°´² ......
´ó¼ÒºÃ,Çë´ó¼Ò°ïæ,ÒªÇóASPµ¼³ö³ÉCSVʱ,µ¼³öµÄ¼Ç¼ÖÐÿÌõ¼Ç¼֮¼äÓûسµ¸ô¿ª,×îºóÒ»Ìõ¼Ç¼²»ÔÊÐí³öÏֻسµ·û,×îÖÕЧ¹ûÈçÏÂ:
ÕÅÈý,1983-02-23,ÄÐ,±¾¿Æ(´Ë´¦»Ø³µ·û)
ÀîËÄ,1983-02-24,ÄÐ,´óר(´Ë´¦»Ø³µ·û)
ÍõÂé×Ó,1983-02-24,ÄÐ,ÖÐר(´Ë´¦²»ÔÊÐí»Ø³µ·û,×îºóÒ»Ìõ¼Ç¼)
ÎÒÏÖÓеĴúÂëÊÇ:
set rs = conn.Execute("select ......
µ÷ÊÔµÄʱºòÏÂÃæÕâ¶Î×ÜÊÇÌáʾÎÒ
´íÎóÀàÐÍ£º
Active Server Pages, ASP 0126 (0x80004005)
ÕÒ²»µ½°üº¬Îļþ 'adovbs.inc'¡£
/qtest/100/publisharticle.asp, µÚ 2 ÐÐ
´úÂëµÚ2ÐÐÊÇÏÂÃæÕâÑù¡£Ò²È·Êµ´æÔÚÕâ¸öÎļþ¡£
<!--#include virtual="adovbs.inc"-->
Ôõô»ØÊ°¡£¿
......
Ä¿µÄ¾ÍÊÇ´ò¿ªÍøÒ³²¢È«ÆÁºó²»ÈÃÓû§À뿪ä¯ÀÀÆ÷£¬³ý·Çµã»÷Í˳ö°´Å¥¡£
ÏÖÔÚÓÃjsÄÜ×öµ½ÏñÆÁ±ÎÓÒ¼üµÄ¸´ÖÆ£¬Õ³Ìù£¬alt+f4,alt+·½Ïò¼üµÈ²Ù×÷¡£
ÇëÎÊÄÜÆÁ±Îalt+tabºÍctrl+alt_delÂð£¿
¿ÉÒԵģ¡
Äã¿ÉÒÔÕâÑùд:
<body>
<script type="text/javascript">
function document.body ......
json = "[{'uid':'1','username':'abc','email':'123@163.com'},{'uid':'2','username':'xxx','email':'4444@163.com'}]"
Õâ¸öASPµÄÒ»¸öJSONÊý×飬ÇëÎÊÎÒ¸ÃÈçºÎ°Ñuid,username,email,ÀïÃæµÄÖµ¸øµ¥¶ÀÈ¡³ ......
ÔõôÔÚaspÀïÓÐÒ»¸öDefaultµÄÇé¿öÏ£¬ÔÚ´´½¨Ò»¸ö£¬²¢Á¬½Óµ½Ð´´½¨µÄ
ÎÊÌâÃèÊöÇå³þЩ£¬±ðÈ˺ðïÄã¡£¡£¡£¡£
Á¬½Óµ½Ðµģ¿
еÄʲô¶«Î÷ѽ£¿
ÄãÔÙÍùÏîÄ¿Àï±ßÌí¼ÓÒ»¸öaspxµÄÒ³Ãæ£¬È»ºó´´½¨Ò»¸öhyperLink¿Ø¼þ
<asp:HyperLink NavigateUrl = "NewPage.aspx" runat="server" ID="Link1" Te ......