sqlserver

Question

can any one explain with  a realtime scenario what is dynamic sql and y we use ? where we use?

Let me know please.............thanks in advance