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.
Using Parameters for SQL Server Queries and Stored Procedures. One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this.