📄 readme.htm
字号:
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="ProgId" content="Word.Document">
<meta name="Generator" content="Microsoft Word 11">
<meta name="Originator" content="Microsoft Word 11">
<link rel="File-List" href="Readme_files/filelist.xml"> <!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>Teo Lachev</o:Author>
<o:LastAuthor>Teo Lachev</o:LastAuthor>
<o:Revision>10</o:Revision>
<o:TotalTime>19</o:TotalTime>
<o:Created>2004-02-16T17:04:00Z</o:Created>
<o:LastSaved>2004-02-17T13:34:00Z</o:LastSaved>
<o:Pages>1</o:Pages>
<o:Words>213</o:Words>
<o:Characters>1220</o:Characters>
<o:Company>HP</o:Company>
<o:Lines>10</o:Lines>
<o:Paragraphs>2</o:Paragraphs>
<o:CharactersWithSpaces>1431</o:CharactersWithSpaces>
<o:Version>11.5606</o:Version>
</o:DocumentProperties>
</xml><![endif]--> <!--[if gte mso 9]><xml>
<w:WordDocument>
<w:Zoom>115</w:Zoom>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--> <!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" LatentStyleCount="156">
</w:LatentStyles>
</xml><![endif]-->
<style> <!-- a:active, a:hover { color: "#FF0000"; cursor:hand; text-decoration:"underline";}
h1 {margin-bottom:" .5em";}
h2 {margin-bottom:" .5em";}
h4 {margin-bottom:" .5em";}
h5 {margin-bottom:" .5em";}
p {margin-top:" .6em";}
table {cellpadding: "0.5em";}
#ALERT\_NOTE {margin-left:" 1.5em"; margin-top:" 1em";}
#ALERT\_IMPORTANT {margin-left:" 1.5em"; margin-top:" 1em";}
#ALERT\_WARNING {color: "B22222"; margin-left:" 1.5em"; margin-top:" 1em";}
/* Font Definitions */ @font-face {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:536871559 0 0 0 415 0;}
/* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";}
h1 {mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; mso-outline-level:1; font-size:23.0pt; font-family:"Times New Roman"; font-weight:bold;}
h2 {margin-top:.25in; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; mso-outline-level:2; font-size:21.0pt; font-family:"Times New Roman"; font-weight:bold;}
h3 {margin-top:.2in; margin-right:0in; margin-bottom:6.0pt; margin-left:0in; mso-pagination:widow-orphan; mso-outline-level:3; font-size:19.0pt; font-family:"Times New Roman"; font-weight:bold;}
h4 {mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; mso-outline-level:4; font-size:17.5pt; font-family:"Times New Roman"; font-weight:bold;}
h5 {margin-top:.25in; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; mso-outline-level:5; font-size:14.0pt; font-family:"Times New Roman"; font-weight:bold;}
h6 {margin-top:.2in; margin-right:0in; margin-bottom:6.0pt; margin-left:0in; mso-pagination:widow-orphan; mso-outline-level:6; font-size:13.0pt; font-family:"Times New Roman"; font-weight:bold;}
a:link, span.MsoHyperlink {color:blue; text-decoration:underline; text-underline:single;}
a:visited, span.MsoHyperlinkFollowed {color:#660000; text-decoration:underline; text-underline:single;}
em {color:red;}
p {mso-margin-top-alt:auto; margin-right:0in; margin-bottom:.1in; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";}
code {mso-ansi-font-size:14.0pt; mso-bidi-font-size:14.0pt; font-family:"Courier New"; mso-ascii-font-family:"Courier New"; mso-fareast-font-family:"Times New Roman"; mso-hansi-font-family:"Courier New"; mso-bidi-font-family:"Courier New";}
pre {margin-top:.2in; margin-right:0in; margin-bottom:.25in; margin-left:0in; mso-pagination:widow-orphan; tab-stops:45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt; font-size:10.0pt; font-family:"Courier New"; mso-fareast-font-family:"Times New Roman";}
span.SpellE {mso-style-name:""; mso-spl-e:yes;}
span.GramE {mso-style-name:""; mso-gram-e:yes;}
@page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;}
div.Section1 {page:Section1;}
/* List Definitions */ @list l0 {mso-list-id:868377208; mso-list-type:hybrid; mso-list-template-ids:-957475652 1876975346 67698689 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1 {mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in; color:windowtext; mso-ansi-font-weight:normal;}
@list l0:level2 {mso-level-number-format:bullet; mso-level-text:\F0B7; mso-level-tab-stop:1.0in; mso-level-number-position:left; text-indent:-.25in; font-family:Symbol; color:windowtext; mso-ansi-font-weight:normal;}
@list l0:level3 {mso-level-tab-stop:1.5in; mso-level-number-position:left; text-indent:-.25in;}
@list l0:level4 {mso-level-tab-stop:2.0in; mso-level-number-position:left; text-indent:-.25in;}
@list l0:level5 {mso-level-tab-stop:2.5in; mso-level-number-position:left; text-indent:-.25in;}
@list l0:level6 {mso-level-tab-stop:3.0in; mso-level-number-position:left; text-indent:-.25in;}
@list l0:level7 {mso-level-tab-stop:3.5in; mso-level-number-position:left; text-indent:-.25in;}
@list l0:level8 {mso-level-tab-stop:4.0in; mso-level-number-position:left; text-indent:-.25in;}
@list l0:level9 {mso-level-tab-stop:4.5in; mso-level-number-position:left; text-indent:-.25in;}
@list l1 {mso-list-id:1517572968; mso-list-type:hybrid; mso-list-template-ids:463492126 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l1:level1 {mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in;}
ol {margin-bottom:0in;}
ul {margin-bottom:0in;}
--></style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
</style>
<![endif]--> <!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="3074"/>
</xml><![endif]--> <!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1"/>
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="#660000" style='tab-interval:.5in' topmargin="0"
id="bodyID">
<div class="Section1">
<h1>Chapter 9 Setup </h1>
<p style='BACKGROUND:#c0ffff'><span style='FONT-FAMILY:Verdana'><br>
Please follow the steps below to setup the demos in Chapter 9.<br>
<o:p></o:p></span></p>
<h5><span style='FONT-FAMILY:Verdana'>Special Offer Demo<o:p></o:p></span></h5>
<p><span style='FONT-SIZE:10pt;FONT-FAMILY:Verdana'>To set up the Special
Offer demo:<o:p></o:p></span></p>
<ol style='MARGIN-TOP:0in' start="1" type="1">
<li class="MsoNormal" style='tab-stops:list .5in; mso-list:l1 level1 lfo3; mso-layout-grid-align:none'>
<span style="FONT-SIZE:
11pt;FONT-FAMILY:
'Courier New'">If you haven't done this already,
recompile the <span class="SpellE">AWReporterWeb</span> project.<o:p></o:p></span>
<li class="MsoNormal" style='tab-stops:list .5in; mso-list:l1 level1 lfo3; mso-layout-grid-align:none'>
<span style="FONT-SIZE:
11pt;FONT-FAMILY:
'Courier New'">Enable anonymous access for the <span class="SpellE">AWReporterWeb</span> <span class="SpellE">vroot</span>. Grant
right to the anonymous user identity to write to the <span class="SpellE">AWCSpecialDeals.xml</span>
file.<o:p></o:p></span>
<li class="MsoNormal" style='tab-stops:list .5in; mso-list:l1 level1 lfo3; mso-layout-grid-align:none'>
<span style="FONT-SIZE:
11pt;FONT-FAMILY:
'Courier New'">Change the identity of the ASP.NET
process to run under the identity of <span class="GramE">an</span> user, who
is a member of the Users group for Windows 2000. For Windows 2003, create
a new application pool and assign <span class="SpellE">AWReporterWeb</span>
to it. Then change the pool identity to the identity of <span class="GramE">an</span>
user, who is a member of the Users group. Assign the user account to
IIS_WPG group.<o:p></o:p></span>
<li class="MsoNormal" style='tab-stops:list .5in; mso-list:l1 level1 lfo3; mso-layout-grid-align:none'>
<span style="FONT-SIZE:
11pt;FONT-FAMILY:
'Courier New'">Using the Report Manager, assign the
user account from step 3 Browser role rights to the Sales Promotion report
and <span class="SpellE">SalesPromotion.xsl</span> XSLT file.<o:p></o:p></span>
<li class="MsoNormal" style='tab-stops:list .5in; mso-list:l1 level1 lfo3; mso-layout-grid-align:none'>
<span style="FONT-SIZE:
11pt;FONT-FAMILY:
'Courier New'">Install the <span class="SpellE">spUpdateRssFeed</span> stored procedure in the Adventure
Works 2000 database. It could be found in the sp.sql script inside the
Database/Database.dbp database project.</span>
<li class="MsoNormal" style='tab-stops:list .5in; mso-list:l1 level1 lfo3; mso-layout-grid-align:none'>
<span style="FONT-SIZE:
11pt;FONT-FAMILY:
'Courier New'">Install the <span class="SpellE">trgSpecialOffer</span>
on the <span class="SpellE">SpecialOffer</span> table.It could be found in the
triggers.sql script inside the Database/Database.dbp database
project.</span>
<o:p></o:p></SPAN>
<LI class="MsoNormal" style="tab-stops: list .5in; mso-list: l1 level1 lfo3; mso-layout-grid-align: none">
<span style="FONT-SIZE:
11pt;FONT-FAMILY:
'Courier New'">Insert a new record in table Special
Offer, e.g.<o:p></o:p></span>
</LI>
</ol>
<p class="MsoNormal" style='MARGIN-LEFT:0.5in;mso-layout-grid-align:none'><span style="FONT-SIZE:11pt;FONT-FAMILY:'Courier New'">INSERT
INTO [AdventureWorks2000]<span class="GramE">.[</span><span class="SpellE">dbo</span>].[<span class="SpellE">SpecialOffer</span>]([Description], [<span class="SpellE">DiscountPct</span>],
[Type], [Category], [<span class="SpellE">ActiveDate</span>], [<span class="SpellE">ExpirationDate</span>], [<span class="SpellE">MinQty</span>], [<span class="SpellE">MaxQty</span>])<o:p></o:p></span></p>
<p class="MsoNormal" style='TEXT-INDENT:0.5in;mso-layout-grid-align:none'><span class="GramE"><span style="FONT-SIZE:11pt;
FONT-FAMILY:'Courier New'">VALUES(</span>
</span><span style="FONT-SIZE:11pt;
FONT-FAMILY:'Courier New'">'Test Sales', 0.3, 'New Product', 'Customer',
'01/27/2004', '02/27/2004', 2,4)<o:p></o:p></span></p>
<p class="MsoNormal" style='TEXT-INDENT:0.5in;mso-layout-grid-align:none'><span style="FONT-SIZE:11pt;FONT-FAMILY:'Courier New'"><o:p> </o:p>
</span></p>
<p class="MsoNormal" style='TEXT-INDENT:0.5in;mso-layout-grid-align:none'><span class="GramE"><span style="FONT-SIZE:11pt;
FONT-FAMILY:'Courier New'">or</span>
</span><span style="FONT-SIZE:11pt;
FONT-FAMILY:'Courier New'">, if you want to test it directly from the Query
Analyzer:<o:p></o:p></span></p>
<p class="MsoNormal" style='TEXT-INDENT:0.5in;mso-layout-grid-align:none'><span class="GramE"><span style="FONT-SIZE:11pt;
FONT-FAMILY:'Courier New'">declare</span>
</span><span style="FONT-SIZE:11pt;
FONT-FAMILY:'Courier New'"> @response <span class="SpellE">varchar</span>(8000)<o:p></o:p></span></p>
<p class="MsoNormal" style='TEXT-INDENT:0.5in;mso-layout-grid-align:none'><span class="GramE"><span style="FONT-SIZE:11pt;
FONT-FAMILY:'Courier New'">exec</span>
</span><span style="FONT-SIZE:11pt;
FONT-FAMILY:'Courier New'"> <span class="SpellE">spUpdateRssFeed</span> <<span class="SpellE">SpecialOfferID</span>>, @response out<o:p></o:p></span></p>
<p style='MARGIN:0in 0in 0pt 0.25in;TEXT-INDENT:0.5in'><span class="GramE"><span style="FONT-SIZE:11pt;FONT-FAMILY:'Courier New'">print</span>
</span><span style="FONT-SIZE:11pt;FONT-FAMILY:'Courier New'"> @response</span><span style="FONT-SIZE:10pt;FONT-FAMILY:'Courier New'"><o:p></o:p>
</span></p>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -