Databases

31K

Answers

32

Articles & Videos

7K

Experts

Do you have database questions that don't seem to fit into specific categories? Ask them here! If the question doesn't fit elsewhere, it belongs here.

Hi There,

My Product data is coming form 4 different tables all linked by the unique ProdID.
ProdMaster (Holding product general information)
ProdLog (Holding the logistics information)
ProdIMG …

317 views

Background
What I'm presenting in this article is the result of 2 conditions in my work area:
We have a SQL Server production environment but no development or test environment; andWe have an MS Acc…

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

162 views

Needing to import SQL file into existing DB, Using MyPHPAdmin.
Need to over write existing data tbls from the import tab.

Also, found  " mysqlimport --delete database_name file.sql  " but not su…

3

With the help of flashback queries we have the option to look back in time to a certain state of a database, for example say we did some operation yesterday at 10 AM and today we want to go back to th…

169 views

Hi Experts
i am searching for a backup tools for SQL 2000 Data ( Free or Paid )

58 views

Note: You must have administrative privileges in order to create/edit Sharing Rules.

Salesforce.com (http://www.salesforce.com) (SFDC) is a cloud-based customer relationship management (CRM) system…

144 views

I have a ASP.Net application that retrieves data via AJAX from our Web API.

The data is a join of data from a denormalised table in a DW (80+ million rows) stored in SQL Server and data from a high…

318 views

Note: You must have administrative privileges in order to create/edit Roles.

Salesforce.com (http://www.salesforce.com/) (SFDC) is a cloud-based customer relationship management (CRM) system. It is…

296 views

Hi there

I host a website for a customer who wants to add a MySQL database to the site. We've created the database and populated it with the SQL but he cannot connect to the database. This is the s…

1215 views

Note: You must have administrative privileges in order to configure lead or case queues.

Salesforce.com (http://www.Salesforce.com) is a cloud-based customer relationship management (CRM) system. I…

346 views

I have a report which I need to link multiple tables to fields to pull the data I need.  I am linking general employee data table to a salary table, which holds supervisor names.  The need is to have …

1229 views

I got a requirement to export the table data into CSV file. The major issue was like the column values from the table needed to be transposed and used as a header on the flat file. The challenge was t…

2424 views

I've recently taken a job as an IT Director for a company with over 30 branches.  The previous IT guy left no information regarding hardware, software assets or even vendor information for the corpora…

424 views

I showed you how to use console view (HERE (http://www.experts-exchange.com/articles/18379/Getting-Started-and-Using-the-Salesforce-com-Console.html)) -– but how do you set it up on the admin side of …

358 views

Most what I found online deals with either Unix/Linux client deployment, or server side that involves database installation & configuration, I'm looking for neither, just a client side installation of…

210 views

Salesforce.com’s Console is a great tool to view activities, leads, contacts, accounts and opportunities all in one screen. It is particularly effective during call blocks and working numerous activit…

1527 views

I would like to make a select statement, where it will return the first record by the highest ID and also a count of how many total there are of that same "order number" Is this possible with SQL?

1228 views

Quite often, some product references (in a database) are combined from a textual prefix and a numerical suffix - like these values: AB123 and EF758...

Ordering them with a plain ORDER BY will be fi…

556 views

I have two SQL servers running a merge replication. The data is around 38GB in size and both sites are a high distance apart. The latency between the two sites is high. Both the publisher and subscrib…

417 views

Introduction

A commonly seen question in the database zones is "How do I find data that is in table A but not in table B?".  Anytime I see a question asked repeatedly, it seems to me that it would …

11,023 views

Experts:

I have a request from a user to display data from two tables in a one to many relationship in one row. The data looks like this:

Table Customer
CustomerID
Name

Table Shares
ShareI…

622 views

What is a Database Ghost?

A ghost table or query is an object disembodied from its host. The host can be a form, report or code. These ghosts do not rattle and knock about the database wreaking hav…

2,433 views

Hi!

We imported a MySQL database and, since in postgre there isn't Autoincrement options, we need to create a serial.

The thing is, the current exported id's doesn't allow us to change its type …

214 views

Let me first state that I am no expert when it comes to reference manager software.  I have used several different ones and have come to certain conclusions.  Further, I am in NO way associated with t…

2,645 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

TOP VIDEOS

view all
How Joins WorkHow Joins Work

Video bySteve Wales

162views

RELATED TOPICS view all

  1. MS SQL Server(152,422)
  2. Query Syntax(45,329)
  3. MS SQL Server 2005(71,234)
  4. MS Access(212,197)
  5. MySQL Server(45,257)
  6. Oracle Database(76,524)
  7. MS SQL Server 2008(46,662)
  8. PHP(115,113)
  9. Active Directory(68,727)
  10. Visual Basic Classic(161,984)