Databases

53K

Solutions

57

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

Hi,
Is there anyway to see which database connections (SQL Server) are opened on machine?
E.g. If I open an application and now want to see in the background which database connection it is using ma…

826 views
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

I am trying to access the file which is M: drive ( network drive ) its access data base file.

When i try to open it, its giving me error with w: and the error it cannot be specified
Even i dont h…

1411 views
Password security

Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringing your solution beyond military grade security.

043 views

Hello,

What is wrong with this?


BEGIN TRANSACTION
UPDATE tn
  SET tn.[NC_HIST_POST_1] = SubQuery.[2015]
  FROM PS_NC_BUDG_STG_UPL tn  JOIN (
 SELECT *
  FROM (
 SELECT ACCOUNT
 ,…

39 views

HI,
In one of the mysql server when i run the query : select @@version;
The output is : 10.0.17-MariaDB-log
On other the output is :
5.6.23

What does these different mean ?
I am using these t…

216 views

I had this question after viewing Need Distinct Value from Joined Tables in MSSQL (https://www.experts-exchange.com/questions/28985927/Need-Distinct-Value-from-Joined-Tables-in-MSSQL.html).

With th…

612 views

I have a sql statement that is pulling the information I need from the DB (joining 4 tables), except it is pulling duplicate values and I need distinct. I've tried several ways and cannot get it to pu…

522 views

Hello,

I would like to know which RAID is better for a simple Oracle Standard database.
One schema with its own DATAFILE and INDEX.
OS : MS Windows 2012 R2 or MS Windows 2016 or on a Linux Debian…

412 views

I have some MYSQL code that looks like this:

 (CODE)

Now i want to change this code into something like

(CODE)

But i cant get it to work. I do prefer to use SET because when i have many ro…

625 views

I'm trying to create an aggregate table using the combination of two others.

Feed Table A:

(CODE)

Expected Result (Table B):

(CODE)

In record 1, 80 is the most recent record, 75 is the …

2434 views
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

I have received a copy of a SQL Anywhere 11 database, which I beleive is now SAP, whereas previously was sybase SQL. The extension is just.db. I have been given a version of SQL Anywhere 11, but its n…

127 views

Hi Everyone,

We are a growing company with approximately 50 users in total. (A head office with 20 users, the remaining 30 or so  work out of one of three remote offices.. a couple users work from …

5109 views

Hi All Website Guru's

Our business of 50 employees, like any business, has through the years generated many many 1000's of documents and files: Word docs, Excel Files, PDF'S, Photos, Photoshop File…

246 views

Please experts

any example about: Partially Contained Databases - Cross Database Queries

320 views

I have a couple of tables in a database that are using the LONG data type. It's a horrible data type and we need to get rid of it. The question is what do I replace it with? I've narrowed it down to L…

624 views

Hi

We are trying to install MyCalls software by NEC, version 4.6.0.4 (MyCalls_SV9100_4.6.0.4_Live) which supposed to install its own SQL database. The only problem is that the installation keeps fa…

2240 views

I need to host a genealogy website and wonder if there are any existing tools of libraries I can use for this?

I have some surprising relationships amongst our political elites I'd like to display …

234 views

hi am in oracle 12c database am geting this error

C:\App\product\12.1.0\dbhome_1\NETWORK\ADMIN>sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Sun Nov 20 10:53:20 2016

Copyright (c…

838 views

I am trying to connect an existing database to NetSqlAzMan (Console Root) but get an error showing that my SQLEXPRESS instance needs configuration for multi-user access.



I ran the script which …

429 views
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Let me preface this.  I need to know why it is not working, not that its not suggested i do it this way.  This method of switching works best for my user group.

Access 2015.  SQLExpress 2014 (This…

529 views

I have a C# application that I want to have connect to a local DB that is going to be located in a specific path on the users system.  The application runs fine if I have it pointed to the full SQL Se…

2356 views

Currently Inherited a mess of a data center Rack, cables all over no room for ventilation, is there an online affordable company that i can transfer all my databases too for 2 weeks to reconfigure wir…

445 views

hi am in oracle 11R2 how can i make my report to print in one page for example
 
 
 
 
page 1
value *********************************************
value3 ****************************************…

234 views

Hello all,

I started this account because I've just started learning SQL and it's not going as smoothly as I'd hoped (does anything?)

So I've downloaded MySQL Server 8.0 and I'm trying to get st…

236 views

hi i have a report in 11g is returning null but when i test  the report query in sqlplus is returning everything what could be the problem

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS SQL Server
    (156,655)
  2. Query Syntax
    (47,285)
  3. MS Access
    (215,521)
  4. MS SQL Server 2005
    (71,484)
  5. MySQL Server
    (46,351)
  6. Oracle Database
    (77,856)
  7. MS SQL Server 2008
    (48,736)
  8. PHP
    (117,251)
  9. Active Directory
    (72,632)
  10. Programming
    (51,874)