3 回答

TA貢獻(xiàn)1839條經(jīng)驗(yàn) 獲得超15個(gè)贊
INSERT INTO dbo.MyTable (ID, Name)
SELECT 123, 'Timmy'
UNION ALL
SELECT 124, 'Jonny'
UNION ALL
SELECT 125, 'Sally'
對(duì)于SQLServer 2008,可以在一個(gè)值子句中執(zhí)行此操作一點(diǎn)兒沒(méi)錯(cuò)根據(jù)您問(wèn)題中的語(yǔ)句(您只需要添加一個(gè)逗號(hào)來(lái)分隔每個(gè)值語(yǔ)句).

TA貢獻(xiàn)1801條經(jīng)驗(yàn) 獲得超8個(gè)贊
您的語(yǔ)法幾乎適用于SQLServer 2008(但在SQLServer 2005中不起作用)1):
CREATE TABLE MyTable (id int, name char(10));
INSERT INTO MyTable (id, name) VALUES (1, 'Bob'), (2, 'Peter'), (3, 'Joe');
SELECT * FROM MyTable;
id | name
---+---------
1 | Bob
2 | Peter
3 | Joe
1在回答這個(gè)問(wèn)題時(shí),并沒(méi)有清楚地表明這個(gè)問(wèn)題指的是SQLServer 2005。我把這個(gè)答案留在這里,因?yàn)槲艺J(rèn)為它仍然是相關(guān)的。

TA貢獻(xiàn)1799條經(jīng)驗(yàn) 獲得超9個(gè)贊
INSERT INTO MyTable(ID, Name)SELECT ID, NAME FROM OtherTable
INSERT INTO MyTable (Name, ID)VALUES ('First',1),('Second',2),('Third',3),('Fourth',4),('Fifth',5)
添加回答
舉報(bào)