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