Web Server Error Codes

Code Name Description
0 Server Error No connection to the server available or the server was unavailable.
300 Multiple Choices The requested resource corresponds to multiple representations, each with its own specific location, and the negotiation information is being provided so that the user can select a preference and redirect its request to that location.
301 Moved Permanently The requested resource has been assigned to a new permanent URL.
302 Moved Temporarily The requested resource resides temporarily under a different URL. Clients should continue to use the URL since the redirection may vary.
303 See Other The response to the request can be found under a different URL. The new URL is not a substitute reference for the originally requested resource.
304 Not Modified If the client has performed a conditional GET request and access is allowed, but the document has not been modified.
305 Use Proxy The requested resource must be accessed through the proxy given by the location field.
400 Bad Request The request is not understood by the server due to an incorrect syntax.
401 Unauthorized User authentication is required.
403 Forbidden The server understood the request, but is refusing to fulfill it.
404 Page Not Found The server has not found the URL requested.
405 Method Not Allowed The method specified in the Request-Line is not allowed for the resource identified by the Request-URL.
406 Not Acceptable The server is not sending a response that the requestor is willing to accept.
407 Proxy Authentication Required The client must authenticate itself with the proxy (similar to Unauthorized).
408 Request Timed Out The client did not produce a request within the time that the server was prepared to wait.
409 Conflict The request was not complete due to a conflict with the current state of resources.
410 Gone The requested resource is no longer available at the server and no forwarding address is known (similar to 404, but 410 is permanent).
411 Length Required The server refuses to accept the request without a defined content-length.
412 Precondition Failed The precondition given in one or more of the request-header fields evaluated to false when it was tested on the server.
413 Request Entity Too Large The server is refusing to process a request because the request entity is larger than the server is willing or able to process.
414 Request-URL Too Long The request entity is larger than the server is willing or able to interpret.
415 Unsupported Media Type The server is refusing to service the request because the entity of the request is in a format not supported by the requested resource for the requested method.
416 Requested Range Not Satisfiable The request included a Range request-header field, and not any of the range-specifier values in this field overlap the current extent of the selected resource, and also the request did not include an If-Range request-header field.
417 Expectation Failed The expectation given in the Expect request-header could not be fulfilled by the server.
500 Server Error The client?s Web server is incapable of performing the request.
501 Not Implemented The server is currently unable to handle the request due to a temporary overloading or maintenance of the server.
502 Bad Gateway The server received an invalid response from the upstream server that it accessed in attempting to fulfill the request.
503 Out of Resources The server is unable to handle the request due to a temporary overloading or maintenance of the server.
504 Gateway Timeout The server did not receive a response in time from the upstream server specified by the URL.
505 HTTP Version Not Supported The server does not support the HTTP protocol version that was used in the request message.

Happy Coding :)

Custom SQL Helper Class – C#

I am creating a simple SQLHelper which will simplify the ADO.NET method usage.

The SQLHelper class just makes the Data Access Layer more compact and reusable across various applications.

SQLHelper is class which is used in data access layer, containing different method that will be help us to perform CRUD operation. We will just create an object for this class and we can use it in our application.

The SQLHelper class in C# contains all the methods to get data from database (using Stored Procedures) and also to insert and update data in database.

SQLHelper class that is used to communicate SQL in better way.

Download C# – SQL Helper Class


Open-source JavaScript hosted libraries

I was searching on internet for JavaScript library and I came across very useful link. Here you can find all latest and stable version of open source JavaScript libraries for your development purpose on one place:

Open-source JavaScript hosted libraries

Happy Coding :)

SQL Server

SQL Tips and Tricks

Find Column Used in Stored Procedure – Search Stored Procedure for Column Name. Also Search Stored Procedure Code and Stored Procedure Text


,com.TEXT SPText

FROM sys.syscomments com

INNER JOIN sys.objects obj ON com.Id = obj.OBJECT_ID

WHERE com.TEXT LIKE ‘%Column Name%’


Find Column Used in Tables – Search Tables for Column Name





Find Stored Procedure Related to Table in Database – Search in All Stored Procedure



FROM syscomments com

INNER JOIN sysobjects obj ON com.id = obj.id

WHERE com.TEXT LIKE ‘%Table Name %’