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

SqlServerÖвéѯ10µ½20ÌõÖ®¼äµÄÊý¾Ý

 ²éѯnorthwindÊý¾Ý¿âÖÐordersÖеÄ10µ½20Ìõ¼Ç¼
select   top   10   *   from   orders
 where   orderid > ( select  max(orderid)  from  (select top 10 orderid  from  orders order by orderid) as t  )
orders±íÖÐÒÑÓÐ×ÔÔö³¤µÄ±êʶÁÐorderid,
ÏȲé³ö±íÖÐǰʮÌõ¼Ç¼ÖеÄ×î´óorderid£¬
10ÌõÒÔºóµÄorderid¿Ï¶¨´óÓÚǰʮÌõµÄ×î´óid£¬ËùÒÔÔÙwhereÅжϼ´¿É¡£
ÁíÍ⣬Èç¹ûÒª²éѯµÄ±íûÓбêʶÁУ¬Ò²¿ÉÒÔʹÓÃÏÂÃæÕâÖÖ·½·¨£º
select   top 20 identity(int ,1,1) as id *   into  #temp  from  table
select  *  from   #temp  where  id>10


Ïà¹ØÎĵµ£º

javaÁ¬½ÓSqlServer2005£¨netbeans£©

»¨ÁË´ó°ëÌìµÄʱ¼äÖÕÓÚ½â¾öÁËÎÊÌ⣬ÏÂÃæ·ÖÏíÒ»ÏÂÎҵĹý³Ì£º
ÎÒµÄϵͳ°²×°µÄÊÇjdk6,netbeansºÍMycrosoft SqlServer 2005£¬javaÁ¬½ÓÊý¾Ý¿âÒ»°ãÒª·ÖÁù²¿×ß
1.×¢²áÇý¶¯
2.ÓÃÇý¶¯¹ÜÀíÀà´´½¨Á¬½Ó
3.´´½¨Óï¾ästatement·â×°sql½Å±¾Óï¾ä
4.Ö´ÐÐ
5.´¦Àí·µ»ØµÄ½á¹û
6.¹Ø±ÕÏà¹ØÁ¬½Ó
ÔÚÕâÀïÁ¬½ÓµÄÊÇSqlServer2005£¬ÊôÓÚµÚÈý·½Çý¶¯ ......

ÔÚwindows 7 ÉÏΪ sqlserver 2008 ÆôÓÃÔ¶³Ì·ÃÎÊ

 ÔÚwindows 7 ÉÏΪ sqlserver 2008 ÆôÓÃÔ¶³Ì·ÃÎÊ£¬ÐèÒªÁ½¸öÖØµãµÄ²½Öè¡£
µÚÒ»²½£ºÆôÓÃsqlserver 2008Ô¶³Ì·ÃÎʵŦÄÜ¡£
´ò¿ªMicrosoft SQL Server 2008-ÅäÖù¤¾ß-SQL Server ÅäÖùÜÀíÆ÷
ÆôÓò¢¼¤»îTcp/IP
È»ºóÖØÆôsqlserver·þÎñ¡£ÕâÑùsqlserver 2008¾Í¿ÉÒÔ½øÐÐÔ¶³ÌÁ¬½ÓÁË¡£µ«ÊÇwin7 ·À»ðǽĬÈÏÊÇ×èÖ¹ÁËsqlsever ¿ª· ......

Óû§"sa "µÇ½ʧ°Ü SQLServer ´íÎó18456

 ÓÃwindowsÕ˺ݹÊÇ¿ÉÒԵǼµÄ¡£
²éÕÒÎÊÌâµÄ¹ý³Ì£º
µÚÒ»²½£º Æô¶¯ËùÓÐÓëSQLÓйصķþÎñ£¬ÎÊÌâÒÀ¾É£»
µÚ¶þ²½£º ²é¿´windows·À»ðǽ£¬±»Ä¬ÈÏÆô¶¯ÁË£¬²»Æô¶¯Ñ¡ÔñÏî±»Disabled¡£Á½¸öÌáʾ“ÓÉÓÚ°²È«¿¼ÂÇ,ijЩÉèÖÃÓÉ×é²ßÂÔ¿ØÖÆ”“Windows·À»ðǽÕýÔÚʹÓÃÄúµÄÓòÉèÖÔ£¬ÏÈÓÃgpedit.msc´ò×é²ßÂԱ༭Æ÷£¬» ......

SqlServer ´óÐÍÊý¾Ý´¦ÀíÓëÓÅ»¯

Ò»¡¢Êý¾Ý¿â½á¹¹µÄÉè¼Æ
    Èç¹û²»ÄÜÉè¼ÆÒ»¸öºÏÀíµÄÊý¾Ý¿âÄ£ÐÍ£¬²»½ö»áÔö¼Ó¿Í»§¶ËºÍ·þÎñÆ÷¶Î³ÌÐòµÄ±à³ÌºÍά»¤µÄÄѶȣ¬¶øÇÒ½«»áÓ°Ïìϵͳʵ¼ÊÔËÐеÄÐÔÄÜ¡£ËùÒÔ£¬ÔÚÒ»¸öϵͳ¿ªÊ¼ÊµÊ©Ö®Ç°£¬Í걸µÄÊý¾Ý¿âÄ£Ð͵ÄÉè¼ÆÊDZØÐëµÄ¡£
    ÔÚÒ»¸öϵͳ·ÖÎö¡¢Éè¼Æ½×¶Î£¬ÒòΪÊý¾ÝÁ¿½ÏС£¬¸ººÉ½ÏµÍ¡£ÎÒÃÇÍùÍù ......

C#¶ÁÈ¡sqlserver ¶¯»­flash swf Îļþµ½±¾µØÓ²ÅÌ

 using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlC ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ