Diff between static webpage and dynamic webpage?

Static Web-pages:

Static pages are already established and are not drawn up from bits and pieces from a search query. Until recently search engines could not surf dynamic pages and thus items on such sites were not listed in search engines but today some search engines, like Google and Yahoo, are able to do so. However it takes longer for them to index all the data and if you have set up similar static pages it can cause supplemental results penalties unless one or the other has a noindex meta tag on it.

___________________________________________________________________

Dynamic Web-pages:

In order to generate dynamic pages it requires a script program such as ASP, PHP or CMF to generate instructions to call up and construct the dynamic pages after the surfer inputs some data in a search program. Dynamic pages often use characters in their URL which prevent the search engines from reading and indexing the data on that page, i.e., "&id=". They also often utilize Session IDs in the URLs which, if not properly written, will prevent search engines from following links on that page (or cause an inflated page count) and those pages don't gain PR (Page Rank) from Google either. If you are familiar with using HTACCESS you can set up redirects for dynamic URLs by using a tool to rewrite URLs.

____________________________________________________________________

Dynamic pages can be turned into static pages so the search engines will list the pages but here again you need to be concerned with duplicate content penalties or you can also ban the search engine from the database version via the robots.txt file. You also need to consider if this technology, and it's problems, is compatible with your designing budget.