All pastes #352589 Raw Edit

Mine

public text v1 · immutable
·published 2007-02-12 22:49 UTC
rendered paste body

CREATE PROCEDURE [dbo].[usp_SurveyImport]
	
AS

Begin
BULK INSERT [tbl_SurveyRecipient]
    FROM '\\server3\sites\admin\imports\contacts.txt'
    WITH 
    ( 
        FIRSTROW = 2, 
        FIELDTERMINATOR = '|', 
        ROWTERMINATOR = '\n' 
    )
End
GO