Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Editing cells from with Server Management Studio Expand / Collapse
Author
Message
Posted Sunday, October 28, 2012 8:38 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, March 2, 2014 1:41 PM
Points: 18, Visits: 37
(Sorry, headline is supposed to read "from within")

Moving (asap) from 2000 to 2005.

In 2000, we could easily bring up a table, and display a record on screen. Edit a field, a cell. When moving to another record, the result would save.

Now in 2005, I find when a record is on screen, I cannot edit any content.

Huh????

How do I do that ... tried right clicking on row, cell, etc.

Tell me I don't have to write an update???

Robert
Post #1378029
Posted Sunday, October 28, 2012 1:45 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, August 15, 2014 8:17 AM
Points: 709, Visits: 1,416
I don't think you can. You're going to need to do it using a DML statement in a query editor window.

If you provide the DDL of the table(s), sample data, the criteria of what you are looking up to change and the desired result someone in the forums may be able to assist in generating the T-SQL syntax you need to fulfill your request.


Joie Andrew
"Since 1982"
Post #1378051
Posted Sunday, October 28, 2012 1:58 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 5:24 AM
Points: 128, Visits: 490
It depends on how you pulled the record.

Right-click your table, select the option to edit records (can't recall the exact name of this option) and attempt to edit the record. This works fine for me.

Mark



Post #1378052
Posted Sunday, October 28, 2012 4:49 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, August 15, 2014 8:17 AM
Points: 709, Visits: 1,416
I think you can only do up to the first 200 rows with that.

Joie Andrew
"Since 1982"
Post #1378064
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse