SQl：从文本文件更新表

CREATE PROCEDURE [dbo].[BulkInsert]            
(            
@PID int,@x int,@y int,)            
AS            
BEGIN            
SET NOCOUNT ON;            

declare @query varchar(maX)            


create table #TEMP            
(            
[PID] [int] NOT NULL,[x] int nOT NULL,[y] int nOT NULL,)            


SET @query = 'BULK INSERT #TEMP FROM ''' + PathOfYourTextFile + ''' WITH ( FIELDTERMINATOR = '','',ROWTERMINATOR = ''\n'')'            
--print @query            
--return            
execute(@query)            


BEGIN TRAN;            

MERGE Tablename AS Target            
USING (SELECT * FROM #TEMp) AS source            
ON (Target.YourTablEID = source.YourTextFileFieldId)
-- In the above line we are checking if the particular row exists in the table(Table1)  then update the Table1 if not then insert the new row in Table-1.           

WHEN MATCHED THEN            
updatE SET             
TargeT.PID= source.PID,Target.x= source.x,Target.y= source.y           
WHEN NOT MATCHED BY TARGET THEN            

-- Insert statement@H_675_20@ 
 
您可以使用上述方法来解决您的问题.希望这可以帮助.