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

javaÁ´½Ósql server

Ô­Ìû¼°ÌÖÂÛ£ºhttp://bbs.bc-cn.net/dispbbs.asp?boardid=12&id=140292
*   ×î½üÒòΪ¿ª·¢»î¶¯ÐèÒª,ÓÃÉÏÁËEclipse,²¢ÒªÇóʹÓþ«¼ò°æµÄSQLÊý¾Ý¿â(¼´SQL   Server   2005)À´½øÐпª·¢ÏîÄ¿   *
1.×¼±¸¹¤×÷:   ×¼±¸Ïà¹ØµÄÈí¼þ(Eclipse³ýÍâ,¿ªÔ´Èí¼þ¿ÉÒÔ´Ó¹ÙÍøÏÂÔØ)
<1> .Microsoft   SQL   Server   2005   Express   Edition
ÏÂÔØµØÖ·:http://download.microsoft.com/download/0/9/0/09020fab-d2c3-4a8c-b9e0-db53a7a30ae8/SQLEXPR_CHS.EXE
<2> .SQL   Server   Management   Studio
ÏÂÔØµØÖ·:http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796#filelist
<3> .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.¶¼ÏÂÔØÍêÖ®ºó¿ªÊ¼½øÐа²×°   ,ǰÁ½¸öÊÇÊôÓÚÊý¾Ý¿âÈí¼þ,Õý³£°²×°¼´¿É(×¢ÒâÊý¾Ý¿âµÇ½²»ÒªÊ¹ÓÃwindowsÑéÖ¤)
<1>   ½«JDBC½âѹËõµ½ÈÎÒâλÖÃ,±ÈÈç½âѹµ½CÅÌprogram   filesÏÂÃæ,²¢ÔÚ°²×°Ä¿Â¼ÀïÕÒµ½sqljdbc.jarÎļþ,µÃµ½Æä·¾¶¿ªÊ¼ÅäÖû·¾³±äÁ¿
ÔÚ»·¾³±äÁ¿classpath   ºóÃæ×·¼Ó   C:\Program   Files\Microsoft   SQL   Server2005   JDBC   Driver\sqljdbc_1.2\enu\sqljdbc.jar
<2>   ÉèÖÃSQLEXPRESS·þÎñÆ÷:
        a.´ò¿ªSQL   Server   Configuration   Manager   ->   SQLEXPRESSµÄЭÒé   ->   TCP/IP  
        b.ÓÒ¼üµ¥»÷Æô¶¯TCP/IP  
        c.Ë«»÷½øÈëÊôÐÔ,°ÑIPµØÖ·ÖеÄIP   allÖеÄTCP¶Ë¿ÚÉèÖÃΪ1433
        d.ÖØÐÂÆô¶¯SQL   Server   2005·þÎñÖеÄSQLEXPRESS·þÎñÆ÷
        e.¹Ø±ÕSQL   Server   Configuration   Manager
<3>   ´ò¿ª¸Õ¸Õ°²×°ºÃµÄ   SQL   Server   Management   Studio,Á¬½ÓSQLEXPRESS·þÎñÆ÷,   н¨Êý¾Ý¿â,ÆðÃû×ÖΪsample  
<4>   ´ò¿ªEcl


Ïà¹ØÎĵµ£º

sql ³£ÓÃ

¹«Ë¾×éÖ¯SQLˮƽ¿¼ÊÔ£¬¿´ÁËд½Ì²Ä£¬Ð´Á˵ã×ܽᷢÉÏÀ´¸ú´ó¼Ò·ÖÏí¡£
ÎÒ¹«Ë¾Ê¹ÓõÄÊÇSybase ASE12.5£¬ËùÒÔÏÂÃæµÄÒ»Ð©ÌØÐÔÊÇÕë¶ÔSybase ASEµÄ¡£
Ò»£ºSQL Bisic
1£ºSQL(Structured Quary Language)ÌØÐÔ£º
a£º±ê×¼»¯
b£º·Ç¹ý³Ì»¯µÄ
c£º¿ÉÓÅ»¯µÄ
d£ºÃæÏò¼¯ºÏ²Ù×÷µÄ
2£ºASEÖеÄÊý¾ÝÀàÐÍ
a£ºNumberic
b£ºCharacter
c£ºDat ......

ÓÃEXPLAIN PLAN ·ÖÎöSQLÓï¾ä

ÈçºÎÉú³Éexplain plan?
¡¡¡¡½â´ð:ÔËÐÐutlxplan.sql. ½¨Á¢plan ±í
¡¡¡¡Õë¶ÔÌØ¶¨SQLÓï¾ä£¬Ê¹Óà explain plan set statement_id = 'tst1' into plan_table
¡¡¡¡ÔËÐÐutlxplp.sql »ò utlxpls.sql²ì¿´explain plan
EXPLAIN PLAN ÊÇÒ»¸öºÜºÃµÄ·ÖÎöSQLÓï¾äµÄ¹¤¾ß,ËüÉõÖÁ¿ÉÒÔÔÚ²»Ö´ÐÐSQLµÄÇé¿öÏ·ÖÎöÓï¾ä. ͨ¹ý·ÖÎö,ÎÒÃǾͿÉÒÔÖ ......

SQL *PLUS RepostµÄ¿ª·¢·½·¨

SQL *PLUS  RepostµÄ¿ª·¢·½·¨
ʹÓÃSQL*PLUS ¿ÉÖ±½ÓÔÚIE BrowserÖÐÉú³É¹æÕûµÄ×Ö·ûÐÍReport. ʵÏÖ·½·¨¼òµ¥£¬²¼ÊðÈÝÒס£
·½·¨:
1.       ÀûÓÃÎı¾±à¼­Æ÷±àдSQL*PLUS  ½Å±¾£¬±£´æ³É .sql Îļþ¡£
2.       ÉÏ´«sql ÎļþÖÁÓ¦ÓõÄsql Ŀ¼¡£
3.  ......

Free BarCode128 SQL±àÂë

CREATE   FUNCTION StringToBarcode
 (@Value Varchar(50)   )
RETURNS NVarchar(100)
AS
BEGIN
 Declare @charCount int
 Declare  @charPos int, @minCharPos int
 declare @currentChar int, @checksum int
   Declare @isTableB int,@isValid int
 &n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ