Monthly Archives: August 2010

70-451 – MCITP – Designing Programming Objects – Design T-SQL Table-Valued and Scalar Functions

Requirements Design T-SQL table-valued and scalar functions.This objective may include but is not limited to: inline table-valued functions vs. views, multi-statement table-valued functions, determinism My Take There are many types of user defined functions available, including functions which return a … Continue reading

Posted in SQL | Tagged , , | 2 Comments

70-451 – MCITP – Designing Programming Objects – Design Views

Requirements Design views. This objective may include but is not limited to: common table expressions, partitioned views, WITH CHECK OPTION, WITH SCHEMABINDING My Take This section will show some of the options associated with views. It should be noted that … Continue reading

Posted in SQL | Tagged , , | 3 Comments