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

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