Answer: An unlicensed dental assistant may perform such tasks as: 1  preparing the patient for treatment by seating patient, obtaining records and applying protective garb; 2  preparing instruments, materials and medicaments to be used; 3  taking dental x-rays in accordance with Public Health Law (see question 18);f a dental assistant is not licensed, he or she may NOT perform any duties within the scope of practice of any licensed individual. For information regarding scope of practice see question 10.
Using Parameter Queries. A useful feature of the query is that it can be saved and used again and again, whenever we want to ask the same question. The result we see (the dynaset) always reflects the most up-to-date information in the database because what you save is the question, not the answer. You just ask the question again by running the query. Sometimes we want to ask a question time and time again, but the details (the query's criteria) may vary.
If you want to use this query repeatedly to get the data for different sales people, you could instead parameterize the query and turn it into a stored procedure like: And it could be called like: Doing it this way explicitly tells SQL Server what the parameters are, which makes query execution plan reuse more likely. It also ensures that the salesperson value is handled in a way that is normally safer and makes SQL Injection Attacks through this procedure more difficult.