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

SQL Server 2008ÏÂÔØ&ÆÆ½â

´Ó¹ÙÍøÏÂÔØSQL Server 2008µÄ180ÌìÊÔÓðæÆäʵÓëÕýʽ°æÄÚÈÝÊÇ»ù±¾ÏàͬµÄ£¬Î¨Ò»µÄÇø±ð¾ÍÔÚÓÚ°²×°ÅäÖÃÎļþÖÐËù°üº¬µÄkey¡£¸÷ÖÖ°æ±¾µÄSQL ServerÔÚ½øÐе½ÕâÒ»²½Ö®Ç°¶¼ÊÇÍêȫһÑùµÄ£º
Microsoft® SQL Server® 2008 Enterprise Evaluation£º¿ª·¢ÈËÔ±ÊÔÓÃÌåÑé
Microsoft® SQL Server® 2008 Enterprise Evaluation£ºIT רҵÈËÔ±ÊÔÓÃÌåÑé  
Microsoft® SQL Server® 2008 Express
Microsoft® SQL Server® 2008 Express with Tools
Èç¹ûÄãûÓÐÐòÁкţ¬ÄÇô¾ÍÖ»ÄÜÔÚÉÏÃæµÄÈýÖÖfree edition£¨Enterprise Evaluation¡¢Express¡¢Express with Advanced Service£©ÖÐÑ¡ÔñÆäÒ»¡£Èç¹ûÔÚÏÂÃæÌîÈëÐòÁкţ¬ÄÇô¾Í»á°²×°´ËÐòÁкÅËù¶ÔÓ¦µÄSQL°æ±¾£¬ÕâÒ»µãºÍWindows Server 2008ÊÇÏàËÆµÄ¡£
Ìṩ¸ø´ó¼Ò¼¸¸ökey£¬½ö¹©Ñ§Ï°£¬Çë²»ÒªÓÃ×÷ËûÓá£
Developer: PTTFM-X467G-P7RH2-3Q6CG-4DMYB
Enterprise: JD8Y6-HQG69-P9H84-XDTPG-34MBB
Microsoft.SQL.Server.2008.Developer.Edition
PTTFM-X467G-P7RH2-3Q6CG-4DMYB
Microsoft.SQL.Server.2008.Enterprise.Edition
JD8Y6-HQG69-P9H84-XDTPG-34MBB
Microsoft.SQL.Server.2008.Standard.Edition
FXHQY-JQF42-68VVV-PYVVR-RY3BB
Microsoft.SQL.Server.2008.Standard.Edition.for.Small.Business W72H7-DQQGJ-2QXP3-898V4-9QP3Y
Microsoft.SQL.Server.2008.Web.Edition
T4CTV-PVXVP-JH7GV-FB8DV-YMH3Y
Microsoft.SQL.Server.2008.Workgroup.Edition
QGRPG-DPHXX-Q69PJ-BBG4T-CMBYB
SQL Server 2008 Enterprise:
MQWT2-9MKBY-K8PXQ-6K4BW-TY4BD.
SQL Server 2008 Standard:
XP4FP-3VTDK-37TWH-TW77J-9MFM3.
Õýʽ°æºÍʹÓðæµÄÇø±ð
ÔÚ°²×°³ÌÐòDVDÖУ¬Ä¬ÈÏ»áÌṩµÄÐòÁкÅÊÇÓÉDefaultSetup.iniµÄÄÚÈÝÀ´¾ö¶¨µÄ£º
ÊÔÓðæÊÇûÓÐÕâ¸öÎļþ£¬ Õýʽ°æÕâ¸öÎļþλÓÚx86\SetupϵÄconfig.xmlÎļþÀïÏ£¬Èç¹ûÄãµÄ»úÆ÷ÊÇ64λµÄ£¬ÔòλÓÚÔÚ\x64\SetupÓÐÒ»¸öconfig.xmlÀïÃæÓÐÒ»¾ä<!-- <PIDKEY Value="BCDFGHJKMPQRTVWXY2346789B" /> -->£¬½«ÆäÖеÄ×Ö·û´®Ìæ»»¼´¿ÉÏÂÒýÓÃÆäÄÚÈÝÈçÏ£ºÒýÓÃ:
;SQLSERVER2008 Configuration File
[SQLSERVER2008]
PID="***XX-***XX-***XX-***XX-***XX"
PID="***XX-***XX-***XX-***XX-***XX"Ö»ÒªÎÒÃǽ«×Ô¼ºÓµÓеÄÐòÁкÅÌæ»»PID=ºóÃæµÄÄÇÒ»´®£¬ÔòÔÚ°²×°¹ý³ÌÖУ¬½øÐе½Ç°ÃæÌáµ½µÄÊäÈëkeyÒ»²½Ê±£¬»á×Ô¶¯ÎªÄãÌîÈëÕâÀïµÄÐòÁкš£Î¢Èí¹Ù·½µÄ


Ïà¹ØÎĵµ£º

Ô¶³ÌÁ¬½Ósql server 2000·þÎñÆ÷µÄ½â¾ö·½°¸

Ô¶³ÌÁ¬½Ósql server 2000·þÎñÆ÷µÄ½â¾ö·½°¸
                                        ----ת×Ô£º·ÉºüСÎÝ
ÓÉÓ ......

ÍòÄܵķÖÒ³sql(ת)

CREATE proc page
@RecordCount int output,
@QueryStr nvarchar(100)='table1',--±íÃû¡¢ÊÓͼÃû¡¢²éѯÓï¾ä
@PageSize int=20, --ÿҳµÄ´óС(ÐÐÊý)
@PageCurrent int=2, --ÒªÏÔʾµÄÒ³ ´Ó0¿ªÊ¼
@FdShow nvarchar (1000)='*', --ÒªÏÔʾµÄ×Ö¶ÎÁбí
@IdentityStr nvarchar (100)='id', --Ö÷¼ü
@WhereStr nvarchar ......

JSPʵÏÖ¼òÒ×µÄSQL±¨±í

ÊäÈë: select ID as ±àºÅ, NAME as ÐÕÃû, AGE as ÄêÁä from XXX
Êä³ö:
񅧏
ÐÕÃû
ÄêÁä
 
 
 
ÒªÇóÊÇÈç¹ûSQL±ä¶¯, ÈÔȻҪÏÔʾ³öÀ´ËùÓеıðÃû×Ö¶ÎÐÅÏ¢ºÍÊý¾Ý.
ÒòΪÏÖÔÚHibernateÓõıȽϹ㷺, ËùÒÔÓÅÏÈ¿¼ÂÇÓÃHibernateÀ´ÊµÏÖ, ½á¹û·¢ÏÖÈç¹ûÊÇʵÌåÓ³Éä²éѯÓï¾ä, ¿ÉÒÔ·½±ãµÄÓÃ:List<String> Quer ......

sql·Ö頁

Ó¦Ò»¸öÅóÓѵÄÒªÇó£¬ÌùÉÏÊղصÄSQL³£Ó÷ÖÒ³µÄ°ì·¨¡«¡«
±íÖÐÖ÷¼ü±ØÐëΪ±êʶÁУ¬[ID] int IDENTITY (1,1)
1.·ÖÒ³·½°¸Ò»£º(ÀûÓÃNot InºÍSELECT TOP·ÖÒ³)
Óï¾äÐÎʽ£º 
SELECT TOP Ò³¼Ç¼ÊýÁ¿ *
from ±íÃû
WHERE (ID NOT IN
  (SELECT TOP (ÿҳÐÐÊý*(Ò³Êý-1)) ID
  from ±íÃû
  ORDER BY ......

Oracle:PL/SQL ÖÐÈçºÎʹÓÃArray

http://tech.163.com/05/0701/10/1NIODMQS00091589.html
ÒòΪÔÚPL/SQL Öв¢Ã»ÓÐÊý×é.
ÕâÊÇż²é×ÊÁÏÕҵķ¶ÀýºÍ×Ô¼ºÐ´µÄ·¶ÀýÀ´½âÊÍÈçºÎÔÚPL/SQL ÖÐʹÓÃÊý×é. Ò²ÐíºÜ¶àÈËÒÑÖªµÀ, ²»¹ý¾ÍÊÇÈò»ÖªµÀµÄÅóÓÑÃÇÁ˽âһϰɡ£
----------------------
µ¥Î¬Êý×é
------------------------
DECLARE
TYPE
emp_ssn_array IS TA ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ