SqlDbx
You are not logged in.
Pages: 1
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)
Offline
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.
Offline
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...
Offline
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.
Offline
sqldbxhelp wrote: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).
Offline
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.
Offline
Pages: 1