SQL Server 2000 and XML Part 6 - Annotated XDR Schemes

XDR is an acronym for XML-Data Reduced and is a language used to create schemas. Normally a Data Type Definition (DTD) is used to describe the structure of the data in an XML document. This is generally fine, except that in the DTD and XML document all data is character data.

SQL Server 2000 and XML Part 5 - XML Templates

To help reduce the amount of data that needs to be entered into the URL we can use XML templates. XML templates are simply XML files that contain the query string or stored procedure to be executed.

SQL Server 2000 and XML Part 4 - Calling Stored Procedures in URLs

The SELECT statements that we have entered so far in the URL of our browser have been relatively short. But you should be able to see how they could quickly become cumbersome as we start to enter more complex queries and use joins.

SQL Server 2000 and XML Part 3 - XSL Stylesheets

XML documents can contain actual XML data or a query that will be executed to retrieve the XML data from SQL Server.

SQL Server 2000 and XML Part 2 - Selecting XML Data

We know that we can select data in SQL Server 2000 using the SELECT statement. We can also select data and have it formatted as XML, using the FOR XML clause.

SQL Server 2000 and XML Part 1 - Introduction

Just a few short years ago we would display data from our database on the Web as HTML using Active Server Pages to select and format the data. We would also send and receive data as plain text files in business-to-business (B2B) applications.

Professional SQL Server 2000 Programming Part 6 - Indexed (Materialized) Views

This one is brand new with SQL Server 2000 and is, unfortunately, only supported in the Enterprise Edition (OK, the Developer and Evaluation Editions also support it, but you aren't allowed to use these in production systems). Simply put, this is a spectacular new feature. Until fairly recently, the concept of an index on a view seemed pretty ludicrous - after all, how do you index data that isn't really there?

Professional SQL Server 2000 Programming Part 5 - Protecting Code: Encrypting Views

If you're building any kind of commercial software product, odds are that you're interested in protecting your source code. Views are the first place we see the opportunity to do just that.

Professional SQL Server 2000 Programming Part 4 - Auditing: Displaying Existing Code

What do you do when you have a view, but you're not sure what it does? The first option should be easy at this point - just go into EM like you're going to edit the view.

Professional SQL Server 2000 Programming Part 3 - Editing Views

The main thing to remember when you edit views with T-SQL is that you are completely replacing the existing view.

Professional SQL Server 2000 Programming Part 2 - More Complex Views

Even though I use the term "complex" here - don't let that scare you. The toughest thing in views is still, for the most part, simpler than most other things in SQL.

Professional SQL Server 2000 Programming Part 1 - Simple Views

The syntax for a view, in its most basic form, is a combination of a couple of things we've already seen in the book - the basic CREATE statement that we saw back in Chapter 6, plus a SELECT statement like we've used over and over again.

How do you write SQL queries without knowing SQL?

How do you write advanced SQL queries without knowing SQL? This week Daren Brokenshire investigates by uncovering a simple answer!