如何批量从*.TXT,把数据插入表中么?(UP的有分,谢谢,,急急,在线等待)
数据库中有表如下:
CREATE TABLE [dbo].[Surveys] (
[SurveyID] [int] IDENTITY (1, 1) NOT NULL ,
[SurveyName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SurveyInstructions] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SurveyResponse] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
----------------------------------------------------------
--C盘中有一文件Surveys.txt
--内容如下
1,"New Web Site Design","Please complete each question. Thank you!","Thank you for taking the time to answer our questions. Your feedback is greatly appreciated!"
2,"Sales Staff","We want to know what you think about our sales staff.","Thank you for taking the time to answer our questions. Your feedback is greatly appreciated!"
怎样把数据批量插入表中?不是一句句的使用SQL!