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

SybaseµÄSQL Anywhere for BlackBerry

UltraLite®J£ºBlackBerryÉÏÔËÐеÄСÊý¾Ý¿âºÍͬ²½ÒýÇæ
MobiLink £ºÔËÐÐÔÚ·þÎñÆ÷ÉÏÊý¾Ý¿âͬ²½·þÎñÆ÷£¬¿ÉÒÔ°ÑÉ豸ÉϵÄÊý¾Ýͬ²½µ½ºǫ́µÄ¡£°üº¬ÔÚSQL Anywhere 11ÀïÃæ¡£
SQL Anywhere ÊÇÒµÄÚÁìÏȵÄÒÆ¶¯ºÍǶÈëʽÊý¾Ý¿â£¬ÌṩÊý¾Ý¹ÜÀíºÍ½»»»¼¼Êõ£¬ÎªÒ»Ïß»·¾³ÖеÄÓ¦ÓóÌÐòÌṩ֧³Ö¡£
SQL Anywhere רΪ²»¾ß±¸ÏÖ³¡ IT Ö§³Ö¡¢ÔÚÒ»Ïß»·¾³ÖÐÔËÐС¢ÓÉÊý¾Ý¿âÇý¶¯µÄÓ¦ÓóÌÐòÌṩÊý¾Ý¹ÜÀíºÍ½»»»¼¼Êõ¡£ÔÚÒ»¸ö¿ÉÇáËÉǶÈë²¢¹ã·º²¿ÊðÔÚ·þÎñÆ÷¡¢×ÀÃæ¡¢Ô¶³Ì°ì¹«ÊÒºÍÒÆ¶¯Ó¦ÓóÌÐòÄÚµÄÊý¾Ý¿âÖУ¬Ëü¿ÉÌṩÆóÒµ¼¶µÄ¹¦ÄÜ¡£
SQL Anywhere for BlackBerryÖÐÎÄ
http://www.sybase.com.cn/products/databasemanagement/sqlanywhere/blackberry
SQL Anywhere for BlackBerryÓ¢ÎÄ
http://www.sybase.com/products/databasemanagement/sqlanywhere/blackberry
SQL AnywhereÖÐÎÄÍøÕ¾
http://www.sybase.com.cn/products/databasemanagement/sqlanywhere
ÌâÍâ»°£¬1997Äê-98Äê£¬Ôø¾­Ê¹Óùýµ±Ê±Á÷ÐеÄSybase PowerBuildºÍORACLEÊý¾Ý¿â½øÐк£¸Û¼¯×°Ïä»õÔ˹ÜÀíϵͳµÄ¿ª·¢¡£
¿ª·¢Öе¥»ú²âÊÔµÄÊý¾Ý¿â¾ÍÊÇÓÃSQL Anywhere for Windows 98¡£
´ó¸ÅÊÇ1999Äê°É£¬B/S¼Ü¹¹Á÷ÐУ¬SybaseµÄC/SÍõÅÆ¿ª·¢¹¤¾ßPowerBuildË¥ÂäÁË¡£µ«ÊÇSybaseתÐ͵ķdz£ºÃ£¬³ýÁËSybaseã«ÒâÊý¾Ý¿â(ÔÚÖйúÌú·ϵͳÓõķdz£¶à)£¬ÔÚSQL Anywhere Windows¸öÈ˰汾ÉÏÑÓÉìµ½ÒÆ¶¯É豸ÉÏ£¬¼ÓÇ¿¶ÔdeviceµÄÖ§³Ö£¬ÒýÈëdeviceºÍÖÐÑëÊý¾Ý¿âµÄͬ²½ÒýÇæ£¬SybaseÏÖÔÚ»¹ÊÇ»îµÄ»¹ÊDz»´íµØ¡£


Ïà¹ØÎĵµ£º

¡¾×ª¡¿´ø´æÔÚÁ¿´ÊNOT EXISTSµÄSQLÓï¾äÎÊÌâ

´ø´æÔÚÁ¿´ÊNOT EXISTSµÄSQLÓï¾äÎÊÌâ
ѧÉú±ístudent (snoѧºÅ snameÐÕÃû sdeptËùÔÚϵ)
¿Î³Ì±ícourse (cno¿Î³ÌºÅ cname¿Î³ÌÃû cpnoÑ¡Ð޿κŠccreditѧ·Ö)
ѧÉúÑ¡¿Î±ísc (sn0ѧºÅ cno¿Î³ÌºÅ grade³É¼¨)
¶ÔÒÔÉÏ±í½øÐвéѰѡÐÞÁËÈ«²¿¿Î³ÌµÄѧÉúÐÕÃû
ÓÉÓÚ²»£¬Ã»ÓÐÈ«³ÆÁ¿´Ê£¬¿É½«ÌâÄ¿µÄÒâ˼ת»»ÎªµÈ¼ÛµÄ´æÔÚÁ¿´ÊÐÎʽ£º²éÑ ......

C#Á¬½ÓAccessºÍSQL ServerÊý¾Ý¿â

C#Á¬½ÓÁ¬½ÓAccess
Ê×ÏÈ¿´Ò»¸öÀý×Ó´úÂëÆ¬¶Ï:
³ÌÐò´úÂë:
--------------------------------------------------------------------------------
using System.Data;
using System.Data.OleDb;
......
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"Data Source=C:\BegASPNET\Northwin ......

SQLÓï¾ä

ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
¡¡¡¡SQL·ÖÀࣺ
¡¡¡¡DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
¡¡¡¡DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
¡¡¡¡DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
¡¡¡¡Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
¡¡¡¡1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
......

ÌØÊâSQLÓï¾ä

1.²éѯÁ¬½Óµ½Ä³Êý¾Ý¿âµÄÁ¬½ÓÊý
   select   count(*)   as   Á¬½ÓÊý   from   master..sysprocesses   where   db_name(dbid)='Êý¾Ý¿âÃû' ......

¸ü¸ÄSql*plusµÄÌáʾ·û

  Õý³£µÇ½sql*plusµÄ²½ÖèÈçÏ£º
sbdatabase*orcl-/home/oracle>sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 - Production on Sun May 9 19:50:24 2010
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
SQL> conn hmsimis/test@orcl
Connected.
SQL>
¿ÉÒÔ¿´µ½Ç°ÃæµÄÌáʾ·ûÊÇSQL£¬ÏÖÔÚÏëÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ