Gossamer Forum
Home : General : Databases and SQL :

Help dumb guy

Quote Reply
Help dumb guy
My database guy is in the midst of moving cross country so I'm having to stumble through some stuff on my own.

Can anybody tell me how I edit a "<Long Text>" cell in MS Enterprise Manager? I can edit other cells with no trouble. I need to delete the contents of the cell and replace it, it contains a paragraph of text.

I even managed to mangle my way through a query just to return the one cell I want to edit.

Don't laugh I'm very proud of this:
Code:
SELECT GroupNotes
FROM Groups
WHERE (GroupId = 279)
Quote Reply
Re: [ArmyAirForces] Help dumb guy In reply to
If that query only returns one result, you could do:

UPDATE GroupNotes
SET ColumnToChange = "New Data"
WHERE GroupID = 279

Where ColumnToChange is the name of your Long Text field, and "New Data" is what you want to replace the text with. I haven't used enterprise manager enough to know how to edit it directly. Sorry!

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Help dumb guy In reply to
Thanks Alex,

It worked like a charm in query analyzer after I changed the " to ' around 'New Data'.

-Scott