SELECT A.* FROM TEST_TABLE AS A INNER JOIN TEST_TABLE_B AS B ON (A.ID = B.ID) ;
SELECT A.* FROM TEST_TABLE AS A LEFT JOIN TEST_TABLE_B AS B ON (A.ID = B.ID) WHERE B.ID IS NULL ;
INSERT INTO TM_MEMBER (ID, NAME_SEI, NAME_MEI) VALUES (1, '田中', '太郎') ;
INSERT INTO TM_MEMBER (ID, NAME_SEI, NAME_MEI) VALUES (1, '田中', '太郎'), (2, '田中', '次郎'), (3, '田中', '花子') ;
-- IDENTITY列に値の挿入を許可する SET IDENTITY_INSERT TM_MEMBER ON; /* * 注意) SET IDENTITY_INSERT を使用した場合、 * INSERT文に挿入先テーブルの列リストは省略することができません。 * * NG:INSERT INTO TM_MEMBER VALUES .... * OK:INSERT INTO TM_MEMBER (ID ....) VALUES .... * */ INSERT INTO TM_MEMBER (ID, NAME_SEI, NAME_MEI) VALUES (1, '田中', '太郎') ; -- IDENTITY列に値の挿入を許可しない(念のため) SET IDENTITY_INSERT TM_MEMBER OFF;
INSERT INTO TT_BACKUP (ID, NAME) SELECT ID, NAME FROM TT_EMP ;
DELETE FROM TT_REPORT WHERE MOD_DATE < DATEADD(year, -1, GETDATE()) ;
-- 残念ながらDELETE文のテーブル名に別名(エイリアス)は使用できません。 DELETE REP FROM TT_REPORT WHERE NOT EXISTS (SELECT * FROM TM_MEMBER AS MEM WHERE TT_REPORT.MEM_ID = MEM.MEM_ID ) ;
UPDATE TM_MEMBER SET NAME_SEI = '田中', /* 名前を田中に */ IS_MARIG = 1 /* 既婚に1をセット */ WHERE MEM_ID = 10 ;
UPDATE A SET A.FIELD_1 = B.B_FIELD FROM TEST_TABLE AS A INNER JOIN TEST_TABLE_B AS B ON (A.UNIQUE_KEY_1 = B.UNIQUE_KEY_1);
COPYRIGHT © 2008 Deepnet Inc. ALL RIGHTS RESERVED.