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

ÇósqlÓï¾ä

PHP code:
½«Êý¾Ý¿âÖеÄproc¶¼Ö´ÐÐÒ»±é

²»»áÊÇ EXEC sp_MSforeachtable£¿¿Ï¶¨²»ÊÇÀ²£¬ÊÇÊ²Ã´ÄØ£¿

這個²»Ì«現實°É,ÓеÄÓÐ參數ÓеÄ沒ÓÐÔõ麼辦?
Èç¹ûËùÓдæ儲過³Ì¶¼²»帶參數,¿ÉÒÔ邊厲ËùÓдæ儲過³Ì
È»áá執ÐÐ



ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²áCSDN!




Ïà¹ØÎÊ´ð£º

pl/sqlµ¼ÈëÊý¾ÝÎÊÌâ

ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç  "2009-01","8949-232"

½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......

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);
ÎÒÔÚ²åÈëµÚ¶ ......

sqlÓï¾ä

create table jskb(
񅧏 int identity(1,1) primary key not null,
ÐÕÃû varchar(20) not null,
ÐÔ±ð char(1) not null ,
ÊÚ¿ÎÃû varchar(10) not null,
½ÌÊҺŠint(10)
)

´íÄÄÄØ£¿
cre ......

Ò»ÌõsqlÓï¾ä

# Student(S#,Sname,Sage,Ssex) ѧÉú±í   
# Course(C#,Cname,T#) ¿Î³Ì±í   
# SC(S#,C#,score) ³É¼¨±í   
# Teacher(T#,Tname) ½Ìʦ±í   
ÇóÒ»sql:
°Ñ ......

sqlÎÊÌâ

´ó¼ÒºÃsqlÓï¾äÖеļÈÓÖÎÊÌâÔõô´¦Àí°¡£¬±ÈÈç²éѯ¼ÈÑ¡ÔñÁËÊý¾Ý¿âÓÖÑ¡ÔñÁ˲Ù×÷ϵͳµÄѧÉúÐÕÃû
ÊÇ·Ö±ð²éѯȻºóºÏ²¢Âð£¿


End_rbody_60302787//-->
¸Ã»Ø¸´ÓÚ2009-10-10 11:14:51±»°æÖ÷ɾ³ý


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