144:
The minimum level of conformance to SQL:2008 that a product can claim is called "Core SQL:2008" and is limited to definitions specified in two parts of the standard: the
Foundation and the Information and Definition Schemas.
178:
582:
129:
34:
572:
175:
198:
243:
154:
24:
577:
51:. It was formally adopted in July 2008. The standard consists of 9 parts which are described in detail in
419:
447:
511:
116:
506:
490:
326:
202:
105:
236:
276:
271:
109:
88:
182:
440:
370:
78:
48:
128:
The SQL standards documentation is not freely available but may be purchased from the
561:
485:
426:
567:
536:
454:
433:
384:
377:
356:
349:
229:
461:
398:
335:
71:
468:
405:
391:
363:
342:
95:
216:
412:
316:
311:
306:
296:
291:
286:
56:
45:
546:
541:
531:
526:
521:
516:
281:
266:
186:
102:
38:
225:
252:
52:
42:
542:
SQL Routines and Types for the Java
Programming Language
221:
499:
478:
325:
259:
176:
SQL:2008 now an approved ISO International
Standard
84:comma-separated WHEN clauses in a CASE expression,
19:This article is about the language standard. For
237:
8:
217:Freely downloadable drafts of this standard
244:
230:
222:
171:
169:
165:
583:Computer-related introductions in 2008
185:, a July 29th, 2008 blog post from a
66:Additions to the Foundation include
7:
537:Information and Definition Schemas
199:Oracle Compliance To Core SQL:2008
14:
573:Declarative programming languages
134:ISO/IEC 9075(1-4,9-11,13,14):2008
16:2008 edition of the SQL standard
1:
33:is the sixth revision of the
23:, the Microsoft product, see
527:Management of External Data
599:
547:XML-Related Specifications
74:and DIAGNOSTIC statements,
18:
522:Persistent Stored Modules
155:Structured Query Language
55:. The next iteration is
25:Microsoft SQL Server 2008
532:Object Language Bindings
140:Claims of conformance
517:Call-Level Interface
101:support for various
491:Relational database
203:Oracle Corporation
181:2011-06-28 at the
106:regular expression
555:
554:
500:ISO/IEC SQL parts
89:database triggers
41:standard for the
590:
471:
464:
457:
450:
443:
436:
429:
422:
415:
408:
401:
394:
387:
380:
373:
366:
359:
352:
345:
338:
246:
239:
232:
223:
205:
196:
190:
173:
115:enhancements to
110:pattern-matching
598:
597:
593:
592:
591:
589:
588:
587:
578:Query languages
558:
557:
556:
551:
495:
474:
467:
460:
453:
446:
439:
432:
425:
418:
411:
404:
397:
390:
383:
376:
369:
362:
355:
348:
341:
334:
321:
255:
250:
213:
208:
197:
193:
183:Wayback Machine
174:
167:
163:
151:
142:
126:
64:
28:
17:
12:
11:
5:
596:
594:
586:
585:
580:
575:
570:
560:
559:
553:
552:
550:
549:
544:
539:
534:
529:
524:
519:
514:
509:
503:
501:
497:
496:
494:
493:
488:
482:
480:
476:
475:
473:
472:
465:
458:
451:
444:
437:
430:
423:
416:
409:
402:
395:
388:
381:
374:
367:
360:
353:
346:
339:
331:
329:
323:
322:
320:
319:
314:
309:
304:
299:
294:
289:
284:
279:
274:
269:
263:
261:
257:
256:
251:
249:
248:
241:
234:
226:
220:
219:
212:
211:External links
209:
207:
206:
191:
164:
162:
159:
158:
157:
150:
147:
141:
138:
125:
122:
121:
120:
117:derived column
113:
99:
92:
85:
82:
79:TRUNCATE TABLE
75:
63:
60:
49:query language
15:
13:
10:
9:
6:
4:
3:
2:
595:
584:
581:
579:
576:
574:
571:
569:
566:
565:
563:
548:
545:
543:
540:
538:
535:
533:
530:
528:
525:
523:
520:
518:
515:
513:
510:
508:
505:
504:
502:
498:
492:
489:
487:
484:
483:
481:
477:
470:
466:
463:
459:
456:
452:
449:
445:
442:
438:
435:
431:
428:
424:
421:
417:
414:
410:
407:
403:
400:
396:
393:
389:
386:
382:
379:
375:
372:
368:
365:
361:
358:
354:
351:
347:
344:
340:
337:
333:
332:
330:
328:
324:
318:
315:
313:
310:
308:
305:
303:
300:
298:
295:
293:
290:
288:
285:
283:
280:
278:
275:
273:
270:
268:
265:
264:
262:
258:
254:
247:
242:
240:
235:
233:
228:
227:
224:
218:
215:
214:
210:
204:
200:
195:
192:
188:
184:
180:
177:
172:
170:
166:
160:
156:
153:
152:
148:
146:
139:
137:
135:
131:
124:Documentation
123:
118:
114:
112:features, and
111:
107:
104:
100:
97:
93:
90:
86:
83:
80:
76:
73:
69:
68:
67:
61:
59:
58:
54:
50:
47:
44:
40:
36:
32:
26:
22:
301:
194:
143:
133:
127:
94:partitioned
65:
62:New features
30:
29:
20:
87:INSTEAD OF
21:MS SQL 2008
562:Categories
512:Foundation
486:Edgar Codd
161:References
81:statement,
507:Framework
70:enhanced
441:Truncate
413:Order by
371:Group by
327:Keywords
317:SQL:2023
312:SQL:2016
307:SQL:2011
302:SQL:2008
297:SQL:2006
292:SQL:2003
287:SQL:1999
260:Versions
179:Archived
149:See also
57:SQL:2011
46:database
31:SQL:2008
479:Related
427:Prepare
98:tables,
455:Update
434:Select
385:Insert
378:Having
357:Delete
350:Create
282:SQL-92
277:SQL-89
272:SQL-86
267:SEQUEL
187:Sybase
119:names.
103:XQuery
462:Where
448:Union
399:Merge
201:from
72:MERGE
469:With
420:Over
406:Null
392:Join
364:From
343:Case
189:blog
96:JOIN
77:the
39:ANSI
37:and
568:SQL
253:SQL
132:as
130:ISO
53:SQL
43:SQL
35:ISO
564::
336:As
168:^
136:.
245:e
238:t
231:v
108:/
91:,
27:.
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.