如何使用单个命令插入多个值？ [英] How Can I Insert Multiple Values Using A Single Command?

问题描述

plzzzzzzzz帮我解决........

plzzzzzzzz help me out........

推荐答案

INSERT命令允许多个值和多行：

The INSERT command allows multiple values and multiple rows:

INSERT INTO table_name (column1, column2, ...) 
VALUES (value1, value2, ...) 
       (nextvalue1, nextvalue2, ...)

请参阅OriginalGriff的solution1和我对他的回答的评论。



我建议使用这样的东西：

Please, see solution1 by OriginalGriff and my comment to His answer.

I'd suggest to use something like this:

INSERT INTO TableName (TextField1, NumericField2, ..., FieldN)
SELECT TextField1, NumericField2, ..., FieldN
    FROM (
    SELECT 'SomeText' AS TextField1, 123 AS NumericField2, ..., FieldN
    UNION ALL
    SELECT 'SomeOtherText' AS TextField1, 456 AS NumericField2, ..., FieldN
    UNION ALL
    SELECT 'AnotherText' AS TextField1, 789 AS NumericField2, ..., FieldN
) AS Src

如需了解更多信息，请参阅：

< a href =http://technet.microsoft.com/en-us/library/ms174335.aspx> INSERT（sql） [ ^ ]

INSERT EXAMPLES（sql） [ ^ ]

这篇关于如何使用单个命令插入多个值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！