![]() At the moment the statement looks like this: SELECT TOP (200) Id, SpecificationAttributeId, Name, DisplayOrder, Alias, NumberValue, MediaFileId, Colorįirst I remove "TOP (200)" because I don't want to edit the first 200 rows. This requires some basics in SQL, but don't worry, it's not very complicated. The SQL statement for loading the options is then displayed in the upper part of the window and I can change it to my needs. To do this, I right-click in the data window and select "Pane > SQL". But instead of the first 200 options I want to change the specification attribute "Farbe". ![]() In the data window that has opened, options can now already be changed. If 0 is entered, all rows or options are loaded. By the way, the number of rows loaded with this command can be changed by the option "Tools > Options > SQL Server Object Explorer > Commands > Value for Edit top Rows command". It contains the options of all specification attributes. By right-clicking on the table name I select the command "Edit Top 200 Rows". Next, I search for the SpecificationAttributeOption table in our database using the SSMS Object Explorer. I get the value either via the data table "SpecificationAttribute" or via the Shop backend under Catalog > Specification attributes > Farbe. The ID is the unchangeable primary key of a data record. The task is to change the order of all options of the specification attribute "Farbe" (color).įirst I need the ID of the specification attribute "Farbe". ![]() This way is illustrated in the following example. In general it is recommended to create a database backup in order to be able to restore the old data in case of accidents.īut there is another way: direct editing of database values using SQL Server Management Studio (SSMS). Such SQL statements can be executed without additional software using the shop backend (see System > Maintenance). In some cases data can also be directly inserted, changed or deleted by SQL (Structured Query Language). The general way to change shop data is either via the backend or via a data import. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |