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

ÇósqlÓï¾ä

SQL code:
exec sp_decrypt1 'EL_SP_AdminComment' ÎÒÏ뽫ִÐеĽá¹û´æÔÚÒ»¸ö±äÁ¿ÖÐ

==


ÒýÓÃ
SQL codeexec sp_decrypt1'EL_SP_AdminComment'  ÎÒÏ뽫ִÐеĽá¹û´æÔÚÒ»¸ö±äÁ¿ÖÐ

·ÅÒ»¸ö±íÖкÃЩ°É?

--2005Ö§³Ö±í變Á¿ 2000ÓÃ臨時±í»ò實體±í


ÒýÓÃ
SQL codecreatetable tb(col1int ,.....)insert tbexec sp_decrypt1'EL_SP_AdminComment'

Õâ¸öÕý½â

ºÃ


Ïà¹ØÎÊ´ð£º

ÈçºÎÓÃc#£¬sql2000 ¿ª·¢c/sÏµĹ¤×÷Á÷£¿

±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......

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

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

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

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

Ò»ÌõsqlÓï¾ä

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

ÇósqlÓï¾ä

ɾ³ýnorthwindËùÓбíÖÐËùÓеÄÊý¾Ý
SQL code:
--ɾ³ýµ±Ç°Êý¾Ý¿âËùÓбíÖеÄÊý¾Ý
sp_MSforeachtable 'Delete from ?'
sp_MSforeachtable @command1="Delete from ? "
sp_MSforeachtable 'Truncate Ta ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ