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 correlated sub-queries in SQL Server. Possessing the ability to use a correlated sub-query will allow you to solve problems that other database developers cannot. Tim Chapman discusses how to use this extremely useful programming construct. A sub-query is a SQL Server statement embedded inside of another SQL Server statement. The database engine treats a sub-query as a virtual table for the execution of the query. A sub-query can be used as a table in a join statement, as a single value in a select statement, in the where clause of a SQL Server query, in the having clause of a SQL Server query, or incorporated in data manipulation statements. Sub-query execution is dependent upon the nesting level of the query.