TY - BOOK AU - Vieira,Robert TI - Beginning SQL server 2005 programming T2 - Wrox professional guides SN - 0764584332 (pbk.) AV - QA76.9.C55 V53 2006 U1 - 005.7585 22 PY - 2006/// CY - Indianapolis, IN PB - Wiley Publishing KW - SQL server KW - Client/server computing KW - Relational databases N1 - Includes index; "Programmer to programmer"--Cover; RDBMS basics: what makes up a SQL server database? -- Tools of the trade -- The foundation statements of T-SQL -- JOINs -- Creating and altering tables -- Constraints -- Adding more to our queries -- Being normal: normalization and other basic design issues -- SQL server storage and index structures -- Views -- Writing scripts and batches -- Stored procedures -- User defined functions -- Transactions and locks -- Triggers -- A brief XML primer -- Reporting for duty, sir!: a look at reporting services -- Getting integrated with integration services -- Playing administrator -- Appendix A: Exercise solutions -- Appendix B: System functions -- Appendix C: Finding the right tool -- Appendix D: Very simple connectivity examples -- Appendix E: Installing and using the samples UR - http://www.loc.gov/catdir/enhancements/fy0653/2006297436-d.html UR - http://www.loc.gov/catdir/enhancements/fy0658/2006297436-t.html UR - http://www.loc.gov/catdir/enhancements/fy0740/2006297436-b.html ER -