Databases-Other

31K

Solutions

50

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 have the following numbers
Id    FirstNumber   SecondNumber
1          14978          15135
2          15135         15256
3         15137           15256
4         15154           15256
5        …

1672 views

The problem
Entity Framework (EF) allows us to import Stored Procedures (SPs) since its first version, but there are still some missing features.

The specific problem here is when you have a SP th…

0123 views
How Joins Work

Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with …

0242 views

The following segment within a sub runs! (good news)
However, I am not finding a way of closing Excel afterwards.
1) I can see multiple instances of Excel running in Task Manager: Processes
2) I am as…

725 views

Piecemeal Restore/Partial Restore:
 
Note: All screenshots are applied to SQL Server 2012 Enterprise Evaluation Edition.
 
1. Introduction:
In my previous article SQL Server Storage Basics: Datab…

0444 views

I copied the below code from another EE page, but I get error 2501 "The OutputTo action was canceled." What's wrong with the code?

Public Function SendEmailWithOutlook()

'Created by Helen Feddema 17…

535 views

To enter a date is tricky
The Date Picker is a safe method to always ensure valid dates to be entered without noisy error messages disturbing the user. However, for many scenarios like accounting and…

9448 views

I'm having an issue microsoft hotfix 363521 .

Access 2007 front end  doesn't open menus correctly.  

we would like to use and the hot fix.

is there another workaround for this before upgrading to …

729 views

I wrote an article on ransomware (http://www.experts-exchange.com/articles/20879/Ransomware-is-rampant-don't-be-caught-out.html) not too long ago, and while I was writing it I tried to keep track of a…

4728 views

I have a client with a database application he wants to look into selling.  It's been pieced together over the years and definitely time for a re-write. I doubt I would be the one to do it, but in an …

525 views

Note: All screenshots apply to SQL Server 2012 Enterprise Evaluation Edition.
 
1. What is Filegroup:
In SQL Server a filegroup is a logical structure that contains objects like data files, tables …

0179 views

Hi


I have an ODBC connection setup to by SQL server 2005 database –
ODBC name is ‘TEST_Database’
Server name is ‘Test_Server’
I have a user ID and password on this (user id of ‘user1’ and password …

128 views

The SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute…

0352 views

Tools: DB2 on iSeries and VBA in Bartender barcode software

I am creating catalogs for customers using data gathered via DB2 SQL and Bartender for printing. These items are grouped by category and I …

942 views

In this article I am going to show how we can use and utilize SQL Workshop before we start developing any web application using APEX. In my earlier articles I have shown how to install and upgrade to …

2220 views

Hi Experts ,

I need help in the SQL statement of Ms Access 2013.

It will query by using SQL
statement through searching
records in table(tblChanges) and tblDates(with dates pre put say 1/9, 2/9,3/9.…

2546 views

GoldMine CRM Distribution list retrieval.

Have you ever needed to pull a list of the email addresses used in a GoldMine distribution list?

Here I will detail how to achieve this within SQL. If y…

13,109 views

I have an access front-end to a SQL server database.

To create a new record the front-end runs an INSERT statement in VBA.  But this statement hangs if another user is editing the table.

I think I n…

8128 views

I work in a laboratory and would like to create a data entry form to inventory specimens. Each specimen will be stored in a freezer box. This box contains 81 positions to store unique specimens. All 8…

3357 views

In the attached VBA code, I don't understand what is happening. I seek a record (successfully) and then go into .edit mode, move correct data into the  .fields, then .update the record being updated -…

495 views

hi i have a excell spreadsheet which got about 25 rows how can i create database table based on this spreadsheet am in oracle database 11gR2 am using pl/sql developer IDE

936 views

Hello:

At my work our surgeons digitally record a lot of their surgeries.  One of the doctors would like to have a system where he has all of his patients in a database and be able to sort with speci…

1190 views

Why does a Form open from Design View, but not directly from the Navigation pane or from code?  When I try to open it from the Navigation window or from code, Access freezes (or goes into a loop, I ca…

375 views

Hi and thanks,

I am very new to all this.

I would like to:

Determine what databases/tables are being accessed/updated within a project.

Apparently there is no documentation yet on the project(s).

6331 views

I'm stuck and I NEED the mongo drivers installed. I'm a reseller so I have WHM access and cpanel access to the server as well, so how do I install the mongo drivers?

31,763 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

TOP VIDEOS

view all
How Joins WorkHow Joins Work

Video bySteve Wales

242views

RELATED TOPICS view all topics

  1. MS SQL Server
    (154,726)
  2. Query Syntax
    (46,107)
  3. MS SQL Server 2005
    (71,598)
  4. MS Access
    (214,083)
  5. MySQL Server
    (45,810)
  6. Oracle Database
    (77,163)
  7. MS SQL Server 2008
    (48,098)
  8. PHP
    (116,185)
  9. Active Directory
    (71,027)
  10. Programming-Other
    (51,630)