Databases

53K

Solutions

54

Articles & Videos

33K

Contributors

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

Any advice or tool suggestion is helpful and will get points!

I'm currently in an IT services role where I'm creating client facing statements of work that are composed of various blocks of steps. …

823 views
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

I'm trying to write a query with the following code:

left outer join APVENMAST on PROCUREGRP.VENDOR_GROUP=APVENMAST.VENDOR_GROUP and POVARGMTHD.VENDOR=APVENMAST.VENDOR

But get the following erro…

320 views

I have an existing Oracle database on a server that I need to copy to a new server. The old server is running version 11g Release 11.2.0.1.0. The new server is running version 12c Release 12.1.0.2.0. …

1524 views

I have a table in SQL Server with a number of fields, i have created a composite PK of LoanNumber, BorrowerName, LenderNumber; I need to compare a new data set that contains these and other fields to …

824 views

I have 2 tables, tbINVOICE and tbFEE. tbFee contains fees that get populated at the end of an invoice. As a result of a setup error, I have some invoices that are missing a fee that should have been a…

1010 views

Hello!

I use Ubuntu 14.04.1 Desktop and in PhpMy Admin I see this:

Database client version: libmysql - 5.5.50

But when I do this in the terminal:

mysql -V

I get ver. 5.5.52

Also in S…

412 views

I want to create a spreadsheet that only has a few drop-down boxes or text fields where a person can select their name from the list, enter their data and have it automatically added to the sheet that…

1235 views

I have a c# asp.net application. Related to this application  I have a complex query that gets data from  a remote database,  call it query-remote. I need to place all of the query-remote results from…

3238 views

My client uses an application called Amazing Charts.  We recently had them upgrade the SQL software from 32-bit to 64-bit as the performance was taking a hit.  They have a MS database that all the com…

1032 views

Hi Everyone,

Any assistance would be greatly appreciated. BIG THANKS!!!

Delete items that are no longer available in the database:
1) I would like a query to compare the 'Item Number' column fr…

1637 views
 Java Android Coding Bundle

Whether you're an Apple user or Android addict, learning to code for the Android platform is an extremely valuable, in-demand skill. It all starts with Java, the language behind the apps and games that make Android the top platform it is today.

I am copying information from one table to another. There is one field which is an nvarchar and should in fact contain dates in the following format:  mm/dd/yyyy  or mm/dd/yy
I am going to copy that…

423 views

I read a little bit in internet but I'm not sure to understand what ISQL? Is it like an ODBC driver forLinux?

650 views

We have 'MySQL Workbench' v6.2 and want to access MySQL databases hosted in other remote web locations.  How can we do this?

417 views

I have a table "AccountNumbers"  In this table there a 4 fields, ID, OriginCountry, DestinationCountry, AccountNumber
I also have a table of Countries  with 95 records (all the countries)

I need t…

1538 views

We have two contact forms, billing and contact. I am going to store recipient emails into a database so the manager can configure who she wants to receive emails.

Should I have a table called billi…

321 views

A vendor has asked me to create an extract file.
In this extract file, certain fields need to be in a particular position.
For example:
Employee Position 1-8
Employee First Name Position 9-26
Emp…

440 views

Hi,

How do I change all highlighted to D: drive in SQL with one query.

629 views

CONFIGURATION:
SQL 2014 Enterprise installed on Server 2012 R2
8 cpu core's & 24 gb mem
SQL instance is dedicated to ONE application database.  DB is 210 gb in size.
6 tempdb’s spread across C:\, …

681 views

I have quickbooks point of sale on one computer installed it on another computer and want to use quickbooks on this computer as well.

When I open quickbooks a window opensasking Specify your serve…

1240 views
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Heyas,

I will be involved in a migration event from our SQL servers our local office to a data centre and I have been asked to create a list of health checks. Other than creating lists of current u…

222 views

I have a table with an order and many details, and a second table with all the items on the order.
The order number ties them together.
Right now I have to run the order, with the total of all items…

634 views

hi,

I am going to buy this:

SQL and Relational Theory: How to Write Accurate SQL Code:

https://smile.amazon.com/gp/product/1491941170/ref=ox_sc_act_title_1?ie=UTF8&psc=1&smid=ATVPDKIKX0DER

1245 views

I am working with a large .csv file (about 8 gigs) that I exported from a database.  When I try to open using CSV edit, I get an error "file is empty".   Does anyone know if there is a maximum number …

549 views

I am getting an error "Corresponding select-list expressions are incompatible.
Can anyone tel by looking at this?

(CODE)

821 views

hi all,

I have a couple of SQL 2016 databases:
1st database is the production SQL database - called PRODUCTION
2nd database is the test database called PRODUCTION_TEST

I can backup the databas…

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

TOP EXPERTS

view all

TOP VIDEOS

view all
How Joins WorkHow Joins Work

Video bySteve Wales

357views

RELATED TOPICS view all topics

  1. MS SQL Server
    (156,033)
  2. Query Syntax
    (47,087)
  3. MS Access
    (214,902)
  4. MS SQL Server 2005
    (71,388)
  5. MySQL Server
    (46,177)
  6. Oracle Database
    (77,634)
  7. MS SQL Server 2008
    (48,409)
  8. PHP
    (116,779)
  9. Active Directory
    (72,114)
  10. Programming
    (51,760)