MyEclipseÖÐÅäÖÃSQLServer 2005Êý¾Ý¿â
1.°²×°ºÃSQLServer 2005Êý¾Ý¿âÈí¼þ£¬½Ó×Å×îÖØÒªµÄ¾ÍÊǰ²×°Êý¾Ý¿âÇý¶¯SQL Server 2005 driver for JDBC£¬¿ÉÒÔµ½:http://download.microsoft.com/download/8/B/D/8BDABAE2-B6EA-41D4-B903-7916EF3690EF/sqljdbc_1.2.2323.101_enu.exeÏÂÔØ
2.½«JDBC½âѹµ½ÈÎÒâµÄλÖã¬ÔÚ°²×°Ä¿Â¼ÀïÕÒµ½sqljdbc.jarÎļþ£¬ÒÔǰµÄÎÄÕÂÖÐÒѾ½²¹ý»·¾³±äÁ¿µÄÅäÖã¬ÕâÀïÒª¼ÓÒ»µã£¬ÔÚclasspathÀïÔÙ¼ÓÉÏsqljdbc.jarµÄ·¾¶£¬±ÈÈçC:\Program Files\Java\sqljdbc_1.2\enu\sqljdbc.jar£»
3.ÉèÖÃSQLEXPRESS·þÎñÆ÷:
a. ´ò¿ªSQL Server Configuration Manager -> SQLEXPRESSµÄÐÒé -> TCP/IP
b. ÓÒ¼üµ¥»÷Æô¶¯TCP/IP£¬Ë«»÷½øÈëÊôÐÔ,°ÑIPµØÖ·ÖеÄIP allÖеÄTCP¶Ë¿ÚÉèÖÃΪ1433£¬ÒÑÆôÓøÄΪ“ÊÇ”
c. ÖØÐÂÆô¶¯·þÎñÆ÷
ÔÚËùÑ¡ÏîÓÒ»÷£¬ÖØÐÂÆô¶¯
d. ¹Ø±ÕSQL Server Configuration Manager
4.ÔÚMyEclipseÖУ¬´°¿Ú->Ê×Ñ¡Ïî->java->installed JRE ±à¼ÒѾ°²×°ºÃµÄjdk,²éÕÒĿ¼Ìí¼Ósqljdbc.jar
5.ÓÒ¼üµ¥»÷Ŀ¼´°¿ÚÖеÄTest, Ñ¡ÔñBuild Path ->Configure Build Path..., Ìí¼ÓÀ©Õ¹j
Ïà¹ØÎĵµ£º
ÈçºÎ»ñµÃsqlserverÊý¾Ý¿âÖÐÕ¼ÓøßcpuÓû§µÄ»î¶¯ÄÚÈÝ
1¡¢´Ó΢ÈíÕ¾µãÉÏÏÂÔØqslice_setup.exe
2¡¢´ò¿ªQuery Analyzer£¬ÔËÐÐÒÔÏÂÓï¾ä£º
declare @a int
while (1<2)
begin
select @a=1
end
½«»á·¢ÏÖcpuÂíÉÏ´ïµ½100%
3¡¢´ò¿ªqlice.exe£¬½«·¢ÏÖsqlserver.exeµÄcpuÕ¼ÓÃÂʺܸߣ¬Ë«»÷½øÈ룬³öÐÐsqlserver.exeÖоßÌåÏß³ ......
1.½¨±í(Create table)ʱʹÓà IDENTITY (SEED,INCREMENT)
ÆäÖÐSEEDÊÇÆðʼֵ£¬INCREMENTÊÇÔöÁ¿¡£
Àý£º
CREATE TABLE mytable1
(
[user_id] BIGINT NOT NULL
IDENTITY(1, 1) ,
......
·ÖÒ³´æ´¢¹ý³Ì
sp_QueryPaging
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author:
-- Create date:
-- Description: ·ÖÒ³²éѯ
-- ·µ»ØµÄÊý¾ÝÖÐ×ÜÊÇÔÚÿÌõ¼Ç¼ǰ¼ÓÉÏÐкÅRowNumberÁС£
-- Èç¹ûδָ¶¨@StrSelect²ÎÊý£¬Ï൱ÓÚÉèÖÃËüΪ'*'
-- Èç¹ûδ ......
Oracle´æ´¢¹ý³Ìת³ÉSqlserver´æ´¢¹ý³Ì
1.ÈÕÆÚת»»
Oracle£º TO_NUMBER(TO_CHAR(SYSDATE, 'YYYYMMDD'))
SqlServer£ºCAST(CONVERT(CHAR(8),GETDATE(), 112) AS INT)
×¢£ºÆäÖБYYYYMMDD’¸ñʽ ¶ÔÓ¦112
2.ROWIDת»»
Oracle£º ROWID
SqlServer: PRIMARY KEY(±íÖ÷¼ü)
3.ROWNUM ......