ÆƽâSQL Prompt 3.9µÄ¼¸²½²Ù×÷
¹ØÓÚSQL Prompt
µÄÆƽâÎÄÕÂÔ°×ÓÀïÒѾÓв»ÉÙÈË·¢¹ýÁË¡£Æƽâ˼·ÎÒÒ²²»ÏëÖظ´£¬²»ÖªµÀµÄ¿ÉÒԲο¼£ºhttp://www.cnblogs.com/jintan/archive/2008/06/16/1223282.html
¹Ù·½ÏÂÔصØÖ·ÊÇ£ºhttp://downloads.red-gate.com/SQLToolbelt.exe
½ÓÏÂÀ´ÎÒ¾Í˵˵¾ßÌåÔõô×ö°É¡£ÎÒ¾Í˵˵×î¼òµ¥×îɵ¹ÏµÄ×ö·¨£¬²»ÐèÒª¶®ILÕÕÑùÆƽ⣡
×¼±¸£ºÓõ½µÄ¹¤¾ßVS2005|VS2008 ¡¢DotNet Helper ¡¢Reflector
1.½«×îаæµÄSQL Prompt 3.9ÏÂÔØÏÂÀ´°²×°ºÃ¡£ÎÒ°²×°ÔÚD:\Program Files\Red Gate\SQL Prompt
3Ŀ¼Ï¡£
2.ÓÃDotNet Helper ½«RedGate.Licensing.Client.dll·´±àÒë³ÉIL¡£DotNet
HelperȷʵºÜ·½±ã£¬ÓÃÓÚ¿ÉÊÓ»¯µÄ·´±àÒëºÍ±àÒ룬½çÃæÈçͼ£º
µã»÷“·´±àÒë”°´Å¥£¬¼´¿É½«RedGate.Licensing.Client.dll·´±àÒë³ÉIL£¬ÈçÏÂͼ£º
3.ÓÃReflector´ò¿ªRedGate.Licensing.Client.dll£¬ÕÒµ½LicenseÀàµÄDaysLeftInTrial
ÊôÐÔ£¬½«ÓïÑÔÑ¡³ÉIL£¬È»ºó²é¿´¸ÃÊôÐÔϵķ½·¨get_DaysLeftInTrial£¬Èçͼ£º
4.ÕâÀïÊÇ·µ»Ø»¹Ê£ÏµÄÊÔÓÃÌìÊý£¬Èç¹ûÎÒ½«Õâ¸öÊôÐÔµÄÂß¼¸ÄΪ·µ»Ø9999£¬ÄÇÆñ²»ÊDz»»áÊÔÓùýÆÚÁË¡£µ«ÊÇÈç¹û²»»áILÔõô°ì£¿¼òµ¥¡£Ê¹ÓÃVSн¨
Ò»¸ö¿ØÖÆ̨ӦÓóÌÐò£¬ÔÚÆäÖÐÀàÏÂÃ潨ÊôÐÔ£¬¸ÃÊôÐÔ·µ»Ø9999£º
public int GetStudyzy
{
get
{
return 9999;
}
}
5.½«VSÖеÄÕâ¸ö³ÌÐò±àÒëºÃ¡£È»ºóʹÓÃReflector²é¿´¸Ã³ÌÐò£¬ÕÒµ½Õâ¸öÊôÐÔ£º
6.Õâ²»¾ÍÊÇÎÒÃÇÏëÒªµÄ·µ»Ø9999µÄILÁËÂð£¿ÓÃÎı¾±à¼Æ÷´ò¿ªRedGate.Licensing.Client.il£¬ËÑË÷
get_DaysLeftInTrial×Ö·û´®£¬ÕÒµ½¸Ã·½·¨µÄ¶¨Ò壬Ȼºó½«ÆäÖеÄÄÚÈÝÐÞ¸ÄΪ·µ»Ø9999µÄÕâ¸öILµÄÄÚÈÝ£º
.method public hidebysig specialname instance int32
get_DaysLeftInTrial() cil managed
{
.maxstack 1
.locals init (
[0] int32 CS$1$0000)
L_0000: nop
L_0001: ldc.i4 0x270f
L_0006: stloc.0
L_0007: br.s L_0009
L_0009: ldloc.0
L_000a: ret
} // end of method Licence::get_DaysLeftInTrial
7.±£´æILµÄÐ޸ġ£Ê¹ÓÃDotNet
Helper£¬µã»÷ÆäÖеē±àÒë”°´Å¥£¬½«»á±àÒë³öÐ޸ĺóµÄ³ÌÐò¼¯£ºRedGate.Licensing.Client_Output.dll£¬½«Õâ¸ö³Ì
Ðò¼¯Ìæ»»µôÔÀ´µÄ³ÌÐò¼¯¡£
8.È¥µôÇ¿ÃüÃû¡£
½øÈë
Ïà¹ØÎĵµ£º
ÔÎĵØÖ·£ºhttp://www.dingos.cn/index.php?topic=1688.0
OracleÓÐrownumÓÃÓÚ·ÃÎʱíÖÐÐкš£ÄÇôÔÚSQL ServerÖÐÊÇ·ñÓеÈЧµÄÄØ£¿»òÕßÔÚSQL ServerÖÐÈçºÎÊä³öÐкţ¿
-----------------------------------
ÔÚSQL ServerÖÐûÓÐÖ±½ÓµÈЧÓÚOracleµÄrownum
-----------------------------------
Ñϸñ˵À´£¬ÔÚ¹ØϵÊý¾Ý¿âÖУ ......
¶¯Ì¬sqlÓï¾ä»ù±¾Óï·¨
1 :ÆÕͨSQLÓï¾ä¿ÉÒÔÓÃExecÖ´ÐÐ
eg: Select * from tableName
Exec( ......
ORACLE³£ÓÃSQLÓÅ»¯hintÓï¾ä
http://oracle.chinaitlab.com/induction/802186.html
ÔÚSQLÓï¾äÓÅ»¯¹ý³ÌÖУ¬ÎÒÃǾ³£»áÓõ½hint,ÏÖ×ܽáÒ»ÏÂÔÚSQLÓÅ»¯¹ý³ÌÖг£¼ûOracle HINTµÄÓ÷¨£º
¡¡¡¡1. /*+ALL_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
¡¡¡¡ÀýÈç:
¡¡¡¡SELECT /*+ALL+_ROW ......
SQL Server 2008ÆóÒµ°æ. SQL Server 2008ÆóÒµ°æÊÇÒ»¸öÈ«ÃæµÄÊý¾Ý¹ÜÀíºÍÒµÎñÖÇÄÜƽ̨£¬Îª¹Ø¼üÒµÎñÓ¦ÓÃÌṩÁËÆóÒµ¼¶µÄ¿ÉÀ©Õ¹ÐÔ¡¢Êý¾Ý²Ö¿â¡¢°²È«¡¢¸ß¼¶·ÖÎöºÍ±¨±íÖ§³Ö¡£ÕâÒ»°æ±¾½«ÎªÄãÌṩ¸ü¼Ó¼á¹ÌµÄ·þÎñÆ÷ºÍÖ´Ðдó¹æÄ£ÔÚÏßÊÂÎñ´¦Àí¡£
SQL Server 2008±ê×¼°æ. SQL Server 2008±ê×¼°æÊÇÒ»¸öÍêÕûµÄÊý¾Ý¹ÜÀíºÍÒµÎñÖÇÄÜƽ̨£¬Îª²¿ ......
SQL:
using System.Data.SqlClient;
string sql = "server=.;uid=sa;pwd=;database=tablename;";
ACCESS:
using System.Data.OleDb;
string sql = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=" + HttpRuntime.AppDomainAppPath + "//App_Data//db.mdb";
HttpRuntime.AppDomainAppPath Ϊ¸ùĿ¼
......