Stored procedures and views give you a lot of power and flexibility in terms of programmatic capabilities, security, and performance. There are a few needs, however, that they don’t cover. Views cannot be parameterized, and the results of stored procedures cannot be embedded naturally in DML statements, be they scalar return values or rowsets.
KeywordsImaginary Part Complex Number Client Application Character String Select Statement
Unable to display preview. Download preview PDF.