INSERT INTO worker(TeamName, WorkerID, WorkerName, WorkerType)
VALUES ((SELECT teamID FROM list_banzu WHERE teamName = 'MK60_A'), '1111111', '111111',
(SELECT id FROM list_type WHERE workType = '班组长'))select出的值肯定都唯一的 , 帮忙看看我哪里错了
VALUES ((SELECT teamID FROM list_banzu WHERE teamName = 'MK60_A'), '1111111', '111111',
(SELECT id FROM list_type WHERE workType = '班组长'))select出的值肯定都唯一的 , 帮忙看看我哪里错了
解决方案 »
- 用一条sql语句查询平均分大于60的id
- 资料库 'tempdb' 的记录档档案已满
- 能用自己的话谈谈索引里填充因子及其功能吗
- 恳求 在SQL Server 中如何调用并查看 调用的函数和存储过程 的结果
- sql2000 怎么得到表中记录的创建时间和修改时间
- SQL server管理问题!
- 请问如何用VB编程实现对sqlserver数据库的计划备份?
- HELP!!如何,用SQL代码复制数据库中的表,在SQL Server 2000中
- 如何将同一个完整数据库备份恢复成不同的名称数据库(同一SQL上)
- windows 10安装mysql-8.0.15-winx64数据库
- 上一个或下一个ID的问题
- sql server 2005 安装的问题
(SELECT max(id) FROM list_type WHERE workType = '班组长'))
declare @listtype varchar(100)
SELECT @teamID =teamID FROM list_banzu WHERE teamName = 'MK60_A'
SELECT @listtype=id FROM list_type WHERE workType = '班组长' INSERT INTO worker(TeamName, WorkerID, WorkerName, WorkerType)
VALUES(@teamID,'1111111','111111', @listtype)
然后在Insert的时候使用这两个变量.
2楼可以,如果非在一句中写用select 不用values
INSERT INTO worker(TeamName, WorkerID, WorkerName, WorkerType)
SELECT teamID, '1111111', '111111',(SELECT id FROM list_type WHERE workType = '班组长')
FROM list_banzu WHERE teamName = 'MK60_A'
INSERT INTO worker(TeamName, WorkerID, WorkerName, WorkerType)
select (SELECT teamID FROM list_banzu WHERE teamName = 'MK60_A'), '1111111', '111111', id
FROM list_type WHERE workType = '班组长'