Đã hoàn thành

Parse xml / match records in sql / insert rows - quick task..

Part 1:

Have a quick task of parse a sitemap xml - has <loc>string</loc> obviously..

Need to insert all rows into sql server (will change connection string when done, you can use local sql express to test)..

You will need to pull down a sitemap file to test..

Add columns for tofetch (bool, default null), fetchedby (varchar(50) default null), lastattempt (Datetime, default null), error (bool, default 0)

Clustered index on id (ident column).

Create an index on loc

Part 2:

Read a row from an existing table

Replace \/ with / (stored wrong in db)

Check your table for matches

If matched set tofetch=0

Create a test table for this and populate with some rows..


C# Project

SQL Create scripts

We will then compile, change the connection string to our sql server, and test then pay.

NOTE: Would like to have this script DONE today so please only bid if you can start immediately.

Kĩ năng: Lập trình C#

Xem nhiều hơn: parse xml matches, string programming, string match, programming sql, programming scripts, programming in sql, parse programming, match string, local programming, express scripts, c sharp test, c # sharp test, test sql server, sql server scripts, sql programming, Sql 2012, rows, parse, parse and, parse a string, need xml file programming, loc, bool, parse error parse error, parse table

Về Bên Thuê:
( 22 nhận xét ) Washington DC, United States

ID dự án: #1722369

Được trao cho:


Please check PM

$40 USD trong 1 ngày
(16 Đánh Giá)

7 freelancer đang chào giá trung bình $86 cho công việc này


Please check PMB. I am sure I will provide solution by my (USA) EOD.

$100 USD trong 1 ngày
(22 Nhận xét)

Hi, I can code this for you if you like. Thanks.

$100 USD trong 1 ngày
(13 Nhận xét)

kindly check pmb

$100 USD trong 0 ngày
(8 Nhận xét)

Please see PMB.

$80 USD trong 1 ngày
(4 Nhận xét)

I have lots of hands on experience in .net / SQL server. This project is less than a day's work

$100 USD trong 1 ngày
(0 Nhận xét)

Rest Assure, The work will be done by me within you provided timeline.

$80 USD trong 1 ngày
(0 Nhận xét)