Find Jobs
Hire Freelancers

SQL Update App

$30-250 USD

Completed
Posted over 10 years ago

$30-250 USD

Paid on delivery
This app NEEDS to be able to connect to ANY MSSQL database. It should act a lot like sql management studio would. When i first open it, it should ask for connection address and port number. IE [login to view URL] and port 1434. Then it should ask for user name and password. Then it should display a list of databases on the server available to the user name supplied. After selecting the data base it should then display a list of tables associated with this database After selecting this table it would display a list of columns associated with this table. The first column selected would be what I would call the primary key column. The next columns selected would be what I would call the fill columns. So now if I select the following columns: Primary key column certificate# fill column rock# fill column corn# fill column veg# The program would look at the column for certificate# and if it had data it would then look at the columns rock#, corn# and veg#. If any one of these columns were blank it would display all four columns and allow manual input of data into any of the "Fill Columns". If the primary key column does not have data or if all of the fill columns have existing data, the program would simply ignore that line. In the event that rock# and corn# had data but veg# did not it would display all three columns as shown in the picture below: Any of the data in the fill columns should be able to be edited and submitted back to the database. They will of course have to follow the formatting for the sql database. I should also be able to select anywhere from 1-1000 fill columns but only ever one primary key column.
Project ID: 5291484

About the project

4 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi Working on it and finalizing it in few hours to update you I will send you the setup which you can install on your computer Thanks Adnan
$257 USD in 3 days
5.0 (58 reviews)
7.8
7.8
4 freelancers are bidding on average $180 USD for this job
User Avatar
A proposal has not yet been provided
$70 USD in 5 days
4.9 (404 reviews)
7.3
7.3
User Avatar
Hello Thank you for posting this project Im expert please check my reviws Ready to start Best Diego
$250 USD in 10 days
5.0 (40 reviews)
6.0
6.0

About the client

Flag of UNITED STATES
Rupert, United States
5.0
4
Payment method verified
Member since Apr 4, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.