Databases-Other

31K

Solutions

54

Articles & Videos

7K

Experts

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Refine results

I've installed IBM SDK Informix 64-bit version (including the ODBC portion). However, I am unable to add an ODBC connection in Control Panel. Informix is simply not an option. Any idea?

1112 views
Course: AWS Professional Certification

These classes are designed to help you pass the AWS Certified Solutions Architect – Associate, AWS Certified Developer, and AWS Certified SysOps Administrator Associate exams—all essential to a career as an AWS professional.

Getting error on this UNION query. Can anyone help?

 


(CODE)

20 views

Hello, have Win7 64 bit PC's and using Act 2012. I think there may be a issues with running this version on Windows 7. One of the main databases they use randomly stops being shared and forces you to …

1722 views

Hi, I would like to know how to write a query that would search all the columns and replace the names.

Example per screenshot, I would like to do the following below. I am not sure if it is ideal t…

424 views

I have the following query:

SELECT SUM(Hours) AS 'Hours', RecordDate FROM Records WHERE UserID = 6187 AND RecordDate BETWEEN DATEADD(day, -14, GETDATE()) AND GETDATE() GROUP BY RecordDate

This …

1248 views

Hello Pros -

Hope you are doing well.

I am running into an issue with writing a query that will do current year comparison to previous year. In my code below it stores current year month for beg…

1120 views

Hi Experts,

I would like to configure SQL Server 2014 AlwaysOn Availability Groups Read-Only Routing in my project for bank domain servers. How can we configure the secondary replicas to allow read…

211 views

I am looking for a way to auto convert stored procedures from MSSQL to MySQL.
Found SQLWays, but haven't tried it yet.

Any experiences with any products that promise to convert stored procedures f…

221 views

Hi,
Our application is tied to a database on SQL server.  The application upgrade is failing because duplicate objects are detected in a table which share the same ParentID - these objects contain th…

1015 views

Is there a way to run a query on a table so it returns the column name, data type, lenght and value of first row ?

firmid |  int | 4  |  3
Name | nvarchar |  30  |   Lopez

To end up with somet…

728 views
Course: Foundations of Front-End Development

Jump-start a lucrative career in front-end web development, with zero previous coding experience required. This course covers the basic programming concepts and languages required for creating engaging websites from scratch.

Hello,

I need to export some data from Delphi in dbf files. The receiver application was made by Visual Foxpro.

Because I got the sample dbf files - just to be sure - I embedded them in the exe …

631 views

I do the following on both servers:
(CODE)

Then I do the following on the master:
(CODE)

I thought 'replicator'@'%' would have access from all hosts?

314 views

Can phpMyAdmin, running in the background in WordPress, be configured to the point that it functions as an API portal to an external Access DB?

215 views

I understand that in MySQL Semi-Synchronous replication, the transaction is not seen as committed before  a receipt is received back from the slave to the master given a certain time out period. Thus …

211 views

php localhost that can access sqllite on ios ipad.

I am doing a tutorial with a friend and want to use ipad. in another question;  I discovered xampp not supported on ios. please do not suggestion st…

515 views

Hi,

I would like some help on how to create a SQL query that would look at 'Category 1-9' columns and append the number according to the index listed below to the CategoryIds column separated by a …

931 views

Hi SQL Admins

I would like to ask you for professional recommendation and suggestions regards new MS SQL server setup.
My plan is to upgrade entire SQL system so it would be reliable and would hav…

1337 views

Hi Experts,

We have a table named facilitiestbl where it happened more then once a name of facility got changed (assuming on error).

Since we have besides of our FE app also a database where use…

1638 views

I am trying to create a Lessons Learned database with the following fields:

A record with a business unit, the name of the project, and the project manager
A date that corresponds to when the proj…

435 views
Course: JavaScript Coding - Massive 12-Part Bundle

Regardless of your programming skill level, you'll go from basics to advanced concepts in a vast array of JavaScript subjects including Sammy.js, Agility.js, Ember.js, Node.js, jQuery, AJAX, Extjs, AngularJS, Knockout.js, and JSON.

Hi,

when we use surrogate key in database world. what is its importance of it. please advise

625 views

We have an access 2010 database hosted on a windows 2008 R2 file share. We dont have any sort of admin access of the server itself to configure any sort of scheduled tasks. I wondered if there is any …

328 views



hi evryone,
i am very confused in this if you can help me

to evaluate the performance of an information retrieval system we use a collection of 15 documents and a request Q.
It is known that…

526 views

I can connect from local but cannot connect from my company.

I tried to use "telnet xxx.xxxx.xxx.xxx 3306" but got rejected. Is this the corporation firewall blocked my connection?

I am able to…

945 views

I need a SQL query that will convert output from a normalized database table into a denormalized table with one row per record with many columns.

What I have:

Invoice_Num     Emp_ID
A1234      …

1531 views

I have created an Access program for vacation system.

I have a table with Employee name, ID, hiredate, Starting leave balance, etc

I have one more table to enter EmpID, leave from, leave to,  le…

952 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

TOP VIDEOS

view all
How Joins WorkHow Joins Work

Video bySteve Wales

303views

RELATED TOPICS view all topics

  1. MS SQL Server
    (155,326)
  2. Query Syntax
    (46,835)
  3. MS SQL Server 2005
    (71,255)
  4. MS Access
    (214,532)
  5. MySQL Server
    (46,022)
  6. Oracle Database
    (77,504)
  7. MS SQL Server 2008
    (48,047)
  8. PHP
    (116,373)
  9. Active Directory
    (71,790)
  10. Programming-Other
    (51,580)