Dynamic Sql

Explian in detail of dynamic sql and it use

find the details [URL="http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=WZPA,WZPA:2007-05,WZPA:en&q=dynamic+sql"]here[/URL].