insert into ITEM select 1,'2008-05-11 13:40:52.777', 2,ID from MEDIA where PATH='C:\Butterfly\1.jpg'
--为确保返回值只有一个,可以加上top 1 insert into ITEM select 1,'2008-05-11 13:40:52.777',2,(select top 1 ID from MEDIA where PATH='C:\Butterfly\1.jpg')
基本语法呀... insert into ITEM SELECT TOP 1 1,'2008-05-11 13:40:52.777', 2, a.ID FROM MEDIA as a WHERE PATH='C:\Butterfly\1.jpg'
简单的说,语法不支持。有两种方法指定数据值: 用 VALUES 子句为一行指定数据值: INSERT INTO MyTable (PriKey, Description) VALUES (123, 'A description of part 123.')用 SELECT 子查询为一行或多行指定数据值。 INSERT INTO MyTable (PriKey, Description) SELECT ForeignKey, Description FROM SomeView
insert into ITEM select 1,'2008-05-11 13:40:52.777',2,ID from MEDIA where PATH='C:\Butterfly\1.jpg'; -- 更改為select,values不支持子查詢,可用變量傳參
insert into ITEM select 1,'2008-05-11 13:40:52.777', 2,ID from MEDIA where PATH='C:\Butterfly\1.jpg'
--为确保返回值只有一个,可以加上top 1
insert into ITEM
select 1,'2008-05-11 13:40:52.777',2,(select top 1 ID from MEDIA where PATH='C:\Butterfly\1.jpg')
基本语法呀...
insert into ITEM
SELECT TOP 1 1,'2008-05-11 13:40:52.777', 2, a.ID
FROM MEDIA as a
WHERE PATH='C:\Butterfly\1.jpg'
INSERT INTO MyTable (PriKey, Description)
VALUES (123, 'A description of part 123.')用 SELECT 子查询为一行或多行指定数据值。
INSERT INTO MyTable (PriKey, Description)
SELECT ForeignKey, Description
FROM SomeView
insert into ITEM select 1,'2008-05-11 13:40:52.777',2,ID from MEDIA where PATH='C:\Butterfly\1.jpg'; --
更改為select,values不支持子查詢,可用變量傳參