Vieira, Robert.
Beginning SQL server 2005 programming [[Book] /] Robert Viera. - Indianapolis, IN : Wiley, 2006. - xvii, 688 p. : ill. ; 24 cm. - Wrox professional guides .
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.
All Ages.
0764584332 (pbk.) 9780764584336 8126507543
2006297436
GBA579656 bnb
013296781 Uk
SQL server.
Client/server computing.
Relational databases.
QA76.9.C55 / V53 2006
005.7585
/ V B
Beginning SQL server 2005 programming [[Book] /] Robert Viera. - Indianapolis, IN : Wiley, 2006. - xvii, 688 p. : ill. ; 24 cm. - Wrox professional guides .
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.
All Ages.
0764584332 (pbk.) 9780764584336 8126507543
2006297436
GBA579656 bnb
013296781 Uk
SQL server.
Client/server computing.
Relational databases.
QA76.9.C55 / V53 2006
005.7585
/ V B