server variables
what are the gud books to learn SQL Server 2005 for a new person?I have a bit of knowledge about databases?
my syllabus to study is
1. SQL server 2005 architecture.
2. Declaring variables and parameters.
3. Maintaining data (DML).
4. T-SQL stored Views, procedures , Functions and Triggers.
5. Programming procedural statements.
6. Error handling.
7. Handling server-side result sets.
8. Querying and storing XML.
9. Integration of .net CLR with SQL server.
a. Developing procedural code in .net.
b. Extending SQL server with .net.
what r the free ebooks
pls give the links
1. Robert Vieira, Beginning SQL Server 2005 Programming (Paperback, 2006)
ISBN-13: 978-0764584336
2. Robert Vieira, Professional SQL Server 2005 Programming (Programmer to Programmer) (Paperback, 2006)
ISBN-13: 978-0764584343
These books should cover everything you will be studying in your syllabus, and have clear and easily understandable content with a good mix of theory, examples, and practical code.
[phpbay]server variables, 30, "11211"[/phpbay]
[phpzon]server variables, 5, Electronics[/phpzon]
Intro to Using Variables in SQL Server Integration Services