SQL Start
sqlÔڶ෽ÃþË÷ºÍÅóÓѵİïÖúÏ£¬ÖÕÓÚ¿ÉÒÔÁ¬½Ó³É¹¦£¬Õâ¶ÔÎÒÀ´ËµÊǸöÀï³Ì±®À´µÄ£¬ÔÚ¹¤×÷µÄ¹ý³ÌÖÐÎÒ×ÜÊÇûÓлú»á¿ÉÒÔÅö´¥µ½SQL£¬µ±ÎÒ¹ÄÆðÓÂÆøÓÂÆøÏëѧϰµÄʱºòÎÒÁ¬ÔõôÓö¼²»»á£¬½øÀ´ÖÕÓÚÁ´½Ó³É¹¦£¬¿ªÐĵغÍÅóÓÑ·ÖÏíÎҵijɹû¡£
1.°²×°sql£¬Ñ§Ï°SQl£¬ÒòΪһ°ãÎÒÊÇÏëÒªÓÃÓÚVS2005ÏîÄ¿µÄ£¬ËùÒÔÒ»°ã×îºó¾ÍÏÈ°²×°VSÈí¼þ£¬ÒÔ±ã¿ÉÒÔ»¥Ïà¼æÈÝ¡£È»ºóÔÙÇ¿ÖÆÃÜÂëµÄʱºò°´ÕÕÆäÒªÇóÊäÈëÒ»¸öÃÜÂ룬Ȼºó°ÑËùÓÐÈí¼þ°²×°ÔÚ±¾»úĿ¼Àï¡£°²×°Ö®ºó´ò¿ªsql server ÀïµÄÅäÖù¤¾ß£¬°ÉËùÓж˿ڶ¼Æô¶¯£¬ºó½øÈësql server magament stdio express ÀÓÃwindowsÉí·ÝµÇ¼£¬Ð޸ݲȫÀïΪsqlÒÔ¼°windowsµÇ¼ģʽ£¬È»ºóÔٵǼÃûsaÀ°ÉÃÜÂëÏÂÃæµÄÇ¿ÖÆÃÜÂëµÄ¹´È¥µô£¬½«ÃÜÂë¸ÄΪsa£¬Õâ¸öÎÒÊÔÑé³É¹¦£¬Ö®ËùÒÔʹÓÃsa£¬¾Ý˵ÊÇ·½±ã²»ÓÃÑéÖ¤ÃÜÂë¾Í¿ÉÒԵǼ¡£
2.ÊÇ˵ÎÒÔÚopenÎÊÌâÉÏÓöµ½µÄÎÊÌ⣬¾ÍÊÇÎÒÔÚvsÏîÄ¿ÀィÁ¢ÁËÒ»¸öÊý¾Ý¿â£¬ÔÚsql magamentÀïÌí¼Óºó£¬¾ÓȻʹÓò»ÁË£¬¶à´ÎʹÓò»¿ÉÒÔ¡£×îºó·¢ÏÖÒ»¸öÎÊÌâ¾ÍÊÇÎÒ½«Êý¾Ý¿âÌí¼Ó½øÈ¥µÄʱºò±£´æµÄÃû×ÖÊÇ·¾¶+Êý¾Ý¿âÃû³Æ+ºó׺Ãû£¬²Åµ¼Öµ÷ÊÔʧ°Ü¡£Ö»ÒªÌí¼ÓÖ®ºó°ÑÊý¾Ý¿âÃû³Æ¸ÄΪÎÒÃǽ¨Á¢µÄÊý¾Ý¿âÃû³Æ¡£¼´¿É˳ÀûµÇ¼¡£
ºÇºÇ……¿ªÐÄÖС£¼ÓÓÍ£¡
Ïà¹ØÎĵµ£º
һֱûÓÐÕÒµ½Ò»Öֺõķ½·¨À´ÒýÓÃÓзµ»ØÖµµÄ´æ´¢¹ý³ÌµÄ·½·¨£¬Ê¹ÎÒÔÚÌí¼ÓÊý¾ÝÖÐ×ßÁ˲»ÉÙµÄÍä·£¬×î½ü£¬ÔÚ²éÔÄÁË´óÁ¿µÄ×ÊÁÏÖ®ºó£¬ÖÕÓÚÔÚ΢ÈíµÄÒ»¸öʵÀýÖÐÕÒµ½ÁËÒ»ÖÖÁ¼ºÃµÄ·½·¨¡£
Ê×ÏȱàдºÃÒ»Óзµ»ØÖµµÄ´æ´¢¹ý³Ì
create procedure proc_name
@para1 nchar(20), --ÊäÈë²ÎÊý
&n ......
and exists (select * from sysobjects) //ÅжÏÊÇ·ñÊÇMSSQL and exists(select * from tableName) //ÅжÏij±íÊÇ·ñ´æÔÚ..tableNameΪ±íÃû and 1=(select @@VERSION) //MSSQL°æ±¾ And 1=(select db_name()) //µ±Ç°Êý¾Ý¿âÃû and 1=(select @@servername) //±¾µØ·þÎñÃû and 1=(select IS_SRVROLEMEMBER('sysadmin')) ......
table
Num createDate
---------------------------------
(¿Õ) 20090901
(¿Õ) 20090901
  ......
²Ù×÷·ûÓÅ»¯
IN ²Ù×÷·û
ÓÃINд³öÀ´µÄSQLµÄÓŵãÊDZȽÏÈÝÒ×д¼°ÇåÎúÒ׶®£¬Õâ±È½ÏÊʺÏÏÖ´úÈí¼þ¿ª·¢µÄ·ç¸ñ¡£
µ«ÊÇÓÃINµÄSQLÐÔÄÜ×ÜÊDZȽϵ͵ģ¬´ÓORACLEÖ´ÐеIJ½ÖèÀ´·ÖÎöÓÃINµÄSQLÓë²»ÓÃINµÄSQLÓÐÒÔÏÂÇø±ð£º
ORACLEÊÔͼ½«Æäת»»³É¶à¸ö±íµÄÁ¬½Ó£¬Èç¹ûת»»²»³É¹¦ÔòÏÈÖ´ÐÐINÀïÃæµÄ×Ó²éѯ£¬ÔÙ²éѯÍâ²ãµÄ±í¼Ç¼£¬Èç¹ûת»»³ ......