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

ʵÓÃSQL語¾ä

http://blog.csdn.net/fenglibing/archive/2007/10/24/1841537.aspx
1¡¢½«Ò»¸ö±íÖеÄÄÚÈÝ¿½±´µ½ÁíÍâÒ»¸ö±íÖÐ
insert into testT1(a1,b1,c1) select a,b,c from test;
insert into testT select * from test; (Ç°ÌáÊÇ兩個±íµÄ結構ÍêÈ«Ïàͬ)
 
insert into notebook(id,title,content)
select notebook_sequence.NEXTVAL,first_name,last_name from students;
 
×¢:a1,b1,c1ÊÇ現ÔÚ±íÖеÄ×Ö¶ÎÃû¡£A,b,cÊÇÔ­±íÖеÄ×Ö¶ÎÃû
¿½±´µ¥ÌõÊý¾Ý
insert into a (select '123' as id, temp,temp2 from b where id=10)
2¡¢²éÕÒÖظ´¼Ç¼
SELECT DRAWING,DSNO from EM5_PIPE_PREFAB
WHERE ROWID!=(SELECT MAX(ROWID) from EM5
_PIPE_PREFAB D
WHERE EM5_PIPE_PREFAB.DRAWING=D.DRAWING AND
EM5_PIPE_PREFAB.DSNO=D.DSNO);
3¡¢É¾³ýÖظ´¼Ç¼
DELETE from EM5_PIPE_PREFAB
WHERE ROWID!=(SELECT MAX(ROWID) from EM5
_PIPE_PREFAB D
WHERE EM5_PIPE_PREFAB.DRAWING=D.DRAWING AND
EM5_PIPE_PREFAB.DSNO=D.DSNO);
4¡¢復ÖƱí結構
    ÔÚORACLEÖÐ: create table new_table as select * from old_table where rownum < 1;
ÔÚSQL SERVERÖÐ:˵Ã÷£º¸´ÖƱí(Ö»¸´Öƽṹ,Ô´±íÃû£ºa бíÃû£ºb)
¡¡¡¡SQL: select * into b from a where 1<>1 ¡¡
 
Óï¾ä
5¡¢Ò»´Î刪³ý¶à個×Ö¶Î
alter table TEST_A drop (TEST_num,test_name);
6¡¢實現Ò»個±íµÄ備·Ý
create table tableName_bak as select * from tableName;
7¡¢創½¨兩個±íµÄÖ÷Íâ鍵關聯
 
--ÏÈ創½¨Ö÷±í
create table t1(id int,stu_name varchar(50));
--為Ö÷±íÔö¼Ó³Ö¾ÃµÄÖ÷鍵約Êø
alter table t1 add(constraint t1_id primary key(id) deferrable);
--創½¨從±í£¬²¢將從±íµÄid設為Ö÷鍵
create table t2(id int primary key,sex varchar(10),address varchar(50));
--為從±íÔö¼ÓÍâ鍵約Êø£¬該約Êø來×ÔÓÚÖ÷±íËù創½¨µÄ約Êø×Ö¶Î
--當從Ö÷±íÖÐ刪³ý記錄時£¬×Ô動刪³ý從±íÖÐ與Ö®Ïà對µÄ¾ßÓÐÏàͬidµÄ記錄
--Ĭ


Ïà¹ØÎĵµ£º

SQLSERVER SQLÐÔÄÜÓÅ»¯

1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......

SQLÊý¾Ý¿â

1.      ´æ´¢¹ý³Ì(¶¨Òå&±àд)
l  ´´½¨´æ´¢¹ý³Ì
CREATE PROCEDURE storedproc1
AS
SELECT *
from tb_project
WHERE  Ô¤¼Æ¹¤ÆÚ<= 90
ORDER BY  Ô¤¼Æ¹¤ÆÚ DESC
GO
exec storedproc1
GO
 
l   Ð޸Ĵ洢¹ý³Ì
ALTER PROCEDURE storedproc1
AS
SEL ......

SQL ×Ö·û´®Óë16½øÖÆ»¥»»

ÔÚÍøÉÏ¿´µ½SQL×Ö·û´®×ª16½øÖƵÄÓï¾ä£¬¾­¹ýССÌí¼Ó£¬ÏÖ½«SQL×Ö·û´®Óë16½øÖÆ»¥»»µÄ·½·¨¼Ç¼£¬ÒÔ¹©ÒÔºó²é¿´¡£ 
--SQL char->HEX code
DECLARE @str VARCHAR(4000)
SET @str='SELECT * from dbo.TaskHistory' --Your sql char
DECLARE @i INT,@Asi INT,@ModS INT,@res VARCHAR(800),@Len INT,@Cres VARCHAR(4),@te ......

µÚ10Õ£ºSQLºÍTQuery¶ÔÏó

±¾ÕÂÊǹØÓÚ²éѯ¡£ÕâÊÇÒ»¸öÖ÷Ì⣬ÔÚºËÐĵĿͻ§/·þÎñÆ÷±à³Ì£¬Òò´ËÕâÊDZ¾Êé¸üÖØÒªµÄƪÕÂÖ®Ò»¡£
¸Ã²ÄÁϽ«±»·Ö³ÉÒÔÏÂÖ÷Òª²¿·Ö£º
ʹÓÃTQuery¶ÔÏó
ʹÓñ¾µØºÍÔ¶³Ì·þÎñÆ÷µÄSQLÀ´Ñ¡Ôñ£¬¸üУ¬É¾³ýºÍ²åÈë¼Ç¼
ʹÓÃSQLÓï¾äÀ´´´½¨Á¬½Ó£¬ÁªÏµÓαêºÍ³ÌÐò£¬ËÑË÷µ¥¸ö¼Ç¼
Õâ¸öËõд´ú±íµÄSQL½á¹¹»¯²éѯÓïÑÔ£¬Í¨³£ÊÇÃ÷ÏÔµÄÐø¼¯»ò˵à ......

SQL 2005ת»»³É2000 (SQL Server)


Ö±½Órestore»ò¸½¼ÓÓ¦¸ÃÊDz»ÐеÄ, Óýű¾+µ¼Êý¾Ý¿Ï¶¨Ã»ÓÐÎÊÌâ¡£
2005תµ½2000µÄ²½Öè
1. Éú³Éfor 2000°æ±¾µÄÊý¾Ý¿â½Å±¾
2005 µÄmanger studio
-- ´ò¿ª"¶ÔÏó×ÊÔ´¹ÜÀíÆ÷"(ûÓеĻ°°´F8), Á¬½Óµ½ÄãµÄʵÀý
-- ÓÒ¼üҪתµ½2000µÄ¿â
-- ÈÎÎñ
-- Éú³É½Å±¾
-- ÔÚ"½Å±¾Ïòµ¼"µÄ"Ñ¡ÔñÊý¾Ý¿â"ÖÐ, ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ