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. …

820 views
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

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…

317 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. …

1417 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 …

823 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…

107 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…

411 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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

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…

422 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…

1537 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…

320 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.

628 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…

1239 views
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

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…

221 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 …

548 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…

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

TOP EXPERTS

view all

TOP VIDEOS

view all
How Joins WorkHow Joins Work

Video bySteve Wales

356views

RELATED TOPICS view all topics

  1. MS SQL Server
    (156,018)
  2. Query Syntax
    (47,079)
  3. MS Access
    (214,893)
  4. MS SQL Server 2005
    (71,383)
  5. MySQL Server
    (46,172)
  6. Oracle Database
    (77,630)
  7. MS SQL Server 2008
    (48,407)
  8. PHP
    (116,768)
  9. Active Directory
    (72,103)
  10. Programming
    (51,752)