Parameterized queries vs using queries

Database
Not applicable

Parameterized queries vs using queries

1.Can any one tell me the exact difference between Parameterized query and Using query.
2.Can any one tell me the difference between P mode and S mode requests??

Thanks
Vinod