ÔÚORACLEºÍsql serverÖмòµ¥±¸·ÝtableµÄ·½·¨
Èç¹ûtemp_t1²»´æÔÚ£¬
oracle:
create table temp_t1
as
select * from t1
sql server:
select * into temp_t1 from t1
Èç¹ûtemp_t1´æÔÚ£¬
oracle:
insert into table temp_t1
select * from t1
sql server:
insert into table temp_t1
select * from t1
Ïà¹ØÎĵµ£º
²éѯ£ºselectÓï¾ä£¬¶à±í²éѯ£¬group by ·Ö×飬having ¶Ô·Ö×éºóµÄÿһ¸ö×é½øÐйýÂË£¬order by ÅÅÐò¡£(selectÓï¾ä¶à±í²éѯÕâ¸ö×îÖØÒª)
DMLÓï¾ä£ºinsert into emp() values(),insert into emp (select * from emp2),
delete from emp where...
update emp set sal =.. where ..
rollback;»Ö¸´ ......
½ñÌìÔÚÍøÉÏÉÏ¿´¼ûһƪ“½«SQL²éѯ½á¹ûת»¯Îªpojo¶ÔÏóµÄ”²©¿Í£¬²©Ö÷×Ô¶¨Òå×öÁËÒ»¸öÀàÈçÏ£º
import java.lang.reflect.Field;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.property.ChainedPropertyAccessor;&n ......
ÕâÀï½éÉÜsql server2005ÀïÃæµÄÒ»¸öʹÓÃʵÀý£º
CREATE TABLE tb(province nvarchar(10),city nvarchar(10),score int)
INSERT tb SELECT 'ÉÂÎ÷','Î÷°²',3
UNION ALL SELECT 'ÉÂÎ÷','°²¿µ',4
UNION ALL SELECT 'ÉÂÎ÷','ººÖÐ',2
UNION ALL SELECT '¹ã¶«','¹ãÖÝ',5
UNION ALL SELECT '¹ã¶«','Ö麣',2
UNION ......
1. SQLÓÅ»¯µÄÔÔòÊÇ£º
½«Ò»´Î²Ù×÷ÐèÒª¶ÁÈ¡µÄBLOCKÊý¼õµ½×îµÍ,¼´ÔÚ×î¶ÌµÄʱ¼ä´ïµ½×î´óµÄÊý¾ÝÍÌÍÂÁ¿¡£
µ÷Õû²»Á¼SQLͨ³£¿ÉÒÔ´ÓÒÔϼ¸µãÇÐÈ룺
¼ì²é²»Á¼µÄSQL£¬¿¼ÂÇÆäд·¨ÊÇ·ñ»¹ÓпÉÓÅ»¯ÄÚÈÝ
¼ì²é×Ó²éѯ ¿¼ÂÇSQL×Ó²éѯÊÇ·ñ¿ÉÒÔÓüòµ¥Á¬½Óµ ......