SQL script of HTML status codes
Bit of a random post; I couldn’t find anything similar online, so created the script below and thought I’d share it in case anyone randomly needs a lookup/dimension table of HTML status codes. All pulled directly from Wikipedia . :-)
SELECT 200 AS [Code], 'OK' AS [Status],
'Standard response for successful HTTP requests.' AS [Description]
UNION ALL SELECT 201, 'Created',
'The request has been fulfilled and resulted in a new resource being created.'
UNION ALL SELECT 202, 'Accepted',
'The request has been accepted for processing, but the processing has not been completed.'
UNION ALL SELECT 203, 'Non-Authoritative Information',
'The server successfully processed the request, but is returning information that may be from another source.'
UNION ALL SELECT 204, 'No Content',
'The server successfully processed the request, but is not returning any content.'
UNION ALL SELECT 205, 'Reset Content',
'The server successfully processed the request, but is not returning any content. Unlike a 204 response, this response requires that the requester reset the document view.'
UNION ALL SELECT 206, 'Partial Content',
'The server is delivering only part of the resource due to a range header sent by the client.'
UNION ALL SELECT 207, 'Multi-Status',
'The message body that follows is an XML message and can contain a number of separate response codes.'
UNION ALL SELECT 208, 'Already Reported',
'The members of a DAV binding have already been enumerated in a previous reply to this request.'
UNION ALL SELECT 226, 'IM Used',
'The server has fulfilled a GET request for the resource.'
UNION ALL SELECT 300, 'Multiple Choices',
'Indicates multiple options for the resource that the client may follow.'
UNION ALL SELECT 301, 'Moved Permanently',
'This and all future requests should be directed to the given URI.'
UNION ALL SELECT 302, 'Found',
'The HTTP/1.0 specification required the client to perform a temporary redirect.'
UNION ALL SELECT 303, 'See Other',
'The response to the request can be found under another URI using a GET method.'
UNION ALL SELECT 304, 'Not Modified',
'Indicates the resource has not been modified since last requested.'
UNION ALL SELECT 305, 'Use Proxy',
'Many HTTP clients do not correctly handle responses with this status code.'
UNION ALL SELECT 306, 'Switch Proxy',
'No longer used.'
UNION ALL SELECT 307, 'Temporary Redirect',
'The request should be repeated with another URI; however, future requests should still use the original URI.'
UNION ALL SELECT 308, 'Permanent Redirect',
'The request, and all future requests should be repeated using another URI.'
UNION ALL SELECT 400, 'Bad Request',
'The request cannot be fulfilled due to bad syntax.'
UNION ALL SELECT 401, 'Unauthorized',
'Authentication is required and has failed or has not yet been provided.'
UNION ALL SELECT 402, 'Payment Required',
'Reserved for future use.'
UNION ALL SELECT 403, 'Forbidden',
'The request was valid, but the server is refusing to respond to it.'
UNION ALL SELECT 404, 'Not Found',
'The requested resource could not be found but may be available again in the future.'
UNION ALL SELECT 405, 'Method Not Allowed',
'A request was made using a request method not supported by that resource.'
UNION ALL SELECT 406, 'Not Acceptable',
'The requested resource is only capable of generating content not acceptable according to the Accept headers.'
UNION ALL SELECT 407, 'Proxy Authentication Required',
'The client must first authenticate itself with the proxy.'
UNION ALL SELECT 408, 'Request Timeout',
'The server timed out waiting for the request.'
UNION ALL SELECT 409, 'Conflict',
'The request could not be processed because of conflict in the request.'
UNION ALL SELECT 410, 'Gone',
'The resource requested is no longer available and will not be available again.'
UNION ALL SELECT 411, 'Length Required',
'The request did not specify the length of its content.'
UNION ALL SELECT 412, 'Precondition Failed',
'The server does not meet one of the preconditions that the requester put on the request.'
UNION ALL SELECT 413, 'Request Entity Too Large',
'The request is larger than the server is willing or able to process.'
UNION ALL SELECT 414, 'Request-URI Too Long',
'The URI provided was too long for the server to process.'
UNION ALL SELECT 415, 'Unsupported Media Type',
'The request entity has a media type which the server or resource does not support.'
UNION ALL SELECT 416, 'Requested Range Not Satisfiable',
'The client has asked for a portion of the file that lies beyond the end of the file.'
UNION ALL SELECT 417, 'Expectation Failed',
'The server cannot meet the requirements of the Expect request-header field.'
UNION ALL SELECT 418, 'I''m a teapot (RFC 2324)',
'Defined in 1998 as an IETF April Fools'' joke.'
UNION ALL SELECT 420, 'Enhance Your Calm (Twitter)',
'Returned when the client is being rate limited.'
UNION ALL SELECT 422, 'Unprocessable Entity (WebDAV)',
'The request was well-formed but was unable to be followed due to semantic errors.'
UNION ALL SELECT 423, 'Locked (WebDAV)',
'The resource that is being accessed is locked.'
UNION ALL SELECT 424, 'Failed Dependency (WebDAV)',
'The request failed due to failure of a previous request.'
UNION ALL SELECT 425, 'Unordered Collection',
'Defined in drafts of WebDAV Advanced Collections Protocol.'
UNION ALL SELECT 426, 'Upgrade Required',
'The client should switch to a different protocol such as TLS/1.0.'
UNION ALL SELECT 428, 'Precondition Required',
'The origin server requires the request to be conditional.'
UNION ALL SELECT 429, 'Too Many Requests',
'The user has sent too many requests in a given amount of time.'
UNION ALL SELECT 431, 'Request Header Fields Too Large',
'The header fields are too large.'
UNION ALL SELECT 444, 'No Response (Nginx)',
'Server has returned no information to the client and closed the connection.'
UNION ALL SELECT 449, 'Retry With (Microsoft)',
'The request should be retried after performing the appropriate action.'
UNION ALL SELECT 450, 'Blocked by Windows Parental Controls',
'A Microsoft extension for parental controls.'
UNION ALL SELECT 451, 'Unavailable For Legal Reasons',
'Resource access is denied for legal reasons.'
UNION ALL SELECT 500, 'Internal Server Error',
'A generic error message, given when no more specific message is suitable.'
UNION ALL SELECT 501, 'Not Implemented',
'The server does not recognize the request method.'
UNION ALL SELECT 502, 'Bad Gateway',
'The server received an invalid response from the upstream server.'
UNION ALL SELECT 503, 'Service Unavailable',
'The server is currently unavailable.'
UNION ALL SELECT 504, 'Gateway Timeout',
'The server did not receive a timely response from the upstream server.'
UNION ALL SELECT 505, 'HTTP Version Not Supported',
'The server does not support the HTTP protocol version used.'
UNION ALL SELECT 506, 'Variant Also Negotiates',
'Transparent content negotiation results in a circular reference.'
UNION ALL SELECT 507, 'Insufficient Storage (WebDAV)',
'The server is unable to store the representation needed.'
UNION ALL SELECT 508, 'Loop Detected (WebDAV)',
'The server detected an infinite loop while processing the request.'
UNION ALL SELECT 509, 'Bandwidth Limit Exceeded (Apache)',
'This status code is not specified in any RFCs.'
UNION ALL SELECT 510, 'Not Extended',
'Further extensions to the request are required.'
UNION ALL SELECT 511, 'Network Authentication Required',
'The client needs to authenticate to gain network access.'
UNION ALL SELECT 598, 'Network read timeout error',
'Used by Microsoft HTTP proxies.'
UNION ALL SELECT 599, 'Network connect timeout error',
'Used by Microsoft HTTP proxies.'