1. SQLÓÅ»¯µÄÔÔòÊÇ£º
½«Ò»´Î²Ù×÷ÐèÒª¶ÁÈ¡µÄBLOCKÊý¼õµ½×îµÍ,¼´ÔÚ×î¶ÌµÄʱ¼ä´ïµ½×î´óµÄÊý¾ÝÍÌÍÂÁ¿¡£
µ÷Õû²»Á¼SQLͨ³£¿ÉÒÔ´ÓÒÔϼ¸µãÇÐÈ룺
¼ì²é²»Á¼µÄSQL£¬¿¼ÂÇÆäд·¨ÊÇ·ñ»¹ÓпÉÓÅ»¯ÄÚÈÝ
¼ì²é×Ó²éѯ ¿¼ÂÇSQL×Ó²éѯÊÇ·ñ¿ÉÒÔÓüòµ¥Á¬½ÓµÄ·½Ê½½øÐÐÖØÐÂÊéд
¼ì²éÓÅ»¯Ë÷ÒýµÄʹÓÃ
¿¼ÂÇÊý¾Ý¿âµÄÓÅ»¯Æ÷
2. ±ÜÃâ³öÏÖSELECT * from table Óï¾ä£¬ÒªÃ÷È·²é³öµÄ×ֶΡ£
3. ÔÚÒ»¸öSQLÓï¾äÖУ¬Èç¹ûÒ»¸öwhereÌõ¼þ¹ýÂ˵ÄÊý¾Ý¿â¼Ç¼Խ¶à£¬
¶¨Î»Ô½×¼È·£¬Ôò¸ÃwhereÌõ¼þÔ½Ó¦¸ÃÇ°ÒÆ¡£
4. ²éѯʱ¾¡¿ÉÄÜʹÓÃË÷Òý¸²¸Ç¡£¼´¶ÔSELECTµÄ×ֶν¨Á¢¸´ºÏË÷Òý£¬
ÕâÑù²éѯʱֻ½øÐÐË÷ÒýɨÃ裬²»¶ÁÈ¡Êý¾Ý¿é¡£
5. ÔÚÅжÏÓÐÎÞ·ûºÏÌõ¼þµÄ¼Ç¼ʱ½¨Òé²»ÒªÓÃSELECT &nbs ......
Èç¹û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 ......
Èç¹û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 ......
ÎÒÃÇÔÚ×öºÜ¶àÏîĿʱ¶¼ÒªÉæ¼°µ½Êý¾Ý¿â£¬ÌرðÊÇһЩ±È½Ï´óÐ͵ÄwebÏîÄ¿£¬¸üÊÇÓнϴóµÄ²¢·¢´¦Àí£¬ËùÒÔ¶ÔÊý¾Ý¿âµÄ²Ù×÷ÓпÉÄÜ»á²úÉúËÀËø£¬¶ÔÓÚÊý¾Ý¿âµÄËÀËø£¬Ò»°ãÊý¾Ý¿âϵͳ¶¼»áÓÐÒ»Ì×»úÖÆÈ¥½âËø£¬Ò»°ã²»»áÔì³ÉÊý¾Ý¿âµÄ̱»¾£¬µ«½âËøµÄ¹ý³Ì»áÔì³ÉÊý¾Ý¿âÐÔÄܵļ±ËÙϽµ£¬·´Ó³µ½³ÌÐòÉϾͻáÔì³É³ÌÐòµÄ·´Ó¦ÐÔÄܵÄϽµ£¬²¢ÇÒ»áÔì³É³ÌÐòÓеIJÙ×÷ʧ°Ü¡£ËäȻһ°ã¶ÔÓÚÊý¾Ý¿â¼¶±ðµÄËø¶¨ÓÚ½âËø³ÌÐòÔ±²»»áÔÚ³ÌÐòÖÐÓôúÂë±à³ÌÈ¥´¦Àí£¬µ«ÊǶÔÓÚÆäµÄÁ˽â¶ÔÓÚ³ÌÐòÔ±À´Ëµ»¹ÊǺÜÓкô¦µÄ£¬ËüÄÜÈÃÎÒÃÇÔÚ³öÏÖÎÊÌâʱ¿ìËÙÕÒµ½ÎÊÌâµÄÔÒò£¬Í¬Ê±ÈÃÎÒÃÇÔÚ±à³ÌʱעÒâÄÄЩ¿ÉÄÜÔì³ÉÊý¾Ý¿âËÀËøµÄ²»Ì«ºÃµÄ±àÂë¡£
ÒÔÏÂÒÔsql server2000ΪÀý£¬À´Á˽âÊý¾Ý¿âËÀËøµÄһЩ֪ʶ£¨Æäʵ¸÷ÖÖ´óÐÍÊý¾Ý¿âËù²ÉÓõÄËøµÄ»ù±¾ÀíÂÛÊÇÒ»Öµģ¬µ«ÔÚ¾ßÌåʵÏÖÉϸ÷Óвî±ð¡££©
Ö®ËùÒÔÒªÓÐËøµÄ¸ÅÄîÊÇÒòΪ´æÔÚ×ŶàÓû§Í¬Ê±ÐèÒª·ÃÎÊÊý¾Ý¿â£¬Èç¹ûûÓÐËø¶¨ÇÒ¶à¸öÓû§Í¬Ê±·ÃÎÊÒ»¸öÊý¾Ý¿â£¬Ôòµ±ËûÃǵÄÊÂÎñͬʱʹÓÃÏàͬµÄÊý¾Ýʱ¿ÉÄܻᷢÉúÎÊÌ⣬ÕâЩÎÊÌâ°üÀ¨£º¶ªÊ§¸üС¢Ôà¶Á¡¢²»¿ÉÖظ´¶ÁºÍ»Ã¾õ¶ÁµÈµÈ£¬ÔÚÕâ¾Í²»Ò»Ò»½âÊÍÁË£¬×ÜÖ®¾ÍÊÇ·¢ÉúÊý¾Ý²»Ò»Ö ......
SQL Server ¼¸¸öºÃÓõÄSQLÓï¾ä
1¡¢¸´ÖƱí
select * into desttable from srctable
½« srctable ÍêÕûµØ¸´ÖÆÒ»·Ýµ½ desttable ÖУ¬µ±È»ºóÃæÒ²¿ÉÒÔ¼ÓÉÏÌõ¼þÀ´ÏÞ¶¨ÐèÒª¸´ÖƵļǼ
ÒªÇó£ºdesttable ±ØÐëΪ²»´æÔڵıíÃû¡£
insert into desttable(column1, column2) select columna, columnb from srctable
½« srctable ±íÖеÄcolumna, columnb ×Ö¶ÎÖƵ½ desttable µÄcolumn1, column2ÖУ¬ºóÃæÒ²¿ÉÒÔ¼ÓÉÏÌõ¼þÀ´ÏÞ¶¨ÐèÒª¸´ÖƵļǼ
ÒªÇó£ºdesttable ±ØÐëΪÒѾ´æÔڵıíÃû¡£
2¡¢Á¬½ÓÐ޸ġ¢É¾³ýÓï¾ä
delete from table1 from table1 inner join table2 on table1.id = table2.tid
±íµÄÁ¬½Óɾ³ýÓï¾ä
update table1 set table1.column1 = table2.columna, table1.column2 = table2.columnb
from table1 inner join table2 on table1.id = table2.id
±íµÄÁ¬½Ó¸üÐÂÓï¾ä£¬Ê¹ÓÃÆðÀ´·Ç³£·½±ã¡£ ......
Õ⼸ÌìÊÖÍ·¿ª·¢µÄϵͳҪ×öÒ»¸öÀàËÆwindowsÕË»§µ½ÆÚʱ¼äµÄ¹¦ÄÜ£¬¿¼ÂÇÁË°ëÌìÏë³öÁËÒ»¸ö¼¼ÊõÉϺÍÂß¼É϶¼»¹ÄÜʵÏֵĽâ¾ö·½°¸£º
´´½¨Ò»¸öÓû§´æÈëÊý¾Ý¿âµÄʱºò¶¼´´½¨Ò»¸öʼþµ÷¶ÈÆ÷À´¿ØÖÆÓû§µÄµ½ÆÚʱ¼ä£¨mysqlµÄʱ¼äµ÷¶ÈÆ÷ȷʵºÜ·½±ã£©¡£ÏëÆðÀ´ÊǺܼòµ¥£¬µ«ÊÇ×öÆðÀ´ÎÊÌâȷʵһ²¨½ÓÒ»²¨...
һЩСÎÊÌâ¾Í²»ËµÁË£¬µ½Á˹ؼüµÄµØ·½ÁË£ºÔÚ²åÈëÒ»¸öÓû§µÄʱºòÎÒµ½µ×ÊÇÔÚÓ¦ÓòãÀ´Ìí¼ÓÒ»¸öʼþµ÷¶ÈÆ÷ÄØ»¹ÊÇÔÚÊý¾Ý¿âÀïÃæ×Ô¶¯Ìí¼Ó¡£
µ±È»²»¹Ü´Ó´úÂëµÄÃÀ¹ÛÉÏ¡¢ÏµÍ³Éè¼ÆµÄ˼ÏëÉÏ»òÊÇÔËÐÐЧÂÊÉÏÀ´Ëµ£¬ÎÒ¶¼Ó¦¸ÃÑ¡ÔñºóÕߣ¨·Ï»°...£©¡£ÓÚÊÇÎÒ¾ÍÑ¡ÔñÁ˺óÕߣ¨Äã¸ÒÔÙ˵·Ï»°Â𣩡£ÄÇô¾ÍÓÐÁ˽ñÌìµÄÕâ¶Î±Ê¼Ç...
Ò»¿ªÊ¼ÎÒÐËÖ²ª²ªµÄÆ´ºÃ×Ö·û´®Ê²Ã´µÄ£¬Ð´ÁËÈçÏÂÒ»¸ö´¥·¢Æ÷
delimiter //
create trigger tri_user after insert on user for each row
begin
set @u_name = new.u_name;
set @expire = '';
select sm_pwd_alter_day into @expire from system_manage where sm_id = 1;
set @str = concat('create EVENT eve_', @u_name, ' ON SCHEDULE EVERY ', @expire, ' day DO
update user set u_enable = \'δÆôÓÃ\' where u_name = \'', @u_n ......
Õ⼸ÌìÊÖÍ·¿ª·¢µÄϵͳҪ×öÒ»¸öÀàËÆwindowsÕË»§µ½ÆÚʱ¼äµÄ¹¦ÄÜ£¬¿¼ÂÇÁË°ëÌìÏë³öÁËÒ»¸ö¼¼ÊõÉϺÍÂß¼É϶¼»¹ÄÜʵÏֵĽâ¾ö·½°¸£º
´´½¨Ò»¸öÓû§´æÈëÊý¾Ý¿âµÄʱºò¶¼´´½¨Ò»¸öʼþµ÷¶ÈÆ÷À´¿ØÖÆÓû§µÄµ½ÆÚʱ¼ä£¨mysqlµÄʱ¼äµ÷¶ÈÆ÷ȷʵºÜ·½±ã£©¡£ÏëÆðÀ´ÊǺܼòµ¥£¬µ«ÊÇ×öÆðÀ´ÎÊÌâȷʵһ²¨½ÓÒ»²¨...
һЩСÎÊÌâ¾Í²»ËµÁË£¬µ½Á˹ؼüµÄµØ·½ÁË£ºÔÚ²åÈëÒ»¸öÓû§µÄʱºòÎÒµ½µ×ÊÇÔÚÓ¦ÓòãÀ´Ìí¼ÓÒ»¸öʼþµ÷¶ÈÆ÷ÄØ»¹ÊÇÔÚÊý¾Ý¿âÀïÃæ×Ô¶¯Ìí¼Ó¡£
µ±È»²»¹Ü´Ó´úÂëµÄÃÀ¹ÛÉÏ¡¢ÏµÍ³Éè¼ÆµÄ˼ÏëÉÏ»òÊÇÔËÐÐЧÂÊÉÏÀ´Ëµ£¬ÎÒ¶¼Ó¦¸ÃÑ¡ÔñºóÕߣ¨·Ï»°...£©¡£ÓÚÊÇÎÒ¾ÍÑ¡ÔñÁ˺óÕߣ¨Äã¸ÒÔÙ˵·Ï»°Â𣩡£ÄÇô¾ÍÓÐÁ˽ñÌìµÄÕâ¶Î±Ê¼Ç...
Ò»¿ªÊ¼ÎÒÐËÖ²ª²ªµÄÆ´ºÃ×Ö·û´®Ê²Ã´µÄ£¬Ð´ÁËÈçÏÂÒ»¸ö´¥·¢Æ÷
delimiter //
create trigger tri_user after insert on user for each row
begin
set @u_name = new.u_name;
set @expire = '';
select sm_pwd_alter_day into @expire from system_manage where sm_id = 1;
set @str = concat('create EVENT eve_', @u_name, ' ON SCHEDULE EVERY ', @expire, ' day DO
update user set u_enable = \'δÆôÓÃ\' where u_name = \'', @u_n ......
Öª: ×Ö¶ÎA='F:\photo\Winter Leaves.jpg'
ÒªÇó:·Ö¶Î½Øȡÿ¶Î×Ö·û[×Ö¶ÎA²»ÄÜΪTEXTÀàÐÍ,·ñÔò±¨´í]
½â¾ö·½·¨:
---½ØÈ¡×Ö·û´®AµÄµÚÒ»¸ö\×ó±ßµÄ×Ö·û´®
select left(A,charindex('/',A)-1)
Êä³ö½á¹û£ºF:
---½ØÈ¡\ÖмäµÄ×Ö·û´®
select left(stuff(A,1,charindex('/',A),''),charindex('/',stuff(A,1,charindex('/',A),''))-1)
Êä³ö½á¹û£ºphoto
---½ØÈ¡×îºóÒ»¸ö\ºóÃæµÄ×Ö·û´®
select reverse(left(reverse(A),charindex('/',reverse(A))-1))
Êä³ö½á¹û£ºWinter Leaves.jpg
---½ØÈ¡×Ö·û´®AµÄÊ××ÖÄ»
select STUFF(A,1, 1, '')
Êä³ö½á¹û£º:\photo\Winter Leaves.jpg ......