MS SQLServer Management Studio , NewQuery, @Zxml XML.
Declare @ZXML XML
Set @ZXML = '
<Supp>
<post1>
<S>S1</S>
<SName>Smith</SName>
<Status>20</Status>
</post1>
<post2>
<S>S2</S>
<SName>Black</SName>
<Status>10</Status>
</post2>
</Supp>'
Select @ZXML.query('/Supp/post1')
<post1><S>S1</S><SName>Smith</SName><Status>20</Status></post1>.
SQLQueryXML.
<post1>, XML :
<post1>
<S>S1</S>
<SName>Smith</SName>
<Status>20</Status>
</post1
Business Intelligence Development Studio.
SQL Server Reporting Services Reporting Services.
| | MS SQL Server 2008 R2 | | Reporting Services.
Report Server.
Reporting Services , .
Report Designer Business Intelligence Development Studio , Postavki . :
1. | | MS SQL Server 2008 R2 | Business Intelligence Development Studio File | New | Project ( | | )
2. Visual Studio . . OK.
3. . .
4. .
5. tblP. , OK.
6. .
7. :
- ;
- ;
- .
8. .
. ( ) .
.
1. Windous .
2. SQL Server.
3. Postavki.
|
|
4. .
5. .
6. , , .
.
[1] 2 :
tblS , S# ; SNAME, STATUS ; CITY , .
tblP , P# ; PNAME ; COLOR WGT ; CITY , .
tblSP , QTY .
tblS | tblP | ||||||||
S# | SNAME | STATUS | CITY | P# | PNAME | COLOR | WGT | CITY | |
S1 | Smith | London | P1 | Nut | Red | London | |||
S2 | Jones | Paris | P2 | Bolt | Green | Paris | |||
S3 | Black | Paris | P3 | Screw | Blue | Rome | |||
S4 | Smith | London | P4 | Screw | Red | London |
tblSP
S# | P# | QTY |
S1 | P1 | |
S1 | P2 | |
S1 | P3 | |
S2 | P1 | |
S2 | P2 | |
S3 | P3 |
2.
# . .
.
1. , ., . . 8- .: . . - .: , 2008. 1328 .: .
2., . Microsoft SQL Server 2008. .: . . - .: .. , 2010. - 816 .: . . . .
3. -, Microsoft SQL Server 2008. T-SQL / . . .: -, 2009.