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

Mysql£¬SqlServer£¬OracleÖ÷¼ü×Ô¶¯Ôö³¤µÄÉèÖÃ


Mysql£¬SqlServer£¬OracleÖ÷¼ü×Ô¶¯Ôö³¤µÄÉèÖÃ
1¡¢°ÑÖ÷¼ü¶¨ÒåΪ×Ô¶¯Ôö³¤±êʶ·ûÀàÐÍ
ÔÚmysqlÖУ¬Èç¹û°Ñ±íµÄÖ÷¼üÉèΪauto_incrementÀàÐÍ£¬Êý¾Ý¿â¾Í»á×Ô¶¯ÎªÖ÷¼ü¸³Öµ¡£ÀýÈ磺
create table customers(id int auto_increment primary key not null, name varchar(15));
insert into customers(name) values("name1"),("name2");
select id from customers;
ÒÔÉÏsqlÓï¾äÏÈ´´½¨ÁËcustomers±í£¬È»ºó²åÈëÁ½Ìõ¼Ç¼£¬ÔÚ²åÈëʱ½ö½öÉ趨ÁËname×ֶεÄÖµ¡£×îºó²éѯ±íÖÐid×ֶΣ¬²éѯ½á¹ûΪ£º
id
1
2
Óɴ˿ɼû£¬Ò»µ©°ÑidÉèΪauto_incrementÀàÐÍ£¬mysqlÊý¾Ý¿â»á×Ô¶¯°´µÝÔöµÄ·½Ê½ÎªÖ÷¼ü¸³Öµ¡£
ÔÚMS SQLServerÖУ¬Èç¹û°Ñ±íµÄÖ÷¼üÉèΪidentityÀàÐÍ£¬Êý¾Ý¿â¾Í»á×Ô¶¯ÎªÖ÷¼ü¸³Öµ¡£ÀýÈ磺
create table customers(id int identity(1,1) primary key not null, name varchar(15));
insert into customers(name) values("name1"),("name2");
select id from customers;
²éѯ½á¹ûºÍmysqlµÄÒ»Ñù¡£Óɴ˿ɼû£¬Ò»µ©°ÑidÉèΪidentityÀàÐÍ£¬MS SQLServerÊý¾Ý¿â»á×Ô¶¯°´µÝÔöµÄ·½Ê½ÎªÖ÷¼ü¸³Öµ¡£identity°üº¬Á½¸ö²ÎÊý£¬µÚÒ»¸ö²ÎÊý±íʾÆðʼֵ£¬µÚ¶þ¸ö²ÎÊý±íʾÔöÁ¿¡£
2¡¢´ÓÐòÁÐÖлñÈ¡×Ô¶¯Ôö³¤µÄ±êʶ·û
ÔÚOracleÖУ¬¿ÉÒÔΪÿÕűíµÄÖ÷¼ü´´½¨Ò»¸öµ¥¶ÀµÄÐòÁУ¬È»ºó´ÓÕâ¸öÐòÁÐÖлñÈ¡×Ô¶¯Ôö¼ÓµÄ±êʶ·û£¬°ÑËü¸³Öµ¸øÖ÷¼ü¡£ÀýÈçÒ»ÏÂÓï¾ä´´½¨ÁËÒ»¸öÃûΪcustomer_id_seqµÄÐòÁУ¬Õâ¸öÐòÁÐµÄÆðʼֵΪ1£¬ÔöÁ¿Îª2¡£
create sequence customer_id_seq increment by 2 start with 1
Ò»µ©¶¨ÒåÁËcustomer_id_seqÐòÁУ¬¾Í¿ÉÒÔ·ÃÎÊÐòÁеÄcurvalºÍnextvalÊôÐÔ¡£
curval£º·µ»ØÐòÁеĵ±Ç°Öµ
nextval£ºÏÈÔö¼ÓÐòÁеÄÖµ£¬È»ºó·µ»ØÐòÁÐÖµ
ÒÔÏÂsqlÓï¾äÏÈ´´½¨ÁËcustomers±í£¬È»ºó²åÈëÁ½Ìõ¼Ç¼£¬ÔÚ²åÈëʱÉ趨ÁËidºÍname×ֶεÄÖµ£¬ÆäÖÐid×ֶεÄÖµÀ´×ÔÓÚcustomer_id_seqÐòÁС£×îºó²éѯcustomers±íÖеÄid×ֶΡ£
create table customers(id int primary key not null, name varchar(15));
insert into customers values(customer_id_seq.curval, "name1"),(customer_id_seq.nextval, "name2");
select id from customers;
Èç¹ûÔÚoracleÖÐÖ´ÐÐÒÔÉÏÓï¾ä£¬²éѯ½á¹ûΪ£º
id
1
3
http://blog.csdn.net/andyelvis/archive/2008/05/14/2446865.aspx


Ïà¹ØÎĵµ£º

oracleµÄ¶¨Ê±ÈÎÎñjob

      ÏîÄ¿¾­ÀíÈÃ×öÀúÊ·Êý¾Ý±¸·Ý£¬Éæ¼°µ½ÈçºÎ½«ÒµÎñ±íÖеļǼµ¼³öµ½ÀúÊ·±íÖУ¬×Ô¼º×ʼÏëÄѵÀÊǸú×Ô¶¯¶ÔÕ˺Í×Ô¶¯ÉÏ´«³ÌÐòÒ»Ñùд¸ö³ÌÐòÈ»ºó½«³ÌÐò·ÅÔÚϵͳµÄÈÎÎñ¼Æ»®ÀﶨʱÔËÐУ¿»¹ÊÇÎÊÎÊÏîÄ¿¾­Àí°É£¬ÎÊÏîÄ¿¾­Àí£¬Äǵ¼³ö¼Ç¼Ôõô×ö¡£ÏîÄ¿¾­Àí˵£¬Êý¾Ý¿âÀïÓ¦¸ÃÓÐÕâ¸ö¹¦Äܰɡ£»ÐÈ»´óÎò£¬ÒþÔ¼¼ÇµÃÖ ......

oracleµÄ»ù±¾ÖªÊ¶

Oracle
    SqlServer2000 2005
 MySql      
 DB2
 ORACLE   sun  SUN
 
 Êý¾Ý¿â  DataBase  db
    ´æ´¢Êý¾Ý
 Êý¾Ý Data
        Êý×Ö   ......

°ïÖúÄã´ÓMySQLÒÆÖ²µ½SQL ServerµÄ¹¤¾ß£¨SSMA£©

For SQL Server2008:
http://www.microsoft.com/downloads/details.aspx?FamilyID=0e6168b0-2d0c-4076-96c2-60bd25294a8e&displaylang=en
For SQL Server2005:
http://www.microsoft.com/downloads/details.aspx?familyid=C6F14640-DA22-4604-AAAA-A45DE4A0CD4A&displaylang=en ......

SQL ServerÀïµÄ ISNULL Óë Oracle ÖÐµÄ NULLIF

SQL ServerÀïµÄ ISNULL Óë Oracle ÖÐµÄ NULLIF²»Í¬:
  SQL Server ÖÐÓÐÁ½¸ö²ÎÊý£¬Óï·¨£º
    ISNULL(check_expression, replacement_value)
    check_expression Óë replacement_value Êý¾ÝÀàÐͱØÐëÒ»ÖÂ
   
Èç¹û check_expression Ϊ NULL£¬Ôò·µ»Ø replacement_v ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ