Databases

31K

Solutions

36

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.

Refine results

Lets say you have a table called test with the follow information

firstname      lastname      gender          email
steve               jones            m                   [email protected]  
ste…

2

Why snapshot as backup-strategy?
When working with large to huge databases it is critical to take a backup of the database for disaster recovery and data failures that application either cannot recov…

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

169 views

I am building a query in MSAccess 2013. I have a Table containing the names of documents, and a different Table containing the path these Documents reside in. I would like a query that concatenates th…

411 views

Note: All screenshots applied for SQL Server 2012 Enterprise Evaluation version

SQL Server Logins
In this part we will try understand each & everything related to logins so let’s move ahead to exp…

2335 views

I have the table solicitudes

-------------------------------------------------------------------
|         enterprise                               |      state      |
|--------------------------…

5

A short introduction on Oracle Apex: 
Oracle Application Express is mainly used to develop Web based applications with SQL and PL/SQL. The Web-based applications can be developed using a web browser …

258 views

How do I safely reduce the size of my SBS 2008 SBSdatabase? I received an error when I ran my SBS 2008 Best Practices Analyzer.

Thanks.

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

821 views

is there a way to replicate / "copy" the SQL server import feature of SQL server management studio? this way you can let an end user without SQL server management studio import data to database?

i.…

1324 views

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…

427 views

Hello,
Does the SQL Developer tool have a way of applying a "column ruler" at the top a a SQL statement?
When I create a statement and it has some error; the tool gives me a line and column.  The li…

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

307 views

Hi Guys,

I have migrated http://91.109.247.179/ulster to http://ulsterbankstudentdaze.com/ and how i did that was i downloaded the database at http://91.109.247.179/ulster and imported to database …

1

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…

480 views

Hi,

I would like to request an assistant.

Let say i have the following tables :

Table Name : tblhostingconfigoptions

relid         |   configid  
------------- |   ------------
  1      …

9

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…

527 views

I have a SQL Server 2012 express addition with many databases that the log files have not been backed up in a long time.  One log file is 1.1 TB.  Anyway, after I backup the databases and log files.  …

718 views

I have 2 databases  SqlServer and PostgreSQL  and have a need to be able to backup  the databases from within my Visual Basic  6 application

I have sucessfully backup the Sql Server but the PostgreSQ…

1338 views

I have a function that does an ASCII check and it cleans a string and returns all the ascii characters back. I have symbols(?) that are being returned now that have an ascii value but I definitely don…

56 views

Im using SQL Developer and I have a function that cleans non ascii values from strings but when there is an & in the name being cleaned, it prompts me. I know that if I run the function with SET DEFIN…

59 views

Experts,, I want to concatenate EST or CST  in Bid_Open_DateTime based on a value that comes in Office column

if it is crystal falls in office ..then I should show bid open date time + "CST"  
ot…

410 views

It tells me i need a logon user interface ddl msgina.ddl how do i get this

611 views

Hello,

I have two tables and I need to join them using SQL MS query without repetitions from oracle Database,
Table 1 : Has Customer Payments
Customer,Month,Year, Payment Amount

Table 2 : Has …

1116 views

I have the following query that works, but doesn't provide the desired output.  As you can see I'm getting the data for company_id 2, 7, and 11 and ordering by the post_date.  The problem is that if s…

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

TOP EXPERTS

view all

TOP VIDEOS

view all
How Joins WorkHow Joins Work

Video bySteve Wales

169views

RELATED TOPICS view all topics

  1. MS SQL Server
    (152,807)
  2. Query Syntax
    (45,499)
  3. MS SQL Server 2005
    (71,309)
  4. MS Access
    (212,605)
  5. MySQL Server
    (45,371)
  6. Oracle Database
    (76,671)
  7. MS SQL Server 2008
    (46,935)
  8. PHP
    (115,323)
  9. Active Directory
    (69,202)
  10. Visual Basic Classic
    (162,173)