Đang Thực Hiện

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..

Deliverables:

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 thêm: string match, programming scripts, programming sql, match string, local programming, express scripts, sharp test, test sql server, sql server scripts, sql programming, sql 2012, rows, need xml file programming, loc, bool, rows insert, sql create script, create sharp project, quick task, datetime, script xml file sql, insert sql, match records, set sql server express, match existing

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

Mã Dự Án: #1722369

Đã trao cho:

oasis21

Please check PM

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

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

tejas34

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

$100 USD trong 1 ngày
(22 Đánh Giá)
5.8
morpheeen

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

$100 USD trong 1 ngày
(13 Đánh Giá)
4.5
AmirAly

kindly check pmb

$100 USD trong 0 ngày
(8 Đánh Giá)
4.5
sikandermandal

Please see PMB.

$80 USD trong 1 ngày
(4 Đánh Giá)
4.0
atinobrian

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 Giá)
0.0
mhKazmi

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

$80 USD trong 1 ngày
(0 Đánh Giá)
0.0