SqlDbx Forum

senthurpandian

Member

Modify table data needs improvement

Why dont you give it as "Open table" in Enterprise manager?

I mean, adding new row at the end?

I wonder how Microsoft enterprise manager is managing to edit a table data even if there is no primary key.
Do you have any guess?

Regards.

Last edited by senthurpandian (2009-11-08 08:33:54)

sqldbxhelp

Administrator

Re: Modify table data needs improvement

I am not sure how enterprise manager does, but
there's not a lot you can do differently.
Interestingly enough profiler trace does not show what executed.

FabricioAraujo

Member

Re: Modify table data needs improvement

I am not sure how enterprise manager does, but
there's not a lot you can do differently.
Interestingly enough profiler trace does not show what executed.

Don't know enterprise manager, but in SSMS I do imagine what they do.

Since it's dotnet, they look at datatable and simply insert the records that's marked as inserted. As for updates and deletes, I imagine they use all fields as keys...

senthurpandian

Member

Re: Modify table data needs improvement

Actually the request / suggestion is a new feature.

1. For example, if you copy a row (say, 1 row with 5 cols).
2. Go to the end of the table in Result Window.
3. Select Paste / Insert option.
4. Expected outcome: The new row in the clipboard to get inserted into the table.

(Instead of Imports, Just copy-paste) !

I really appreciate the feature that comes in the rt-click of table name in object browser to add a new row.

Best Regards.

senthurpandian

Member

Re: Modify table data needs improvement

I am not sure how enterprise manager does, but
there's not a lot you can do differently.
Interestingly enough profiler trace does not show what executed.

Don't know enterprise manager, but in SSMS I do imagine what they do.

Since it's dotnet, they look at datatable and simply insert the records that's marked as inserted. As for updates and deletes, I imagine they use all fields as keys...

Not exactly "all fields as keys", then, if you edit a row in a table with 5 identical rows, only one row edit will get updated, perfectly. They are using some internal principle (may be similar to rowid in oracle).

sqldbxhelp

Administrator

Re: Modify table data needs improvement

It is possible to do it the way SSMS or Access does it, but we choose not to do it.
In general we consider updating or inserting rows to be a dangerous operation,
so this is why we have "Insert New Row" option. In this case before you
insert  row you can verify that this is what you really want to do.