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

¡¾SQL¡¿Ê¹ÓÃÒ»ÌõINSERTÓï¾äÍê³É¶à±í²åÈë

ÕâÊÇÒ»Ìõµß¸²³£¹æµÄ²åÈë·½·¨£¬Ò»ÌõINSERTÓï¾ä¿ÉÒÔÍê³ÉÏò¶àÕűíµÄ²åÈëÈÎÎñ¡£Ð¡Ð¡µØÕ¹Ê¾Ò»ÏÂÕâÖÖ²åÈë·½·¨¡£
1.´´½¨±íT²¢³õʼ»¯²âÊÔÊý¾Ý£¬´Ë±í×÷ΪÊý¾ÝÔ´¡£
sec@ora10g> create table t (x number(10), y varchar2(10));
sec@ora10g> insert into t values (1,'a');
sec@ora10g> insert into t values (2,'b');
sec@ora10g> insert into t values (3,'c');
sec@ora10g> insert into t values (4,'d');
sec@ora10g> insert into t values (5,'e');
sec@ora10g> insert into t values (6,'f');
sec@ora10g> commit;
2.²é¿´±íTµÄÊý¾Ý
sec@ora10g> select * from t;
         X Y
---------- ----------
         1 a
         2 b
         3 c
         4 d
         5 e
         6 f
6 rows selected.
3.´´½¨±íT1ºÍT2£¬×÷ΪÎÒÃÇÒª²åÈëµÄÄ¿±ê±í¡£
sec@ora10g> create table t1 as select * from t where 0=1;
Table created.
sec@ora10g> create table t2 as select * from t where 0=1;
Table created.
4.µÚÒ»ÖÖ¶à±í²åÈë·½·¨INSERT ALL
1£©Íê³ÉINSERT ALL²åÈë
sec@ora10g> insert all into t1 into t2 select * from t;
12 rows created.
ÕâÀïÖ®ËùÒÔÏÔʾ²åÈëÁË12ÌõÊý¾Ý£¬Êµ¼ÊÉϱíʾÔÚT1±íÖвåÈëÁË6Ìõ£¬T2±í²åÈëÁË6Ìõ£¬Ò»¹²ÊÇ12ÌõÊý¾Ý¡£
2£©ÑéÖ¤T1±íÖб»²åÈëµÄÊý¾Ý¡£
sec@ora10g> select * from t1;
         X Y
---------- ----------
         1 a
         2 b
         3 c
         4 d
         5 e
         6 f
6 rows selected.
3£©ÑéÖ¤T2±íÖб»²åÈëµÄÊý¾Ý¡£
sec@ora10g> select * from t2;
         X Y
-


Ïà¹ØÎĵµ£º

SQL ͬʱ¿´µ½Ã÷ϸºÍºÏ¼Æ

SELECT  ¡¡ ¡¡ ¡¡
CenterCD ¡¡ ¡¡ ¡¡
,UseUnitCD ¡¡ ¡¡
,SUM(UseUnitUnitPrice) 'totaladvance'
, GROUPING(UseUnitCD) 'grp' ¡¡
from dbo.T_MMaterialGroupUnitPrice_SLS
GROUP BY CenterCD,UseUnitCD
WITH ROLLUP ¡¡ ¡¡
¡¡ ¡¡ ¡¡ ¡¡
¡¡ ¡¡ ¡¡ ¡¡
SELECT  ¡¡ ¡¡ ¡¡
CenterCD ¡¡ ¡¡ ¡¡
, ......

sql ×Ö·û´®´¦Àíº¯Êý

¡¾×ª¡¿Ò»Ð©³£ÓõÄsqlÓï¾ä×Ö·û´®´¦Àí£¬×ªÓÚÕâÀÒÔ·½±ãʹÓÃ
Ò»¡¢×Ö·ûת»»º¯Êý
1¡¢ASCII()
·µ»Ø×Ö·û±í´ïʽ×î×ó¶Ë×Ö·ûµÄASCII ÂëÖµ¡£ÔÚASCII£¨£©º¯ÊýÖУ¬´¿Êý×ÖµÄ×Ö·û´®¿É²»ÓÑ’À¨ÆðÀ´£¬µ«º¬ÆäËü×Ö·ûµÄ×Ö·û´®±ØÐëÓÑ’À¨ÆðÀ´Ê¹Ó㬷ñÔò»á³ö´í¡£
2¡¢CHAR()
½«ASCII Âëת»»Îª×Ö·û¡£Èç¹ûûÓÐÊäÈë0 ~ ......

HibernateÓëSQLµÄÑ¡Ôñ

HibernateÊÇÒ»¿îÓÅÐãµÄORM¹¤¾ß¡£µ«ÊÇÔÚijЩÇé¿öÏÂÄÑÃâ»á¸øÎÒÃǵÄÏîÄ¿´øÀ´Ò»¶¨µÄ¸´ÔÓÐÔ¡£¾ÍËãʹÓÃspring×öÒ»¶¨µÄÊÂÎñ¼ò»¯£¬¸Ä±äµÄÒ²½ö½öÊDZàдµÄʱºò¸ü¼ÓµÄ¼òµ¥¶øÒÑ¡£ÌرðÊÇÔÚ´¦Àí²éѯµÄʱºò£¬hibernateºÍsql±È½ÏÆðÀ´£¬¾ÍËÆºõûÓÐÄÇô´óµÄÓÅÊÆÁË¡£ËùÒÔÔںܶàµÄÏîÄ¿ÀïÃæÔÚʹÓÃhibernateºÍspringµÄͬʱ»¹»áʹÓÃibatisµÄsqlmap¡ ......

SQL datepart º¯ÊýµÄÓÃ

·µ»Ø´ú±íÖ¸¶¨ÈÕÆÚµÄÖ¸¶¨ÈÕÆÚ²¿·ÖµÄÕûÊý¡£
Óï·¨
DATEPART ( datepart ,date )
²ÎÊý
datepart
ÊÇÖ¸¶¨Ó¦·µ»ØµÄÈÕÆÚ²¿·ÖµÄ²ÎÊý¡£Ï±íÁгöÁË Microsoft® SQL Server™ ʶ±ðµÄÈÕÆÚ²¿·ÖºÍËõд¡£
ÈÕÆÚ²¿·ÖËõд
year
yy, yyyy
quarter
qq, q
month
mm, m
dayofyear
dy, y
day
dd, d
week
wk, ww
weekda ......

SQL SERVER index

×î½üÓÉÓÚϵͳµÄÐèÇó£¬ËùÒÔÒªÁ˽âÒ»ÏÂÈçºÎÓÅ»¯sql server£¬ÏÂÃæÊÇÎÒµÄһЩ×ܽᣬ²»×ãµÄµØ·½Ï£Íû´ó¼ÒÅúÆÀÖ¸Õý¡£ËµÒªÓÅ»¯´ó¼ÒÒ»¶¨»áÏëµ½Ë÷Òý£¬ÄÇÎÒÃǾʹÓË÷Òý¿ªÊ¼°É¡£ ΢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý(clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý)ºÍ·Ç¾Û¼¯Ë÷Òý(nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý)£¬ÏÂÃæ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ