Articles & Videos
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.
I have the following numbers
Id FirstNumber SecondNumber
1 14978 15135
2 15135 15256
3 15137 15256
4 15154 15256
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…
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 …
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…
Piecemeal Restore/Partial Restore:
Note: All screenshots are applied to SQL Server 2012 Enterprise Evaluation Edition.
In my previous article SQL Server Storage Basics: Datab…
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…
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…
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 …
I wrote an article on ransomware (http://www.experts-exchan
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 …
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 …
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 …
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…
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 …
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 …
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.…
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…
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…
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…
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 -…
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
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…
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…
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).
Introduction: Often, when running a query with joins, the results show up "duplicates", and often, those duplicates can be "eliminated" in the results using DISTINCT, for example. Usin…
DATE and TIME ... don't be scared, just do it right DATE,TIME,MS SQL Server,MySQL,Oracle Introduction: I presume you all have already worked with databases and qu…
4,800 points this week
4,800 points this week
4,668 points this week
4,000 points this week
3,900 points this week