Three-way SMS monthly send volume into SQL Server essay

CREATE TABLE SQL

CREATE TABLE SmsSentLog2014101625 (

Phone NVARCHAR (MAX),

Messagecontent NVARCHAR (MAX),

Messagestatus NVARCHAR (MAX),

Messagecount NVARCHAR (MAX),

MessageStatus1 NVARCHAR (MAX),

Province NVARCHAR (MAX),

Guishudi NVARCHAR (MAX),

Sendtime NVARCHAR (MAX),

Statustime NVARCHAR (MAX)

)

/**/Import from CSV into the table,

This is the reference link http://www.cnblogs.com/xbf321/archive/2010/03/14/sql-server-import-csv-in-to-table.html

BULK INSERT SmsSentLog201410

From ' f:\ tee October SMS details \dh1703 1026--1031.csv '

With (

FieldTerminator = ' "," ',

Rowterminator = ' \ n '

)

SELECT COUNT (1) from SmsSentLog201410

drop table SmsSentLog201410

Update SmsSentLog201410 Set messagecount = REPLACE (Messagecount, ' "', ')

Delete from SmsSentLog201410 where phone = ' mobile number '

Three-way SMS monthly send volume into SQL Server essay