Difference between revisions of "SET SQLROWID"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (6 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
To include a unique row identifier in SELECT * statements | To include a unique row identifier in SELECT * statements | ||
| Line 15: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | SELECT, | + | [[SQL SELECT|SELECT]], [[:Category:SQL|SQL]] |
| Line 23: | Line 16: | ||
==Example== | ==Example== | ||
| − | < | + | <code lang="recital"> |
set sql on | set sql on | ||
set sqlrowid on | set sqlrowid on | ||
| − | select * from state.rdb where state = "M";</ | + | select * from state.rdb where state = "M"; |
| + | </code> | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
| + | [[Category:Documentation]] | ||
| + | [[Category:Commands]] | ||
| + | [[Category:Set_Commands|SQLROWID]] | ||
| + | [[Category:SQL]] | ||
| + | [[Category:SQL Set Commands]] | ||
Latest revision as of 15:35, 25 November 2009
Purpose
To include a unique row identifier in SELECT * statements
Syntax
SET SQLROWID ON | OFF
See Also
Description
The SET SQLROWID ON | OFF command is used to determine whether a unique row identifier in should be included in SELECT * statements. If SET SQLROWID is ON, the unique row identifier will be included, if SET SQLROWID is OFF, only the fields from the table will be included.
Example
set sql on set sqlrowid on select * from state.rdb where state = "M";
Products
Recital Server, Recital
