Parameterized queries vs using queries

Database
N/A

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