SQL Server INSERT 一次插入多行

INSERT INTO [cab_zhongshan_module_demo_new].[dbo].[base_person]
([name],[sex],[address],[age],[phone],[description],[duty],[FE_mail],[FPicture ,[FExamStatus] ,[computerName],[del])
select 'city','男','city',22,'1234567890','skjfklajfklsjlkfdj','city',NULL,NULL,0,'',0 union
select 'street','男','street',22,'1234567890','skjfklajfklsjlkfdj','street',NULL,NULL,0,'',0 union
select 'conutry','男','conutry',22,'1234567890','skjfklajfklsjlkfdj','conutry',NULL,NULL,0,'',0
GO

posted on 2011-11-14 09:54  小小贼  阅读(2352)  评论(0编辑  收藏  举报

导航