作者twoseven (Tse)
看板Database
標題Re: [SQL ] 請益SQL語法 兩個資料表之間的關係
時間Wed Jun 27 17:13:11 2012
DECLARE @EMPLOYEE table
(
EMPLOYEE_ID varchar(10),
CHK_CODE varchar(5)
)
INSERT INTO @EMPLOYEE VALUES ('001','Y')
INSERT INTO @EMPLOYEE VALUES ('002','Y')
INSERT INTO @EMPLOYEE VALUES ('009','Y')
INSERT INTO @EMPLOYEE VALUES ('004','Y')
INSERT INTO @EMPLOYEE VALUES ('010','Y')
DECLARE @WEB_POWERSET_MENU table
(
EMPLOYEE_ID varchar(10),
DEPART varchar(20),
GROUP_ID varchar(10),
MODULES_ID varchar(10),
VIEW_YN varchar(10),
INSERT_YN varchar(10),
EDIT_YN varchar(10),
DELETE_YN varchar(10)
)
INSERT INTO @WEB_POWERSET_MENU (EMPLOYEE_ID, DEPART, GROUP_ID,
MODULES_ID, VIEW_YN, INSERT_YN, EDIT_YN, DELETE_YN)
SELECT
EMPLOYEE_ID,
'sysmanager','02','08','Y','Y','Y','Y' from @EMPLOYEE
SELECT * FROM @WEB_POWERSET_MENU
這樣符合你要的嗎
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 122.117.41.57
1F：推 cluclu:好的 感謝 我試看看 我之前有用另一個disctinct方式成功 07/04 18:01