Databases

53K

Solutions

59

Articles & Videos

33K

Contributors

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 used to backup online database to local via MySQL Workbench.

Just wondering if there's any simpler way like "one click" method available to do so?

thank you.

1421 views
Netscaler Common Configuration How To guides
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

I have a stored procedure that works and pulls in Leads information.

I would like to pass in a CustomerID Paramater    (INT)

If null ... ignore

If it is an integer > 0

Add
WHERE …

745 views

I have a table that has this structure...

(CODE)

The most complex query I have is this.
(CODE)

The most common query is:
(CODE)

You can see in the DDL Info above that I have an index …

1427 views

I have the following table:

ID       NAME                               MGRID
8755  HARD HARRY                    0000    
8756  PETER GRIFFIN                 8755
8757  LOIS GRIFFIN            …

737 views

Working on a query. Here are the details:

Table: REQUEST
Columns: StartDate, EndDate, Type, Hours, Status, EMPLID

Table: ACCOUNTS
Columns: ID, FULLNAME, MGRID, EMPLID

I would like to:

1625 views

hi i have the following cursor in my 12c database
(CODE)

am geting the above error but in 11g is ok am running this in plugable database

530 views

hi,

I knew there are cheap product call MySQL and the open source DB called MariaDB, which is another MySQL, how about MongoDB ? what is this DB's rank/position in the market and what good is this…

1842 views

hi am having this error when starting my db
(CODE)

230 views

I have to join on a integer & character fields.
If I use the following, I get the error  'format or data has a bad character'

The payr_cust_nbr is an integer, is there anything else that I can …

217 views

I have two databases mounted on mysql server and fully connected to coldfusion server as datasources.

Pages work correctly, so no problem with databases.

DATASOURCE office_17 has a table …

1230 views
Microsoft Certification Exam 74-409
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

I am in a job where I sometimes need to make a "hot fix" to the live production database, and have been told we need to start using transactions to reduce the risk of causing a bigger problem than we …

925 views

Where can I find a tutorial on ServiceCenter IR Query expressions?  What language does service center use for IR Query?  I need to built a custom query for all tickets open for a primary assignment …

118 views

I have a query that has worked fine for a long time, but our database had a recent influx of new entries. I'm now getting this warning.
 Allowed memory size of 134217728 bytes exhausted (tried to …

627 views

I am average on Excel.

I have two spreadsheets i want to merge using a unique identifier - which is consistent on both spreadsheets.

Spreadsheet A has 3 columns
Unique identifier
Name
Address…

837 views

Hi Experts,

I am looking to place the contents of 6 fields into 2 fields as follows.

We have Date1 Column (Datetime) and Results1 column (varchar(50), then Date2 column and Results2, and Date3 …

1643 views

Hi All,

Is there any simple way to detect and resolve SQL server database deadlock ?
My custom application hangs and the developer suspect that there is deadlock in the DB which I must fix for the…

627 views

I want to get four query results, not two:

select count(*) as SecondYearInterestIsNo  from APSecondYear where SecondYearInterest='No'

select count(*) as SecondYearInterestIsNO  from APSecondYear…

229 views

my uncle has a private shop and and a small warehouse that stores shop assets, in FIFO basis. he has three employee that work in three distance locations and his business has been in decline and …

1035 views

I see a working query with the following select statement:

            SELECT
                  , hfext.Family_id, 0 IsAPStartMatching, MAX(ack.AgreedDate) StartMatchingDate
            FROM

what function does the '0' server …

526 views
Efficient way to get backups off site to Azure
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Hi Experts,

I have a table Named EmployeesLicenses

ID= int (PK)
EmployeeID = int
LicenseNum = varchar (50)
State = Varchar (50)
CurrentYN = bit

Now I want make a restriction that no more …

1682 views

I want to create a small application to be used as a Dashboard.
I have multiple databases (Same design) that I want to query, example one page could show everyone who signed in that day.
I can do …

525 views

I am using code first entity framework to create my database. My website is an educational website, where instructors can add assignments , their students solve them, then they'll be graded …

137 views

The AuPair table has a non-primary key called AuPair. APNo.

I am getting incorrect syntax.

Suggestions?

Thanks!

(CODE)

745 views

how to compare two NULL value so that if both are NULL then return true

431 views

Hi,

  I have this Windows 2008 R2 Standard server with 12G RAM memory installed, 64 bit version.    

  The server end up slow and using all the available memory, then i have to restart the MS …

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Microsoft SQL Server
    (157,586)
  2. Query Syntax
    (47,616)
  3. Microsoft Access
    (216,177)
  4. Microsoft SQL Server 2005
    (71,565)
  5. MySQL Server
    (46,539)
  6. Oracle Database
    (78,053)
  7. Microsoft SQL Server 2008
    (49,074)
  8. PHP
    (117,737)
  9. Active Directory
    (73,235)
  10. Programming
    (52,034)