Databases Scripts & Automation

Greetings AllI have a project that has requested the IT support team in to allow a file in Sharepoint to access data on an On...

I know we should be off SQL 2012.  We do have a replacement scheduled, and are in the process of migrating. In the meantime, ...

Is is possible to work through a myslq field which contains a few H2 tags and change  the first occurence of an h2 into an h1...

I’m trying to write a query and I just can’t wrap my head around it. I want to create a query that builds a HouseholdName val...

I understand it is really old but I really need to install the Service Pack for Crystal Reports 11 R1, not R2.  We use CR11 R...

I have already worked in Oracle.  Now I have a postgres DB, I wrote merge statement but I get two errors  1. first null ...

I have a new installation of latest MSSQL Express, but for some reason I can't access it on 1433 port. The version of Express...

Has anyone used Udemy for  training courses?VmwareMS SqlOracle Anything really ,did you like it ?Pros and con pleaseDid you u...

Hi,I currently use MySQL as the database solution for my product; however, recent problems have prompted me to research a mig...

Hello people!I have a query i was building and it's working well so far. It's a query with two PIVOT. I am trying to replace ...