Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GregDDDD
Posting Yak Master
120 Posts |
 Posted - 2010-02-24 : 11:35:50
|
| I'm using SQL Server Management Studio Express and when I create a query on a single table it won't let me edit data in the fields. When I select 'Open Table' and create the query that way, I can. The trouble is, I then can't save the query without saving that view of the table. In SQL Server 2000 I could edit fields in a query. Is there a setting in 05 I can use to make the query editable?Greg |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-24 : 11:38:30
|
| why are you not using query editor rather than open table?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
GregDDDD
Posting Yak Master
120 Posts |
Posted - 2010-02-25 : 14:46:34
|
| I think that is kind of the issue. When I use the query editor I can't edit fields. When I use 'Open Table' and then show the different panes (Diagram, Criteria, SQL) to create the query I can. The trouble is, I then can't save the query.For minor maintenance of data I sometimes need to go in a change the value of a single field in a record. I must recreate the query every time using the 'Open Table' because when I actually create a query that I can save and re-use, I can't edit the fields.Greg |
|
|
|
|
|
|
Edit Fields in a Query