Solved

Editing Data in tables

Posted on 1998-12-03
2
194 Views
Last Modified: 2010-03-19
This is one of my first times working with SQL. We are using 6.5 and I need to edit and add so data to fields in the tables in the database.
0
Comment
Question by:Yogi012398
2 Comments
 
LVL 2

Accepted Solution

by:
tschill120198 earned 20 total points
ID: 1092057
What is it you want specifically... syntax?  Do these tables you want to edit/add already exist?
0
 
LVL 3

Expert Comment

by:traygreen
ID: 1092058
There are several tools you can use to add/modify fields in the tables...
Enterprise Manager
ISQLw
and Interdev to Name a few.
In InterDev and Enterprise manager you work in a GUI enviroment
In ISQLw and the Query Window in Enterprise Manager you write SQL (text) statements to Alter/Add tables.

Give us some specifics and more points and we can help you a bit more
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question