Re: Cannot edit table data using Enterprise Manager
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Wed, 16 Aug 2006 11:44:04 -0600
The point of using Query Analyzer is that you write the
statement to update the data. I don't use the Open Table
part in the object browser of Query Analyzer so I don't know
if you would hit the same issue as you do in Enterprise
Manager but you could try that.
I think in the time people spend trying to do these types of
updates without writing the SQL, they struggle so long that
they could have had the SQL written and been done with it!
Not meaning to be rude or anything with the comment. I think
you'd be better off in the long run by just writing the SQL.
When you get used to doing it, it is just as fast as
anything else, provides you with a script you can save which
somewhat documents what changes you made, gives you more
control over exactly what is going to be executed, etc. Lots
of benefits to going the SQL route.
-Sue
On Tue, 15 Aug 2006 23:40:01 -0700, LBT
<LBT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Am I able to edit the data in real time manner using Query Analyzer so that I
no need to create an SQL update statement to update the column? It's quite
troublesome when need to modify the data (long string) using update statement
(eg: change or insert some words to data string using Replace function is
tedious). Thanks.
"Sue Hoegemeier" wrote:
It's due to a limit set in Enterprise Manager. Enterprise
Manager wasn't designed to be a data entry tool. You should
be using Query Analyzer or some other method to modify the
data.
-Sue
On Tue, 15 Aug 2006 04:29:02 -0700, LBT
<LBT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi Experts,
I have the problem to edit data of a column contained inside a table
directly using MSSQL Enterprise Manager. This is only happen when the length
of the data is more than 1000++ characters. Whatever I type into the column
just couldn't be inserted. Please advice. Thanks.
.
- References:
- Re: Cannot edit table data using Enterprise Manager
- From: Sue Hoegemeier
- Re: Cannot edit table data using Enterprise Manager
- Prev by Date: Re: import data.
- Next by Date: Sql debugger
- Previous by thread: Re: Cannot edit table data using Enterprise Manager
- Next by thread: Copy Database Fails: .Net runtime error?
- Index(es):
Relevant Pages
|
