SELECT ERROR_NUMBER() AS ErrorNumber	,
					ERROR_MESSAGE() AS ErrorMessage	

begin try

select * from @table where 1 = 0


IF @@ROWCOUNT = 0 
	BEGIN
		DECLARE @ErrorMessage VARCHAR(100) = 'test error'
		RAISERROR(@ErrorMessage ,16,1)
	END
end try

begin catch
	SELECT ERROR_NUMBER() AS ErrorNumber	,
					ERROR_MESSAGE() AS ErrorMessage	


end catch

BEGIN TRY


BULK INSERT
Sandbox_RTurner.dbo.TEMP_PEND_CLAIM_LINE_RT
FROM

'E:\Decision Support\RTurner\temp_pend_claim_line_text.txt'
WITH
(
FIELDTERMINATOR = ',',
TABLOCK
,ERRORFILE = 'E:\Decision Support\RTurner\PEND_CLAIM_LINE_RT'

)
END TRY

BEGIN CATCH

SELECT error_message(),
error_severity(),
error_state(),
error_number(),
error_procedure(),
error_line()


END CATCH;