sql

In the loop, the following function is executed twice in a row: function CodeToURLImg($code) { $sql_catalog = 'SELECT Im ... etcat/full.php(127) : eval()'d code on line 121 Both times, the same value was passed to the function. How do I fix this?

When reading the legacy code, I found an SQL query to MySQL of this type: INSERT INTO table (field1, field2, field3) V ... just redundant code that can be cleaned up and brought to either the standard variant (1) or the MySQL-specific variant (2)?

Can you please tell me how to display on the page in the table not the id, which is in the database, but the value itself, wh ... ators` WHERE data_id_station = '".$_GET['id']."' Can you tell me how to correctly output the data, and not the id? Base:

Good afternoon! Are there any tools for automated database testing on MSSQL? For example, projects for Visual Studio (the templates of which I did not find in the studio itself)? Share your experience and links. Thank you in advance.

There are three tables: Orders, information about the service (service) and the performer (employee). Employees, informa ... ORDER BY Employees.employee_name; ) AS B; WHERE B.sum > AVG(B.sum); ORDER BY Employees.employee_name;

The task is to normalize (0-1) the order stack in stock trading. In the glass, I can only see the 25 best price offers, i.e. ... base for normalization? And if so, how?(Orders are quickly canceled/appear and it is not clear what data should be recorded)

I need to log postgre tables whose records do not have timestamps, so that I can get statistics on them in the future. I solv ... in the same order as the columns of the table. The question is, will the order always match, or are these some special cases?

There are three tables linked one-to-one by ID. I need to delete all records from three tables that satisfy the condition: A. ... D LOOP; COMMIT; END; There is a lot of data and so it works for a very long time. Is there any way to make it faster?

Hello everyone There was such a problem: there is a database with such a scheme: You need to create 3 roles: Full access ... as well as built-in functions and triggers through the database roles. SQL Server Version 13.0.5026.0 2016 Developer Edition

There are 2 tables: "PS" "S" How do I fill in the "UserId" column in the "S" table based on the data from the "PS" table? I ... "userID" so that "PS"." SubscriptionId " = "S". "id". You must actually fill in the table " S " The result I want to get:

There is a machine with Windows XP. As far as I know, you can install the SQL Plus console without Oracle SQL Developer and without Oracle at all on the machine. How do I do this?

I use the Code First approach, I want to make a simple model of an online store. I want to use the Product, Client, Order ent ... cts { get; set; } public DbSet<Client> clients { get; set; } public DbSet<Order> orders { get; set; } }

There are two tables Tab1 | id | time | Tab2 | id | id_tab1 | value | You need to partition both tables, in the first table ... tially, only the section in which I will change the ranking range will change, or will the entire table be partitioned again?

CREATE TABLE IF NOT EXISTS `book_shop`.`Book` ( `ISBN_BOOK` VARCHAR(20) NOT NULL, `YEAR_BOOK` YEAR NULL, `TITLE_BOOK` VARCHAR ... de: 1005. Can't create table book_shop.shoppingbaskets_have_books (errno: 150 "Foreign key constraint is incorrectly formed")

When writing various procedures, I ran into the problem that when I try to define a column with the data type BLOB in a priva ... ors, it works like this. Free translation How to define BLOB column in Private Temporary Table? from member @Gregor Cerinšek

There is a database with two tables. The first table shows information about the books. The second table contains a list of b ... will output a list of all publishers and for each publisher will output the book name of that publisher with the most pages.

The question is theoretical, if during the session in the Oracle database I made a transaction, such as insert or update, and ... . Can I return everything to its original state, such as Undo or Rolback. I would like to know the opinion of Oracle experts.

Table 1roller id | type_roller | name_file | filepath | time_start | time_stop | period | user_id | tc_servers | timeRolik Ta ... oller_priority user_id == user_id id == roller_id Based on this, glue the priority column to Table 1 and sort Table 1 by it.

Hi everyone. You need to get the ResultSet from such a procedure: exec ais_disp.p_lk.p_add_client (v_sis_id => 1640, ... ommit; How to cram this into java code? I tried using CallableStatement, but I can't insert select from the procedure there.

User Table: users ---------- `id` int(11) `email` varchar(55) `login` varchar(55) And the order table orders -------- `id` i ... to display a list of login's-users who have made more than two orders. is it possible to do this with a single SELECT query ?