Question d’entretien chez Allscripts
What was difference between views and procedures.
Réponse à la question d'entretien
Utilisateur anonyme
11 sept. 2017
A SQL View is a virtual table, which is based on SQL SELECT query. A view references one or more existing database tables or other views. It is the snap shot of the database whereas a stored procedure is a group of Transact-SQL statements compiled into a single execution plan.