USE [master]
GO
/****** Object:  StoredProcedure [dbo].[sp_DNCUPLOAD]    Script Date: 10/12/2009 21:27:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_DNCUPLOAD]
@phonenumber nvarchar(255)
drop table [mms].[dbo].[tabPhone]


CREATE TABLE [mms].[dbo].[tabPhone] ( phonenumber nvarchar(255))
BULK INSERT [mms].[dbo].[tabPhone] FROM 'c:\aa\tabPhone.txt'
with ( ROWTERMINATOR = '\n')