-
Recent Posts
Categories
- Books (29)
- Computers and Internet (3)
- Data Warehousing (8)
- Dungeons and Dragons (4)
- Games (2)
- General Ramblings (25)
- Movies (1)
- News and politics (1)
- SQL (84)
- SSIS (23)
- Travel (11)
- Uncategorized (19)
- 70-451
- 70-462
- Award
- Awards
- Book
- Book Review
- Business Intelligence
- certification
- certifications
- CLR
- Concurrency
- Configurations
- Database Design
- Data Integrity
- Data Modeling
- Data Quality
- Data Warehouse
- DB2
- DMOs
- DMVs
- ETL
- Execution Plans
- Full Text Index
- Goals
- Indexes
- Introductory Level
- JSSUG
- Locking
- MCITP
- MCTS
- Mirroring
- Monitoring
- MSDN Forums
- Partition
- PASS
- Performance Tuning
- Plan Guide
- Pool League Project
- Professional Development
- Professional Goals
- Query Tuning
- Quick Tip
- Rambling
- Rant
- Refactoring
- Replication
- Samples
- Scaling
- Script Component
- Security
- Service Broker
- Source Control
- SQLRally
- SQL Saturday
- SQL Server Internals
- SSAS
- SSIS
- SSIS Configurations
- SSIS Expressions
- SSIS Framework
- SSIS Precedence Constraints
- SSIS Quick Tip
- Stored Procedures
- Table Design
- Table Hints
- Tech Book
- Tech Books
- Testing
- Training
- Transactions
- UDF
- UDT
- UnSQL Friday
- View
- XML
Archives
- December 2013
- June 2013
- April 2013
- February 2013
- January 2013
- May 2012
- March 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- November 2007
Tag Archives: Stored Procedures
70-451 – MCITP – Designing Programming Objects – Stored Procedures
Requirements Design T-SQL stored procedures.This objective may include but is not limited to: execution context (EXECUTE AS), table-valued parameters, determining appropriate way to return data, WITH RECOMPILE/OPTION (RECOMPILE), error handling, TRY/CATCH My Take This section will be dealing with how … Continue reading
Destination: Change 