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 am trying to connect to an oracle database using access 2013
The ODBC Data driver can connect successfully to the data source see below.
But when I try to use this data source within…
we have an access 2010 application, with backend / frontend setup. When one of the analysts opens the master copy of the front end in design view, creates a query, saves it - when another user opens t…
Just need SSMS to install it on a server, without SQL Server installation. I was given the ISO from a co-worker, but seems like its the full SQL Server Install.
How can I install just the SSMS t…
I just installed SQL Server 2012 and configured it on a server. From the local server, I can connect. However, using SSMS from another server, I cannot connect to the SQL Server I created. I get the e…
Im searching for rows in a database where the date format can variate, depending on the date format in the end-users computer. How do i write a Mysql query from date to date that regardless of the com…
I have a working query that I would like to:
1. Break into 10 chunks (JSON)
2. Zip/compress each chunk
3. then return the whole 10 chunks as JSON
Can anybody help?
What is the best practice for backing up SQL?
Transaction logs should be backed up often, but hourly, 15 minutes?
What other logs or image levels and how often?
Are there any guideline…
Can you make an ODBC link to SAP and pull data into access?
IF it is possibly, can you explain how to do it?
I need to report on date of death. I think it goes into a fact table since it's something that has happened. But what if the date of death is null? How would I populate it. I don't want a null in fac…
I have a successful connection and data pull, but I do not get the headers.
Can someone help with with the code to pull the headers into excel row 1?
I am trying to get the size for a particular Database in one of the the SQL Servers using SSMS. I goto the Database --> Reports --> Standard report and Disk usage... I am getting this error: " Index (…
I have a large Excel file with about 9000 lines of data. The data on the sheet is formatted similar to this, but repeats with different names:
I need to change this to a format similar to this:…
I even have SQL_MODE = 'STRICT_TRANS_TABLES' set, hoping I'd find some cause.
I can't find any reference to this in my search so far.
Any suggestions on what to look for?
I'm using My…
Hello Experts -
I am stuck with this script I am writing. I am trying to write a script in python that will grab all tables from sourcedb (access db) and insert into each table in destdb (access db…
I have exported Website data from Wordpress into a Linux LibreOffice Calc file in CSV format (which cannot be opened with Calc), and then imported that CSV data into the hosting database using PHP M…
I hear db2 can't snapshot... we just have to live with the fact that during backup some oprations (like changes to tables) might hang.... Is this true?
I'm working with a legacy piece of software, and it appears that it contains data in a bunch of .mkt files. All of the boilerplate file extension websites say that mkt files are associated …
I have a table with field names "0616" "0716" "0816" etc for 24 months. These fields contain numbers.
I also have a field that gets todays date and translates it to "0616" or "0716" etc.
I need a C…
I'm trying to figure out this design.
I have a count measure "Count(ids)" in my fact table. I also have the standard date dimension which is joins up to fine. I'm trying to figure out where to …
is the dynamic memory concept for sql server…
Looking for a system to track equipment (in this case IT department items).
I know its a wide open question; just want to know what you use and why, cost, pros and cons on what your using, etc
I currently store all of our users passwords in our database using AES encryption with unique salt per user combined with a site specific encryption key.
I'm looking at increasing our se…
I'm in a bind with our application upgrade. It's failing due to collation conflicts in the database. I analyzed our MSSQL collation properties by instance>database>columns and uncovered…
Hello Experts -
A previous expert was able to help me generate the below query that will look for all the stores in our company and display data that adds two separate years together.
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…
2,001 points this week
Hamburg Bramfeld, Hamburg, Germany
2,000 points this week
2,000 points this week
1,600 points this week
1,027 points this week