Questions tagged [sql]

Structured Query Language (SQL) is a language for managing data in relational database management systems. This tag is for general SQL programming questions; it is not for Microsoft SQL Server, nor does it refer to specific dialects of SQL on its own.

SQL is an acronym, standing for "Structured Query Language" (not "Standardized"). Database interaction requires the use of SQL, and over the years - vendors have implemented extensions of SQL (such as tsql for SQL Server & Sybase, plsql for Oracle, plpgsql for PostgreSQL; there's no known tag for MySQL's extensions) to provide more functionality as well as simplify it. Because of these extensions, SQL is fractured - syntax that works on one vendor does not necessarily work on another. ANSI standards have been beneficial in resolving such situations, but adoption is selective. ANSI means that a query should be portable to other databases, but it doesn't mean that performance will be the same nor that performance will be on par with native functionality.

This tag should be used for general SQL programming language questions, in addition to tags for specific products (IE: Microsoft SQL Server, using the sql-server tag (ref)) that implement some flavor of this language. SQL is the umbrella under which these products exist; tagging them by product (including version, e.g oracle11g, sql-server-2008) is the easiest way to know what functionality is available for the task at hand.

48 questions
2
votes
1 answer

Simulating realistic latency to a WAN SQL server

Context: Our desktop application communicates with a SQL server, some clients use a WAN connection to reach this SQL server. When they complain something is very slow we ask a list of ping times to analyse the issue. After a developer fixed the…
Niels van Reijmersdal
  • 32,520
  • 4
  • 57
  • 124
1
vote
1 answer

SQL - data testing - Oracle 11g lookup tables

issue summary I need to use my client table to lookup name, address, etc my client table has 2 million rows, but only 167,000 unique clients, so I need to find the most current "max" entry for each most current entry is easy to find using a group…
Paul Ehrsam
  • 81
  • 1
  • 6
0
votes
1 answer

SQL how to seprate 2 words

INSERT INTO PartyTable (Name ,City ,Department ,Age ,Gender ,Transport ,Food ,Drink) VALUES ('Ido', 'Ramla', 'management', '17', 'M', NULL, NULL, 'Vodka' 'Water'); i need the vodka and water in same box when it displayed it show VodkaWater instead…