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

SQLÓïÑÔ»ù´¡£¨Ò»£©


SQL*PLUSµÄʹÓÃ
1¡¢Í˳öSQL*PLUS
   EXIT£ºÖÕÖ¹SQL*PLUS£¬²¢½«¿ØÖÆȨ½»»¹¸øOS¡£
2¡¢±à¼­ÃüÁî
1) List»òL£ºÏÔʾ»º³åÇøÖÐËùÓеÄÐС£
SQL> list
  1  select
  2  *
  3* from dept   --×¢£º*´ú±íµ±Ç°ÐС£
2) LIST*»òL*£ºÏÔʾ»º³åÇøÖеĵ±Ç°ÐС£
SQL> l*;
  3* from dept
3) LIST n»òL n£º½«Ö¸¶¨ÐÐÉèΪµ±Ç°ÐС£
SQL> list 2;
  2* *
4) LIST m n£ºÏÔʾָ¶¨·¶Î§ÄÚµÄÐС£
SQL> l 2 3
  2  *
  3* from dept
5) Append£º½«Ö¸¶¨µÄÎı¾Ôö¼Óµ½»º³åÇøÄÚµ±Ç°ÐÐĩβ¡£
SQL> append * from dept;
  1* select* from dept
SQL> list 1
  1* select* from dept
6) /£ºÖ´Ðлº³åÇøÄÚµÄSQLÃüÁî»òPL/SQLÃüÁî¡£
7) RUN£ºÏÔʾ²¢Ö´Ðлº³åÇøÄÚµÄSQLÃüÁî»òPL/SQLÃüÁî¡£
8) DELETE»òDEL£ºÉ¾³ý»º³åÇøÄڵĵ±Ç°ÐС£
9) Change£ºÐ޸Ļº³åÇøÄÚµ±Ç°ÐеÄÎı¾¡££¿
10) CLEAR SCREEN£ºÇå³ýÆÁÄ»¡£
11) CONNECT username/password£ºÓøø¶¨µÄÓû§Ãû¡¢ÃÜÂëÁ¬½Óµ½Ö¸¶¨Óû§¡£
12) DESCRIBE»òDESC£ºÏÔʾָ¶¨±í¡¢Í¬Òé´Ê¡¢ÊÓͼµÄÁж¨Ò壬»òÕßÖ¸¶¨º¯Êý»ò¹ý³ÌµÄ˵Ã÷¡£
13) SHOW£ºÏÔʾSQL*PLUSϵͳ±äÁ¿Öµ»òµ±Ç°µÄSQL*PLUS»·¾³¡£
exp1:show user£ºÏÔʾµ±Ç°Óû§¡£
exp2:show all£ºÏÔʾSQL*PLUSϵͳ±äÁ¿Öµ¡£
14) SET LINESIZE ÕûÊý£ºÉèÖòéѯ·µ»ØµÄ¼Ç¼ÿÐеĿí¶È£¬³¬¹ýÕâ¸ö¿í¶ÈÔò½Ø¶Ï·Åµ½ÏÂÒ»ÐУ¬²»¹»Õâ¸ö¿í¶ÈÔò²¹³ä¿Õ¸ñ¡£
15) SET PAGESIZE ÕûÊý£ºÖ¸¶¨¶àÉÙÐÐÏÔʾһ´ÎÁÐÍ·£¬Èç¹ûÖ¸¶¨0Ôò²»ÏÔʾÁÐÍ·¡£
16) @(Start)£ºÔËÐÐÖ¸¶¨µÄÃüÁîÎļþ£¨.txt£¬.sql£©Èç@a¡¢@ d:\a.txt¡¢@ d:\a.sq;
17) SAVE£ºÓ÷¨£º SAVE ÎļþĿ¼\ÎļþÃû(txt¡¢sql)
ORACLE³£ÓÃÊý¾ÝÀàÐÍ
1¡¢×Ö·ûÊý¾ÝÀàÐÍ
1) CHAR(n)£º¶¨³¤×Ö·û´®£¬n×Ö½Ú³¤£¬nµÄÈ¡Öµ·¶Î§Îª1~2000×Ö½Ú£¬Ä¬ÈÏֵΪ1×Ö½Ú¡£³¤¶È²»×ãnʱ£¬ÓÿոñÌî³ä¡£
2) VARCHAR2(n)£º±ä³¤×Ö·û´®£¬n×Ö½Ú³¤£¬nµÄÈ¡Öµ·¶Î§Îª1~4000×Ö½Ú£¬×Ô¶¯µ


Ïà¹ØÎĵµ£º

Sql Server¸ù¾Ý¼Ç¼¼¯ÅúÁ¿¸üÐÂÊý¾Ý¿â

update   t1   set   t1.value=t2.value   from   t2   where   t1.id=t2.id
 
update jbsite_class  set topicnum = count
from (select t2.classid,count from (
select distinct classid,count(*) as count
from jbsite_product ......

Åú´¦Àí°²×°SQL SERVER ½Å±¾Îļþ

createdb.batÎļþ
@echo off
echo ╬¡¡╱◥███◣╬╬╬╬╬╬╬╬╬╬╬╬╬╬╬╬╬
echo ╬ ︱Ìï︱Ìï Ìï ︱¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ ......

ÓÃSQLÓï¾äÐÞ¸ÄSQL±í½á¹¹

×î½üÐÞ¸ÄÊý¾Ý¿âÒѾ­´æÔڵıí½á¹¹£¬·¢ÏÖÓÃSQLÓï¾äÄܺܺõÄÐ޸ıíµÄ½á¹¹¡£SQLÊý¾Ý¿â¼Ç¼Êý·Ç³£ÅÓ´ó£¬Èç¹ûÏëÐ޸ıíµÄ×Ö¶ÎÀàÐÍ£¬Ê¹ÓÃÆóÒµ¹ÜÀíÆ÷À´¸ü¸Ä×Ö¶ÎÀàÐÍ£¬ºÜ¶àʱºò»á³¬Ê±£¬¸ü¸Ä²»³É¹¦£¬Õâ¸öʱºò£¬¿ÉÒÔÓÃSQLÓï¾äÀ´¸ü¸Ä£¬ÒÔÏÂΪÏàÓ¦µÄ´úÂëʵÀý£º
1.¸ü¸Ä×Ö¶ÎÀàÐͳ¤¶È
alert table ±í alert column ×Ö¶ÎÃû ÀàÐ͵ij¤¶È
eg: ......

Windows Mobile6 Vs2008 Sql Ce3.5 ǶÈëʽӦÓÿª·¢

¿ª·¢»·¾³£º
windows2003£¬°²×°ÁËvs2008¡¢SQL Server2005£¬ÕâÊÇ»ù´¡£¨µ±È»ÓÃvs2003£¬vs2005£¬SQL Server2000ɶµÄÒ²¿ÉÒÔ£¬²»¹ýеÄ×ÜÊǹ¦ÄÜÇ¿´óЩô£¬ºÇºÇ£©£»
ÒòΪ¿ª·¢Ê±¾ø´ó²¿·Öʱ¼äÊÇÔÚÄ£ÄâÆ÷Éϵ÷ÊÔ£¬¶ø²»ÊÇPPC£¬ËùÒÔÄ£ÄâÆ÷ÊDZØÐë°²×°µÄ¡£Õë¶ÔÄãµÄPPC²Ù×÷ϵͳѡÔñ¶ÔÓ¦µÄÄ£ÄâÆ÷Óësdk°ü£¬ÎÒ°²×°µÄÊÇWM6ÖÐÎÄ°æµÄ¡££¨windows ......

½«Êý¾Ý¿â±íÖеÄÊý¾ÝתΪsqlÖеÄinsertÓï¾ä

 set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
--½«±íÊý¾ÝÉú³ÉSQL½Å±¾µÄ´æ´¢¹ý³Ì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ