qw122546 发表于 2013-01-31 17:06

问个插入语句

我要插入
INSERT INTO SYS_PRSNL (PRSNL_ID, PRSNL_NUM, UNIT_ID, FULL_NAME)

其中
PRSNL_ID= ISNULL(MAX(PRSNL_ID),0)+1
PRSNL_NUM=TEST01
UNIT_ID =SELECT UNIT_ID FROM SYS_UNIT WHERE UNIT_NUM = 'TEST01'
FULL_NAME = 系统管理员

请问要怎么写

qw122546 发表于 2013-02-01 10:05

INSERT INTO SYS_PRSNL (PRSNL_ID, PRSNL_NUM, UNIT_ID, FULL_NAME) SELECT (SELECT
ISNULL(MAX(PRSNL_ID),0)+1 FROM SYS_PRSNL),'TEST01SA',(SELECT UNIT_ID FROM SYS_UNIT
WHERE UNIT_NUM = 'TEST01'),'系统管理员'
页: [1]
查看完整版本: 问个插入语句