How to parse XML data in SQL server table
There are many tutorial articles about xml parsing with TSQL. For example, http://www.sqlserver.info/syntax/parse-xml-with-sql-server/
Database
How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
One easy trick that can help with most deadlocks is sorting the operations in a specific order. You get a deadlock when two transactions are trying to lock two locks at opposite orders, ie: connection 1: locks key(1), locks key(2); connection 2: locks key(2), locks key(1); If both run at the same time, connection 1 … Read more
How to store arrays in MySQL?
The proper way to do this is to use multiple tables and JOIN them in your queries. For example: The person_fruit table contains one row for each fruit a person is associated with and effectively links the person and fruits tables together, I.E. When you want to retrieve a person and all of their fruit … Read more
java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
As you are creating a database from scratch, you could use: Here is an identical scenario.
SQL Server reports ‘Invalid column name’, but the column is present and the query works through management studio
I suspect that you have two tables with the same name. One is owned by the schema ‘dbo’ (dbo.PerfDiag), and the other is owned by the default schema of the account used to connect to SQL Server (something like userid.PerfDiag). When you have an unqualified reference to a schema object (such as a table) — one … Read more
how to overcome ERROR 1045 (28000): Access denied for user ‘ODBC’@’localhost’ (using password: NO) permanently
for some reason, the ODBC user is the default username under windows even if you didn’t create that user at setup time. simply typing without specifying a username will attempt to connect with the non-existent ODBC username, and give: Error 1045 (28000): Access denied for user ‘ODBC’@’localhost’ (using password: NO) Instead, try specifying a username … Read more
Oracle “SQL Error: Missing IN or OUT parameter at index:: 1”
Based on the comments left above I ran this under sqlplus instead of SQL Developer and the UPDATE statement ran perfectly, leaving me to believe this is an issue in SQL Developer particularly as there was no ORA error number being returned. Thank you for leading me in the right direction.
ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying
Ok, well, since you didn’t show any code, I’ll make a few assumptions here. Based on the ORA-1461 error, it seems that you’ve specified a LONG datatype in a select statement? And you’re trying to bind it to an output variable? Is that right? The error is pretty straight forward. You can only bind a … Read more
ORA-28001: The password has expired
I have fixed the problem, just need to check: and then check: and then use: