Fairly simple and straightforward project. I need help adding several fields with correct field type to an existing MS-SQL database table. A temporary userid/password will be provided to access the MS-SQL 2005 server.
The fields being added are:
Lat - latitude used for Google maps such as 48.836701
Lon - longitude used for Google maps such as -123.481865
Gana - Google Analytics ID such as UA-10876-1
Ad1 - 0/1 boolean
Ad2 - 0/1 boolean
Ad3 - 0/1 boolean
Ad4 - 0/1 boolean
Ad5 - 0/1 boolean
These fields should be added to the main database table and all set to 0 or Null. As the site is live, we may need to undo any changes if it disrupts the site for any reason. It is critical that no data in the table be removed.
The ideal candidate is also proficient at ASP coding on the front end as we have ongoing projects and are interested in developing an ongoing working relationship.