一条指令INSERT多笔资料 - Multiple rows with a single INSERT query

一条指令INSERT多笔资料
Inserting multiple rows with a single INSERT query

1. 
   
2. INSERT INTO [UserInfo] (InfoName, InfoValue)
   
3.     SELECT 'Name1', 'Value1'
   
4. UNION ALL
   
5.     SELECT 'Name2', 'Value2'
   
6. UNION ALL
   
7.     SELECT 'Name3', 'Value3'
   

复制代码