Search results
Consult this SQL Server error code list (between 1000 and 1999) to find explanations for error messages for SQL Server database engine events.
Consult this SQL Server error code list (between 10000 and 10999) to find explanations for error messages for SQL Server database engine events.
Consult this SQL Server error code list (between 19000 and 20999) to find explanations for error messages for SQL Server database engine events.
MariaDB shares error codes with MySQL, as well as adding a number of new error codes specific to MariaDB. An example of an error code is as follows: SELECT * FROM x; ERROR 1046 (3D000): No database selected
9 mar 2023 · Get detailed explanations, causes, and user actions for the top 25 most common SQL Server Engine errors!
error: 1099 sqlstate: hy000 (er_table_not_locked_for_write) Message: Table '%s' was locked with a READ lock and can't be updated 1000 - 1049 1100 - 1149
5 wrz 2008 · The simplest way to do this is use a table alias when you are referring parent query table inside the sub query. Example : insert into xxx_tab (trans_id) values ((select max(trans_id)+1 from xxx_tab)); Change it to: insert into xxx_tab (trans_id) values ((select max(P.trans_id)+1 from xxx_tab P));
