Ever get the following error? Cannot resolve the collation conflict between “Latin1_General_CI_AI” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation. I had separate databases on different servers that I needed to query off of. In my case, it was a join between a table on the local server and a table …
As we all know, one of the best ways to prevent SQL injection attacks in PHP (or any server side language for that matter) is to use parameterized queries. But how do you parameterize a WHERE … IN clause? One way is to use a user-defined function. The below example …
Here’s a method of generating a dynamic pivot of a dataset. It first generates the columns as a string (“[ColumnHeader0],[ColumnHeader1],[ColumnHeader2], …” format), builds a dynamic SQL string and executes it using the PIVOT expression. From the code below, the @cols variable is generated by using the FOR XML PATH expression. …
If you’re having issues with locks in Oracle, here’s a way to show what sessions have locks on which objects. select s.osuser “O/S-User”, s.username “Ora-User”, s.sid “Session-ID”, s.serial# “Serial”, s.process “Process-ID”, s.status “Status”, l.name “Obj Locked”, l.mode_held “Lock Mode”, count(*) from v$session s, dba_dml_locks l, v$process p where l.session_id = …