Category : Windows 3.X Files
Archive   : QWNSQL2A.ZIP
Filename : SYNTAX.HLP
%/8@HOZ^g¦±·»É< U ] j o y ¬ Å ç
'
+
/
9
@
G
L
P
Y
a
h
n
¢
¨
®
»
Á
Þ
æ
ë
î
ò
'.>M\|Ûäëîøþ ) - 4 9 B E J N R X ^ e k t | ¡ ¦ » ¿ Ã É æ ë
]
¤
³
Á
Ñ
ã
ç
÷
8@ITkpw|¥¬²º½ÀÇÊÒØ#&BHR[elsµ»ÁÈÏÓÛÞâçíö
&.7;EOX`js¥´ÀÄÉÑØàëðöý%.4C¡©²¶ÁÇÏ×Ýâçðù %0>DGXhlqy¤µæñø
!,28?IMPr} ¤ª±µºÁÅÎØÞãèëóú ")£¬´ÀÃÇÍÓØáèïøý")-6?ELQYaio{¦¬´¼ÁÇÏØù&,27=CGKORW[_dimquz ©ÄÉÒÜâèìñôøü%(,>CJOSY]agj"Grouped"SYSTEM"."grouped table". "Grouped tables" are fully supported by the Quasar Database Administrator.(ColumnName(Subquery)(Value1(for(whichever occurred most recently), otherwise the condition evaluates to FALSE.-2147483647. ...1.7976931348623158e+3082.2250738585072014e-308.2047.2147483647.<= <= 19 and 0 <=<= 19.A comment.ALLASCAdditionalAdditional columns may be included within theAdministratorApproximateArithmetic expressions are evaluatedAs queries are executed within a transaction and records are created, read, updated or deleted; the database applies various kinds of locks on the applicable records. These locks are released when the transaction is committed or rolled back. In order tBuilt-inCHARCHARACTER(COLUMNCOMMIT WORKCOUNT(CREATECREATE TABLECatalogChanges made to the database are not made permanent untilCharacterCharacter data, length assumed to be 1.Character data, length specified by n where 1 <= n <= 2047.Character data, variable length where maximum length isColumnColumnNameColumnNameColumnName1 DataType1ColumnSpecificationCommentsConditionCorrelationNameCreatesCreatorNameDECDELETEDELETE FROMDESCDESC]]DISTINCTDROPDROP INDEXDROP TABLEData TypesData typeDataTypeDatabaseDeletesDescriptionEachEvaluatesEvaluates to TRUE if and only ifExpressionExpressionExpression1Expression2FALSE.FROMFloating pointFloating point number with magnitude ranging from approximately 1.7976931348623158e+308 to 2.2250738585072014e-308.For each record selected,GROUP BYIN (Subquery)INDEXINDEX_NAMEINSERTINSERT INTOINTIndexNameIndicatesIndicates theIndicates the name of theIndicates the number of columns inIndicates the position of the column within theIndicates whetherInstNULLNUMBER_OF_NUMERICNumericORDEROnlyOperatorsOverviewPatternPhrasePlease refer to a text book for a description of theQuasarREMARKROLLBACK WORKSELECTSET ColumnName1 = Expression1SMALLINTSOME]SQLSQL.SYSTEM.COLUMNSSYSTEM.INDICESSYSTEM.TABLESSYSTEM.USERSSame asSearch ConditionSearchConditionSelectStatementSigned decimal number with up toSigned decimal number with up to 19 digits of which 0 appear to the right of the decimal point.SpecifiesSpecifyStaStatementsStringSubquerySyntaxSystem CatalogTABLETABLE_NAMETRUETRUE ifTRUE.TableNameTheTheseThisThisTypes:UNIQUEUNKNOWNUPDATEUSER_NAMEUserNameVALUES (Value1VARCHAR(128)VARCHAR(32)ValueWHERE SearchConditionWORKWhenWhen aWhen a column is specified asWhileWhole number ranging from -2147483647 to 2147483647.You may only modify the REMARK field of records in this table.[(ColumnName1[, ColumnName2] ... )][, ColumnName2[, ColumnSpecification[, Expression2][, Value2] ...[ALL | DISTINCT][ANY | ALL | SOME][ASC[CorrelationName[CreatorName.][NOT[NOT][UNIQUE (ColumnNameA[, ColumnNameB] ... )][UNIQUE][UserName[UserName.][WHERE SearchCondition][not][optionaboutacceacrossadministratoragainstallallowed.alreadyamountanalyzedandandanotheranyanytime,appearappear to the right of the decimal point; 1 <=applicableapplieapproximatelyareare limited to 32 charactersarise.arithmeticascendingassociatedassumedattemptautomaticallyavailablebackbarbecomes the name of the newly createdbeforebelongbelongsbetweenbookbuilt-incancasecausechangecharactercharacters.clausecolumncolumnscombinationcommas.comment.committedcompcompatibleconcatenatconditionconflictconstraintconstructconstructed.containingcontainscontentcontrolcreatecreatingcurrentcurrent userdatadata,databasedecimaldefault.definitionsdeletdeletedeleteddepositeddescending.descriptiondeterminedifferentdigitsdigits of whichdigits of which 0 appear to the right of the decimal point; 1 <=distinguishabledocumentdroppeddroppingduplicateeacheffectivelyeitherelementseliminatentireequalerrorevaluatedevaluatesevaluatiexampleexecuteexecutiexpressionfieldfixed pointfloating pointfollowforfor ascending andfor descending. fromfullyfunctiongeneragenerategreatgrouphashavehelphowever,identifieidentifyif the table belongs to a user different from theif you wishimpliesincludedincludesindexindiindicatesindicesinformationinsertinsureintegerinternallyintois is analyzed and a value obtained. is default.issuingjournalkeykey valueskeywordsleftlengthlimitedlistlockslogicalmademagnitudemaintainedmanagematchmaximmayminimizemodifiemodifymoremultiplimustnamenamesnotnumbernumerico minimize the conflict between transactions, be sure to minimize the amount of time these locks are in place by issuing aobtained.occurredon the tableoneonlyoperatoptionorderotherwisepatternperformpermanentplacepointpoint;positionpossibleprequeriesrangingreadrecently)recommendrecordrecordsreferreferredreleasedrepeatedresultresult tableresultingreturnrightrolledsamescrollsectionselectselectedseparatesincesinglespecificspecifiedspecifies which records are to bestandard.startsstatementstringsuppliedsupportsyntaxsystemtabletable.tablestextthanthatthetheirthemthentherethesetheythistimetopictransactiontypetype is typically referred to astype is used to store text.typestypicallyunderlineduniqueupdateuponupperuseuseduservaluevaluesvariablevariousviolatesvisiblewaswhenwhenever possible.wherewhetherwhichwillwindowwishwithwithinyou/ & ;) z4 missing. Con ÿÿ
ÿÿÿÿ|CTXOMAP |FONT ð |KWBTREE S |KWDATA |KWMAP B |Phrases |SYSTEM ¶ |TOMAP |TOPIC ì |TTLBTREE g.ßgcßgÞßgÐxßgU!ßg ßgZbßgbßgßgAßg¥ßg^0ßg
ßg°ßgIßgßg"ßgIÍßg2ÇßgNÂßg5Ößg£ÛßgÌßg^ÄßgZßgéßg`_ßg{ßg#ßg«ßgUßg%Óßg^UßgWßgCÂßgYßgôZßg Vßgþ[ßgç{ßgeßgßgßgTßg#ßg4ßgÉÊßg"Ëßg½Ôßg>SßgbÊßg Ðßgznßg"'ßgêÎßgJßg)Ôßgé¦ßgÌÙßg4ßgßg¤ ßgâCßgPßg_ÙßgGßgxLßgÏßg¢Üßg=ßgUßghßgsßgÆYßgeSßgßg¦#ßgkcßg ßg4ßg1'ßg¦ßgISßgH¥ßg ßg¯ ßgòUßgý£ßgÝZßg´ßgpSßgËxßgßg1ÜßgIÂßgòßgP¢ßgCßgÖ]ßgnßgüÉßgþRßg¢mßgßg¡ßg²Yßgãßg~VßgßgüßgëßgUßg_ßg)ßgVßg¢ßg ßgWßg[ßg´Ußgßgßgßg"ÑßgæYßgWØßgñßgßgè¡ßgëßgL[ßgßgÈßgÉßgÄßgaßg¨¤ßgåßgó¥ßgH¡ßg]£ßgßßgV_ßgàUßg ±ßgßg
ßgMßg{ßgêÖßgNÇßgúvßgµVßgMßgDåßgìßgâßgÈkßgÉßg«ßgßgh©ßg5ßg]ßgé²ßg('ßg¥ßgâgßgaßgqbßgkßgßg&Ðßg_Øßg5Ãßg¾ßgWßgýßg×ßgQÖßg4ßgUßg/Ôßg. ßg}ÈßgAÔßghÊßgxÊßgOßg ßgßgeÙßg£«ßgVßgîYßgºßgßg©ÈßgºYßgÏÊßg»*ßgèCßgyßglßgÒlßgBßgÃlßgsßgÒÙßgm<ßg(ËßgÂÆßgõÔßg]6ßg¶kßg1¯ßgeÍßgPmßgÐßgÒÀßgÈWßg#ßgzßg)ß6 - l \>)
Quasar ÎK=U* ÝKþ
Þ[ 3n *n ÿÿÿÿ ÿÿÿÿ) ) ! È ÿÿ á)Yj: ) : % T* ÿ Ò áHelp Index ' s : ' - , ¾JBÑ à. ÿ ks 9YJs ¡A9á(. Using 9board, tab to
9YKwant to view, 8n âss enter. Using 9mouse, Ûto 9YKwant to view, }click 9mouse button. Use 8 ¤ to see entries ¹currently sin 9Y. To learn how to cX, âss F1. z l ' z 4 : ¾JRB°±S~±á ÿ Ê describes, in Ll terms, what áis }9¸ation ein G. Ä é z Ä â ÂJRB±S~±á á á! á" á# á$ á% ÿ þ ia of 9)of qáÿr program µb. z ia of qïUrecognized by â È ia of qÊors eâ 9Functions ia of q³Js eâ s ia of 9)of 6s eâ î ia of 9)eto
ï . ia of 91eby 9Ó1to keep track of 9ò. @ , Ä @ ! å General s}¸ation conventions' @ ' " T* ÿ Ê @ ' @ * & ²JRB!ã~! ÿ General Information ÿ @ ÿ . . ²JB!Ñ ÿ Structured Query Language (SQL) is 9ó ment language declared by 9American National ündards ºitute (ANSI) as a áis 9 lingua franca of 9Îuter óworld. áis eon mainframes, minicomputers }PCs. C ÿ C * & ²JRB!ã~! ÿ Notational Conventions Y 9 C e 6 > ²JB!Ñ ÿ ;`case is ethroughout Gto lcate áwords (COMMIT, Ø, etc), in actuality 9Ó1hpt words in aor lowercase. word 'COMMIT' §be spelled 'commit', 'Commit', 'COMMIT', etc. ·of brs, 0, lces }Ä, }9ãof ½8s , [·sensitive. If esome Çof a}lower ·to ç8m, Wto c9Çto hss 8m. All +·were æd using a·È. Optional !lcated by color }enclosing 8m square brackets as in d] When a choice §be among a of áÌal , lvidual selections d by vertical ¤s as inz ½ Ô d1 | Ì2 | Ì3] . » e . . ÂJB!Ñ ÿ When a Ó§be ø, an ellipsis >s 9Óas in "ColumnName1 B] ". 1ea of Çor ¯Ã·d by È . . ! á s defined'
. ' " T* ÿ þ L <