Procedures

namedescription
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
spNearestObjEq Returns table containing the nearest primary object within @r arcmins of an Equatorial point (@ra,@dec)
spRegionAnd Create a new region containing intersection (AND) of regions d1 and d2.
spRegionOr Create a new region containing the UNION of the convexes of regions d1 and d2.
spRegionSimplify Delete unneeded convexes from a region, and unneeded edges from a convex. Also populates RegionConvex and Region.SQL and Region.RegionConvexString
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.