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

Can vcenter 6 be installed and used with SQL 2012?

As of right now, vcenter is using the default (postgres) I believe DB that was installed during the vsphere 6 install.

Update_Manager and SRM w…

10 views
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

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

840 views

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…

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

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

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

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

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

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

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

1034 views
Product Review - Android Remix

Come along for the ride with our Senior Product Manager, Brian Matis, as he reviews the Android Remix.

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…

1638 views

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…

424 views

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

653 views

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

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

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

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

442 views

Hi,

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

631 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:\, …

683 views
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

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…

1241 views

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…

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

635 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

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

551 views

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

(CODE)

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

TOP EXPERTS

view all

TOP VIDEOS

view all
How Joins WorkHow Joins Work

Video bySteve Wales

358views

RELATED TOPICS view all topics

  1. MS SQL Server
    (156,050)
  2. Query Syntax
    (47,091)
  3. MS Access
    (214,923)
  4. MS SQL Server 2005
    (71,390)
  5. MySQL Server
    (46,180)
  6. Oracle Database
    (77,640)
  7. MS SQL Server 2008
    (48,414)
  8. PHP
    (116,792)
  9. Active Directory
    (72,127)
  10. Programming
    (51,761)