Articles & Videos
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.
Lets say you have a table called test with the follow information
firstname lastname gender email
steve jones m [email protected]
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…
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 …
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…
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…
I have the table solicitudes
| enterprise | state |
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 …
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.
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…
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?
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…
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…
Note: You must have administrative privileges in order to create/edit Sharing Rules.
I have migrated http://18.104.22.168/ulst
Note: You must have administrative privileges in order to create/edit Roles.
I would like to request an assistant.
Let say i have the following tables :
Table Name : tblhostingconfigoptions
relid | configid
------------- | ------------
Note: You must have administrative privileges in order to configure lead or case queues.
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. …
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…
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…
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…
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"
It tells me i need a logon user interface ddl msgina.ddl how do i get this
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 …
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…