| name | description |
| spCopyDbSimpleTable | |
| spCopyDbSubset | |
| spDocEnum | Display the properly rendered values from DataConstants |
| spDocKeySearch | Search Columns table for @key |
| spExecuteSQL | Procedure to safely execute an SQL select statement |
| spExecuteSQL2 | Procedure to safely execute an SQL select statement |
| spGetFiberList | Return a list of fibers on a given plate. |
| spGetMatch | Get the neighbors to a list of @ra,@dec pairs in #upload in photoPrimary within @r arcsec . @w is the weight per object. |
| spGetNeighbors | Get the neighbors to a list of @ra,@dec pairs in #upload |
| spGetNeighborsAll | Get the neighbors to a list of @ra,@dec pairs in #upload |
| spGetNeighborsPrim | Get the primary neighbors to a list of @ra,@dec pairs in #upload |
| spGetNeighborsRadius | Get the neighbors to a list of @ra,@dec,@r triplets in #upload in photoPrimary |
| spGetSpecNeighborsAll | Get the spectro neighbors to a list of @ra,@dec pairs in #upload |
| spGetSpecNeighborsPrim | Get the scienceprimary spectro neighbors to a list of @ra,@dec pairs in #upload |
| spGetSpecNeighborsRadius | Get the spectro scienceprimary neighbors to a list of @ra,@dec,@r triplets in #upload in SpecObj |
| spLogSqlPerformance | Procedure to log success (or failure) of a SQL query to the performance log. |
| spLogSqlStatement | Procedure to log a SQL query to the statement log. |
| spNearestObjEq | Returns table containing the nearest primary object within @r arcmins of an Equatorial point (@ra,@dec) |
| spQsoCatalogs | |
| spRegionAnd | Create a new region containing intersection (AND) of regions d1 and d2. |
| spSetWebServerUrl | Set the WebServerUrl value in SiteConstants based on the given site name. |
| spSkyServerColumns | Return the list of Columns in a given table |
| spSkyServerConstraints | Return the list of Constraints in a given table. |
| spSkyServerDatabases | Return the list of Databases on the Server. |
| spSkyServerFormattedQuery | Return the results of a formatted query. |
| spSkyServerFreeFormQuery | Return the results of a free form query. |
| spSkyServerFunctionParams | Return the parameters of a given function |
| spSkyServerFunctions | Return a list of functions in the database |
| spSkyServerIndices | Return a list of Indexes on a table |
| spSkyServerTables | Return a list of user tables. |