Ò³Ãæ´«ÖµÑéÖ¤(·ÀSQL×¢Èë)
Global.asaxÎļþÖÐ
ÔÚÒ³ÃæÌø×ªÊ±£¬·ÀÖ¹´«ÖµµÄ²ÎÊýÖÐSQL×¢È룺
void Application_BeginRequest(object sender, EventArgs e)
{
ProcessRequest();
}
void ProcessRequest()
{
try
{
if (HttpContext.Current.Request.Form.Count > 0)
{
NameValueCollection collection = HttpContext.Current.Request.Form;
foreach (string strKeys in collection.AllKeys)
{
if (strKeys == "__VIEWSTATE")
{
continue;
}
else
{
if (!CheckRequest(collection.Get(strKeys)))
{
System.Web.HttpContext.Current.Response.End();
}
}
}
}
&nbs
Ïà¹ØÎĵµ£º
ÔÚÍøÉÏÏÂÁËÒ»¸ö°æ±¾µÄSQL2008£¬Ò»²½²½°²×°£¬°²×°¹ý³ÌÖÐÓöµ½ÁËredist.cab ºÍSql.cab´íÎ󣬵«»ù±¾¹¦ÄÜ»¹ÊÇÄÜÓ㬵«»¹ÊDz»ÄÜÈÝÈÌ´íÎóµÄ´æÔÚ£¬¾Ò»·¬ËÑË÷£¬ÖÕÓÚÕÒµ½Á˽â¾ö·½°¸£º
ÏÂÔØmsxml°²×°£¬ÎÒÒ»¿ÚÆø°²×°ÁËmsxml4.0 sp3ºÍmsxml6.0Á½¸öÎļþ
Ϊʲô°²×°Õâ¸ö¶«Î÷ÄÇ?
ÏëÆðÀ´ÁË£¬ÒòΪ°²×°Ê±±¨µÄ´íÎóÊÇÓëÍøÂçÓйØÏµ£¬¶øÎÒµÄwin ......
´¥·¢³ÌÐò£¨trigger£©ÊÇÒ»ÖÖÌØÊâÐÍ̬µÄÔ¤´æ³ÌÐò£¬µ±ÄúʹÓÃInsert¡¢Update»òDeleteÃüÁîÀ´ÐÞ¸Ä×ÊÁÏÁÐʱ£¬Microsoft SQL Server»á×Ô¶¯Ö´ÐÐÄúËù¶¨ÒåµÄ´¥·¢³ÌÐò¡£
´¥·¢³ÌÐò£¨trigger£© ÊÇÒ»ÖÖÌØÊâµÄÔ¤´æ³ÌÐò£¬Ö´ÐÐÌØ¶¨µÄ³ÂÊöʽ£¨Update¡¢Insert »ò Delete£©¾Í¿ÉÒÔ啟¶¯´¥·¢³ÌÐò¡£´¥·¢ ......
×÷Õߣº°½Ê¿Î°
Ò»ÕÅÓÐgroup byºó¿ÉÄܺܶàÖØ¸´ÐУ¬ÕâʱÓÃnot inµÈ»ùÓÚΨһÁеķֲ¼Ëã·¨»á´æÔÚÎÊÌâ¡£
ÎҵĽâ¾ö°ì·¨ÊÇ£º
Ò»ÕűíÓÐÒ»¸öid intµÄÖ÷¼ü£¬¶ÔÆäËüÁнøÐÐgroup by£¬·Öҳ˼ÏëÊÇ£º°Ñmax(id)×ögroup byºóµÄΨһÁУ¬»¹ÊÇÓÃnot inµÄ·Ö²¼Ë¼Ïë¡£
Àý£º
select top 4 sum(int_TZ2_id) as id,dt_TZ2_date,vchar_TZ2_Pin ......
Ò»¡¢Í¨¹ýÆóÒµ¹ÜÀíÆ÷½øÐе¥¸öÊý¾Ý¿â±¸·Ý¡£´ò¿ªSQL SERVER ÆóÒµ¹ÜÀíÆ÷£¬Õ¹¿ªSQL SERVER×éLOCALϵÄÊý¾Ý¿â£¬ÓÒ¼üµã»÷ÄãÒª±¸·ÝµÄÊý¾Ý¿â£¬ÔÚµ¯³öµÄ²Ëµ¥ÖÐÑ¡ÔñËùÓÐÈÎÎñϵı¸·ÝÊý¾Ý¿â£¬µ¯³ö±¸·ÝÊý¾Ý¿â¶Ô»°¿ò£º
µã»÷Ìí¼Ó°´Å¥£¬Ìîд±¸·ÝÎļþµÄ·¾¶ºÍÎļþÃû£¬µã»÷È·¶¨Ìí¼Ó±¸·ÝÎļþ£¬µã»÷±¸·Ý¶Ô»°¿òÉϵı¸·Ý£¬¿ªÊ¼½øÐб¸·Ý¡£
&nbs ......
ÔÚSQL SERVERÖУ¬Äã¿ÉÄÜÐèÒª»ñµÃµ±Ç°ÈÕÆÚºÍ¼ÆËãһЩÆäËûµÄÈÕÆÚ£¬ÀýÈ磬ÄãµÄ³ÌÐò¿ÉÄÜÐèÒªÅжÏÒ»¸öÔµĵÚÒ»Ìì»òÕß×îºóÒ»Ìì¡£ÄãÃǴ󲿷ÖÈË´ó¸Å¶¼ÖªµÀÔõÑù°ÑÈÕÆÚ½øÐзָÄê¡¢Ô¡¢Èյȣ©£¬È»ºó½ö½öÓ÷ָî³öÀ´µÄÄê¡¢Ô¡¢ÈյȷÅÔÚ¼¸¸öº¯ÊýÖмÆËã³ö×Ô¼ºËùÐèÒªµÄÈÕÆÚ£¡ÔÚÕâÆªÎÄÕÂÀÎÒ½«¸æËßÄãÈçºÎʹÓÃDATEADDºÍDATEDIFFº¯ÊýÀ´¼ÆË ......