ÇósqlÓï¾ä
PHP code:
½«Êý¾Ý¿âÖеÄproc¶¼Ö´ÐÐÒ»±é
²»»áÊÇ EXEC sp_MSforeachtable£¿¿Ï¶¨²»ÊÇÀ²£¬ÊÇÊ²Ã´ÄØ£¿
這個²»Ì«現實°É,ÓеÄÓÐ參數ÓеÄ沒ÓÐÔõ麼辦?
Èç¹ûËùÓдæ儲過³Ì¶¼²»帶參數,¿ÉÒÔ邊厲ËùÓдæ儲過³Ì
È»áá執ÐÐ
ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²áCSDN!
Ïà¹ØÎÊ´ð£º
ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç "2009-01","8949-232"
½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......
ÎÒÓÐÒ»Õűí 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);
ÎÒÔÚ²åÈëµÚ¶ ......
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 ......
# Student(S#,Sname,Sage,Ssex) ѧÉú±í
# Course(C#,Cname,T#) ¿Î³Ì±í
# SC(S#,C#,score) ³É¼¨±í
# Teacher(T#,Tname) ½Ìʦ±í
ÇóÒ»sql:
°Ñ ......
´ó¼ÒºÃsqlÓï¾äÖеļÈÓÖÎÊÌâÔõô´¦Àí°¡£¬±ÈÈç²éѯ¼ÈÑ¡ÔñÁËÊý¾Ý¿âÓÖÑ¡ÔñÁ˲Ù×÷ϵͳµÄѧÉúÐÕÃû
ÊÇ·Ö±ð²éѯȻºóºÏ²¢Âð£¿
End_rbody_60302787//-->
¸Ã»Ø¸´ÓÚ2009-10-10 11:14:51±»°æÖ÷ɾ³ý
¶ÔÎÒÓÐÓ ......