<rss version="2.0"><channel><title>Software Development</title><item><title><![CDATA[Software application development ways:Prototyping model]]></title><link><![CDATA[http://www.progx.us:80/progxus/Default.aspx?pg=366e0caf-9620-4376-9259-938cda3dd6b1&detail=ccf6c386-07a7-44c6-8a8a-1e86f1c364a7#094c838b-0213-43d9-aef7-0e93f6e36a82]]></link><description><![CDATA[<p><font size="3">Software prototyping, is the framework of activities during Software application development of creating prototypes, i.e., incomplete versions of the software program being developed.</font> </p>
<strong>Basic principles of prototyping are:</strong>
<ul type="disc">
    <li>Not a standalone, complete development methodology, but rather an approach to handling selected portions of a larger, more traditional development methodology (i.e. Incremental, Spiral, or Rapid Application Development (RAD)). </li>
    <li>Attempts to reduce inherent project risk by breaking a project into smaller segments and providing more ease-of-change during the development process. </li>
    <li>User is involved throughout the process, which increases the likelihood of user acceptance of the final implementation. </li>
    <li>Small-scale mock-ups of the system are developed following an iterative modification process until the prototype evolves to meet the users’ requirements. </li>
    <li>While most prototypes are developed with the expectation that they will be discarded, it is possible in some cases to evolve from prototype to working system. </li>
</ul>
<p><em>A basic understanding of the fundamental business problem is necessary to avoid solving the wrong problem</em></p>
<div><strong>Advantages</strong></div>
<ul type="disc">
    <li><span style="FONT-SIZE: 10pt">Simple and easy to use.</span> </li>
    <li><span style="FONT-SIZE: 10pt">Each phase has specific deliverables. </span></li>
    <li><span style="FONT-SIZE: 10pt">Higher chance of success over the waterfall model due to the development of test plans early on during the life cycle. </span></li>
    <li><span style="FONT-SIZE: 10pt">Works well for small projects where requirements are easily understood.</span> </li>
</ul>
<div><strong>Disadvantages</strong></div>
<ul type="disc">
    <li><span style="FONT-SIZE: 10pt">Very rigid, like the waterfall model. </span></li>
    <li><span style="FONT-SIZE: 10pt">Little flexibility and adjusting scope is difficult and expensive. </span></li>
    <li><span style="FONT-SIZE: 10pt">Software is developed during the implementation phase, so no early prototypes of the software are produced. </span></li>
    <li><span style="FONT-SIZE: 10pt">Model doesn’t provide a clear path for problems found during testing phases.</span> </li>
</ul>]]></description></item><item><title><![CDATA[Software application development ways:Waterfall model]]></title><link><![CDATA[http://www.progx.us:80/progxus/Default.aspx?pg=366e0caf-9620-4376-9259-938cda3dd6b1&detail=43691f32-1ad6-4e99-a38f-7da87065dd0d#094c838b-0213-43d9-aef7-0e93f6e36a82]]></link><description><![CDATA[<h1><strong>Software application development ways</strong></h1>
<p>Every software development methodology has more or less its own approach to software development. There is a set of more general approaches, which are developed into several specific methodologies. These approaches are:<br />
<strong>Waterfall:</strong> linear framework type. <br />
<strong>Prototyping:</strong> iterative framework type <br />
<strong>Incremental:</strong> combination of linear and iterative framework type <br />
<strong>Spiral:</strong> combination linear and iterative framework type <br />
<strong>Rapid Application Development (RAD):</strong> Iterative Framework Type <br />
<font size="5"><strong><u>Waterfall model</u></strong></font><br />
This is classical model of Software application development  The waterfall model is a sequential development process, in which development is seen as flowing steadily downwards (like a waterfall) through the phases of requirements analysis, design, implementation, testing (validation), integration, and maintenance. The first formal description of the waterfall model is often cited to be an article published by Winston W. Royce in 1970 although Royce did not use the term "waterfall" in this article.<br />
Basic principles of the waterfall model are:<br />
</p>
<div style="TEXT-INDENT: -0.25in; MARGIN: 0in 0in 0pt 0.5in"><span>·<span style="FONT: 7pt 'Times New Roman'">         </span></span><span style="LINE-HEIGHT: 115%; FONT-SIZE: 9pt">Project is divided into sequential phases, with some overlap acceptable between phases.</span></div>
<div style="TEXT-INDENT: -0.25in; MARGIN: 0in 0in 0pt 0.5in"><span>·<span style="FONT: 7pt 'Times New Roman'">         </span></span><span style="LINE-HEIGHT: 115%; FONT-SIZE: 9pt">Emphasis is on planning, time schedules, target dates, budgets and implementation of an entire system at one time. </span></div>
<div style="TEXT-INDENT: -0.25in; MARGIN: 0in 0in 10pt 0.5in"><span>·<span style="FONT: 7pt 'Times New Roman'">         </span></span><span style="LINE-HEIGHT: 115%; FONT-SIZE: 9pt">Tight control is maintained over the life of the project through the use of extensive written documentation, as well as through formal reviews and approval/signoff by the user and information technology management occurring at the end of most phases before beginning the next phase.</span></div>
<p><br />
<strong><em><font size="4">Advantages:</font></em></strong><br />
Simple and easy to use. <br />
Easy to manage due to the rigidity of the model – each phase has specific deliverables and a review process. <br />
Phases are processed and completed one at a time. <br />
Works well for smaller projects where requirements are very well understood. <br />
<strong><em><font size="4">Disadvantages:</font></em></strong><br />
Adjusting scope during the life cycle can kill a project <br />
No working software is produced until late during the life cycle. <br />
High amounts of risk and uncertainty. <br />
Poor model for complex and object-oriented projects. <br />
Poor model for long and ongoing projects. <br />
Poor model where requirements are at a moderate to high risk of changing. </p>
<p> </p>]]></description></item><item><title><![CDATA[AddUsersToRoles Procedure with your custom COLLATE]]></title><link><![CDATA[http://www.progx.us:80/progxus/Default.aspx?pg=366e0caf-9620-4376-9259-938cda3dd6b1&detail=f0e9a663-ae3c-4c13-9004-48684b6c6d61#094c838b-0213-43d9-aef7-0e93f6e36a82]]></link><description><![CDATA[<font color="#0000ff" size="2"><font color="#0000ff" size="2">
<p>USE</p>
<p>GO</p>
</font></font><font size="2"> [<font color="#ff6600">YordatabaseName</font>]</font><font color="#008000" size="2"><font color="#008000" size="2">
<p>/****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_AddUsersToRoles] Script Date: 06/17/2009 13:22:03 ******/</p>
</font></font><font color="#0000ff" size="2"><font color="#0000ff" size="2">
<p>SET</p>
</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">ANSI_NULLS</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">ON</font></font><font size="2">
<p>GO</p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">
<p>SET</p>
</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">QUOTED_IDENTIFIER</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">OFF</font></font><font size="2">
<p>GO</p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">
<p>CREATE</p>
<p>@ApplicationName </p>
</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">PROCEDURE</font></font><font size="2"> [dbo]</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">[aspnet_UsersInRoles_AddUsersToRoles]</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">nvarchar</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">256</font><font color="#808080" size="2"><font color="#808080" size="2">),</font></font><font size="2">
<p>@UserNames </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">nvarchar</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">4000</font><font color="#808080" size="2"><font color="#808080" size="2">),</font></font><font size="2">
<p>@RoleNames </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">nvarchar</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">4000</font><font color="#808080" size="2"><font color="#808080" size="2">),</font></font><font size="2">
<p>@CurrentTimeUtc </p>
<p>AS</p>
<p>BEGIN</p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">datetime</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">DECLARE</font></font><font size="2"> @AppId </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">uniqueidentifier</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> @AppId </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">NULL</font></font><font size="2">
<p> </p>
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> @AppId </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> ApplicationId </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">FROM</font></font><font size="2"> aspnet_Applications </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">WHERE</font></font><font size="2"> </font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">LOWER</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">@ApplicationName</font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> LoweredApplicationName</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">IF</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">@AppId </font><font color="#808080" size="2"><font color="#808080" size="2">IS</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">NULL)</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">RETURN</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">2</font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">DECLARE</font></font><font size="2"> @TranStarted </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">bit</font></font><font size="2">
<p> </p>
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SET</font></font><font size="2"> @TranStarted </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> 0</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">IF</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2"> </font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">@@TRANCOUNT</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> 0 </font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">BEGIN</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">BEGIN</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">TRANSACTION</font></font><font size="2">
<p> </p>
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SET</font></font><font size="2"> @TranStarted </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> 1</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">END</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">DECLARE</font></font><font size="2"> @tbNames </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">table</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font color="#0000ff" size="2"><font color="#0000ff" size="2">Name</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">nvarchar</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">256</font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">COLLATE</font></font><font size="2"> <font color="#ffff00"><strong><u><font color="#ff6600">YorCollate </font>_AS</u></strong></font> </font><font color="#808080" size="2"><font color="#808080" size="2">NOT</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">NULL</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">PRIMARY</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">KEY</font></font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">DECLARE</font></font><font size="2"> @tbRoles </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">table</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">RoleId </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">uniqueidentifier</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">NOT</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">NULL</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">PRIMARY</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">KEY</font></font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">DECLARE</font></font><font size="2"> @tbUsers </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">table</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">UserId </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">uniqueidentifier</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">NOT</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">NULL</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">PRIMARY</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">KEY</font></font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">DECLARE</font></font><font size="2"> @Num </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">int</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">DECLARE</font></font><font size="2"> @Pos </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">int</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">DECLARE</font></font><font size="2"> @NextPos </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">int</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">DECLARE</font></font><font size="2"> @Name </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">nvarchar</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">256</font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
<p> </p>
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SET</font></font><font size="2"> @Num </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> 0</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SET</font></font><font size="2"> @Pos </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> 1</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">WHILE</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">@Pos </font><font color="#808080" size="2"><font color="#808080" size="2"><=</font></font><font size="2"> </font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">LEN</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">@RoleNames</font><font color="#808080" size="2"><font color="#808080" size="2">))</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">BEGIN</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> @NextPos </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> </font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">CHARINDEX</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">N</font><font color="#ff0000" size="2"><font color="#ff0000" size="2">','</font></font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> @RoleNames</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> @Pos</font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">IF</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">@NextPos </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> 0 </font><font color="#808080" size="2"><font color="#808080" size="2">OR</font></font><font size="2"> @NextPos </font><font color="#808080" size="2"><font color="#808080" size="2">IS</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">NULL)</font></font><font size="2">
<p> </p>
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> @NextPos </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> </font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">LEN</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">@RoleNames</font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">+</font></font><font size="2"> 1</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> @Name </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> </font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">RTRIM</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">LTRIM</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">SUBSTRING</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">@RoleNames</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> @Pos</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> @NextPos </font><font color="#808080" size="2"><font color="#808080" size="2">-</font></font><font size="2"> @Pos</font><font color="#808080" size="2"><font color="#808080" size="2">)))</font></font><font size="2">
<p> </p>
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> @Pos </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> @NextPos</font><font color="#808080" size="2"><font color="#808080" size="2">+</font></font><font size="2">1</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">INSERT</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">INTO</font></font><font size="2"> @tbNames </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">VALUES</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">@Name</font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SET</font></font><font size="2"> @Num </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> @Num </font><font color="#808080" size="2"><font color="#808080" size="2">+</font></font><font size="2"> 1</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">END</font></font><font size="2">
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">INSERT</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">INTO</font></font><font size="2"> @tbRoles</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> RoleId</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">FROM</font></font><font size="2"> dbo</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">aspnet_Roles ar</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> @tbNames t</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">WHERE</font></font><font size="2"> </font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">LOWER</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">t</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font color="#0000ff" size="2"><font color="#0000ff" size="2">Name</font></font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> ar</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">LoweredRoleName </font><font color="#808080" size="2"><font color="#808080" size="2">AND</font></font><font size="2"> ar</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">ApplicationId </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> @AppId</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">IF</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">@@ROWCOUNT</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2"><></font></font><font size="2"> @Num</font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">BEGIN</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">TOP</font></font><font size="2"> 1 </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">Name</font></font><font size="2">
<p> </p>
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">FROM</font></font><font size="2"> @tbNames</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">WHERE</font></font><font size="2"> </font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">LOWER</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font color="#0000ff" size="2"><font color="#0000ff" size="2">Name</font></font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">NOT</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">IN</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> ar</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">LoweredRoleName </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">FROM</font></font><font size="2"> dbo</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">aspnet_Roles ar</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> @tbRoles r </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">WHERE</font></font><font size="2"> r</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">RoleId </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> ar</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">RoleId</font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">IF</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2"> @TranStarted </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> 1 </font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">ROLLBACK</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">TRANSACTION</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">RETURN</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">2</font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">END</font></font><font size="2">
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">DELETE</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">FROM</font></font><font size="2"> @tbNames </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">WHERE</font></font><font size="2"> 1</font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2">1</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SET</font></font><font size="2"> @Num </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> 0</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SET</font></font><font size="2"> @Pos </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> 1</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">WHILE</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">@Pos </font><font color="#808080" size="2"><font color="#808080" size="2"><=</font></font><font size="2"> </font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">LEN</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">@UserNames</font><font color="#808080" size="2"><font color="#808080" size="2">))</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">BEGIN</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> @NextPos </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> </font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">CHARINDEX</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">N</font><font color="#ff0000" size="2"><font color="#ff0000" size="2">','</font></font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> @UserNames</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> @Pos</font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">IF</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">@NextPos </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> 0 </font><font color="#808080" size="2"><font color="#808080" size="2">OR</font></font><font size="2"> @NextPos </font><font color="#808080" size="2"><font color="#808080" size="2">IS</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">NULL)</font></font><font size="2">
<p> </p>
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> @NextPos </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> </font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">LEN</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">@UserNames</font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">+</font></font><font size="2"> 1</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> @Name </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> </font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">RTRIM</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">LTRIM</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">SUBSTRING</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">@UserNames</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> @Pos</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> @NextPos </font><font color="#808080" size="2"><font color="#808080" size="2">-</font></font><font size="2"> @Pos</font><font color="#808080" size="2"><font color="#808080" size="2">)))</font></font><font size="2">
<p> </p>
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> @Pos </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> @NextPos</font><font color="#808080" size="2"><font color="#808080" size="2">+</font></font><font size="2">1</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">INSERT</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">INTO</font></font><font size="2"> @tbNames </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">VALUES</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">@Name</font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SET</font></font><font size="2"> @Num </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> @Num </font><font color="#808080" size="2"><font color="#808080" size="2">+</font></font><font size="2"> 1</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">END</font></font><font size="2">
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">INSERT</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">INTO</font></font><font size="2"> @tbUsers</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> UserId</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">FROM</font></font><font size="2"> dbo</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">aspnet_Users ar</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> @tbNames t</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">WHERE</font></font><font size="2"> </font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">LOWER</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">t</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font color="#0000ff" size="2"><font color="#0000ff" size="2">Name</font></font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> ar</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">LoweredUserName </font><font color="#808080" size="2"><font color="#808080" size="2">AND</font></font><font size="2"> ar</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">ApplicationId </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> @AppId</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">IF</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">@@ROWCOUNT</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2"><></font></font><font size="2"> @Num</font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">BEGIN</font></font><font size="2">
<p> </p>
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">DELETE</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">FROM</font></font><font size="2"> @tbNames</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">WHERE</font></font><font size="2"> </font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">LOWER</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font color="#0000ff" size="2"><font color="#0000ff" size="2">Name</font></font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">IN</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> LoweredUserName </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">FROM</font></font><font size="2"> dbo</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">aspnet_Users au</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> @tbUsers u </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">WHERE</font></font><font size="2"> au</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">UserId </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> u</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">UserId</font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">INSERT</font></font><font size="2"> dbo</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">aspnet_Users </font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">ApplicationId</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> UserId</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> UserName</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> LoweredUserName</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> IsAnonymous</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> LastActivityDate</font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> @AppId</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> </font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">NEWID</font></font><font color="#808080" size="2"><font color="#808080" size="2">(),</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">Name</font></font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> </font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">LOWER</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font color="#0000ff" size="2"><font color="#0000ff" size="2">Name</font></font><font color="#808080" size="2"><font color="#808080" size="2">),</font></font><font size="2"> 0</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> @CurrentTimeUtc</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">FROM</font></font><font size="2"> @tbNames</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">INSERT</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">INTO</font></font><font size="2"> @tbUsers</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> UserId</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">FROM</font></font><font size="2"> dbo</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">aspnet_Users au</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> @tbNames t</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">WHERE</font></font><font size="2"> </font><font color="#ff00ff" size="2"><font color="#ff00ff" size="2">LOWER</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">t</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font color="#0000ff" size="2"><font color="#0000ff" size="2">Name</font></font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> au</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">LoweredUserName </font><font color="#808080" size="2"><font color="#808080" size="2">AND</font></font><font size="2"> au</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">ApplicationId </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> @AppId</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">END</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">IF</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">(EXISTS</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> </font><font color="#808080" size="2"><font color="#808080" size="2">*</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">FROM</font></font><font size="2"> dbo</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">aspnet_UsersInRoles ur</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> @tbUsers tu</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> @tbRoles tr </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">WHERE</font></font><font size="2"> tu</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">UserId </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> ur</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">UserId </font><font color="#808080" size="2"><font color="#808080" size="2">AND</font></font><font size="2"> tr</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">RoleId </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> ur</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">RoleId</font><font color="#808080" size="2"><font color="#808080" size="2">))</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">BEGIN</font></font><font size="2">
<p> </p>
<p> </p>
<p> </p>
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">TOP</font></font><font size="2"> 1 UserName</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> RoleName</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">FROM</font></font><font size="2"> dbo</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">aspnet_UsersInRoles ur</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> @tbUsers tu</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> @tbRoles tr</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> aspnet_Users u</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> aspnet_Roles r</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">WHERE</font></font><font size="2"> u</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">UserId </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> tu</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">UserId </font><font color="#808080" size="2"><font color="#808080" size="2">AND</font></font><font size="2"> r</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">RoleId </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> tr</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">RoleId </font><font color="#808080" size="2"><font color="#808080" size="2">AND</font></font><font size="2"> tu</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">UserId </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> ur</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">UserId </font><font color="#808080" size="2"><font color="#808080" size="2">AND</font></font><font size="2"> tr</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">RoleId </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> ur</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">RoleId</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">IF</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2"> @TranStarted </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> 1 </font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">ROLLBACK</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">TRANSACTION</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">RETURN</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">3</font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">END</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">INSERT</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">INTO</font></font><font size="2"> dbo</font><font color="#808080" size="2"><font color="#808080" size="2">.</font></font><font size="2">aspnet_UsersInRoles </font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">UserId</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> RoleId</font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
<p> </p>
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">SELECT</font></font><font size="2"> UserId</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> RoleId</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">FROM</font></font><font size="2"> @tbUsers</font><font color="#808080" size="2"><font color="#808080" size="2">,</font></font><font size="2"> @tbRoles</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">IF</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2"> @TranStarted </font><font color="#808080" size="2"><font color="#808080" size="2">=</font></font><font size="2"> 1 </font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">COMMIT</font></font><font size="2"> </font><font color="#0000ff" size="2"><font color="#0000ff" size="2">TRANSACTION</font></font><font size="2">
<p> </p>
</font><font color="#0000ff" size="2"><font color="#0000ff" size="2">RETURN</font></font><font color="#808080" size="2"><font color="#808080" size="2">(</font></font><font size="2">0</font><font color="#808080" size="2"><font color="#808080" size="2">)</font></font><font color="#0000ff" size="2"><font color="#0000ff" size="2">
<p>END</p>
</font></font><font size="2"> </font>]]></description></item><item><title><![CDATA[Resetting Password with ASP.NET 2.0 Membership,Using Multiple Membership Providers]]></title><link><![CDATA[http://www.progx.us:80/progxus/Default.aspx?pg=366e0caf-9620-4376-9259-938cda3dd6b1&detail=00e12759-0816-45ca-a9bb-ce47858d606d#094c838b-0213-43d9-aef7-0e93f6e36a82]]></link><description><![CDATA[<div style="MARGIN: 0in 0in 10pt"><strong>By Tigran Sargsyan </strong></div>
<div style="MARGIN: 0in 0in 10pt"><strong><a href="http://www.progx.us">www.progx.us</a></strong></div>
<div style="MARGIN: 0in 0in 10pt"> </div>
<div style="MARGIN: 0in 0in 10pt">In asp.net 2 you can use Membership class to reset a user password. Which has 2 Overloaded Variants? </div>
<div style="MARGIN: 0in 0in 10pt">1.) Reason to use for admin tool </div>
<div style="MARGIN: 0in 0in 10pt">//This Variant for admin part password reset</div>
<div style="MARGIN: 0in 0in 10pt"><span style="LINE-HEIGHT: 115%; COLOR: teal; FONT-SIZE: 10pt">MembershipUser</span><span style="LINE-HEIGHT: 115%; FONT-SIZE: 10pt"> Myuser;</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: #17365d; FONT-SIZE: 10pt">string</span><span style="FONT-SIZE: 10pt">  UserName =””;// change “” to UserName </span>which <span style="FONT-SIZE: 10pt">password need to reset    <span style="COLOR: teal">Membership</span>.Providers[<span style="COLOR: maroon">"AdminMembershipProvider"</span>].GetUser(UserName,<span style="COLOR: blue">false</span>);</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt">      <span style="COLOR: blue">if</span> (Myuser != <span style="COLOR: blue">null</span>)</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt">      {</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"> </div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"> </div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt">          </span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt">          pass = Myuser.ResetPassword();</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt">         </span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt">            </span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"> </div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt">      }</span></div>
<div style="MARGIN: 0in 0in 10pt"><span style="LINE-HEIGHT: 115%; FONT-SIZE: 10pt">2)</span> Reason to use for simple user interface In password recovery for example. This variant needs </div>
<div style="MARGIN: 0in 0in 10pt"> </div>
<div style="MARGIN: 0in 0in 10pt"><span style="LINE-HEIGHT: 115%; COLOR: teal; FONT-SIZE: 10pt">MembershipUser</span><span style="LINE-HEIGHT: 115%; FONT-SIZE: 10pt"> Myuser;</span></div>
<div style="MARGIN: 0in 0in 10pt"><span style="LINE-HEIGHT: 115%; COLOR: #17365d; FONT-SIZE: 10pt">string</span><span style="LINE-HEIGHT: 115%; FONT-SIZE: 10pt">  UserName =””;// change “” to UserName </span>which <span style="LINE-HEIGHT: 115%; FONT-SIZE: 10pt">password need to reset    </span></div>
<div style="MARGIN: 0in 0in 10pt"> </div>
<div style="MARGIN: 0in 0in 10pt"><span style="LINE-HEIGHT: 115%; COLOR: #17365d; FONT-SIZE: 10pt">string</span><span style="LINE-HEIGHT: 115%; FONT-SIZE: 10pt"> passwordanswer=””;//change “” with answer of secure quastion</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt">      Myuser= <span style="COLOR: teal">Membership</span>.Providers[<span style="COLOR: maroon">"AdminMembershipProvider"</span>].GetUser(UserName,<span style="COLOR: blue">false</span>);</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt">      <span style="COLOR: blue">if</span> (Myuser != <span style="COLOR: blue">null</span>)</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt">      {</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"> </div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"> </div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt">          </span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt">          pass = Myuser.ResetPassword(passwordanswer);</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt">         </span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt">            </span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"> </div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt">      }</span></div>
<div style="MARGIN: 0in 0in 10pt"> </div>
<div style="MARGIN: 0in 0in 10pt">!!!File web.config for this example </div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt"><</span><span style="COLOR: maroon; FONT-SIZE: 10pt">membership</span><span style="COLOR: red; FONT-SIZE: 10pt">defaultProvider</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: #17365d">DefaultMembershipProvider</span>"<span style="COLOR: blue">></span></span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"> </div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">      <</span><span style="COLOR: maroon; FONT-SIZE: 10pt">providers</span><span style="COLOR: blue; FONT-SIZE: 10pt">></span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"> </div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">             <</span><span style="COLOR: maroon; FONT-SIZE: 10pt">add</span><span style="COLOR: red; FONT-SIZE: 10pt">name</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: #17365d">DefaultMembershipProvider</span>"</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">                                </span><span style="COLOR: red; FONT-SIZE: 10pt">connectionStringName</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: blue">ConnectionString</span>"</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">                                </span><span style="COLOR: red; FONT-SIZE: 10pt">applicationName</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: #17365d">DefaultMembershipProvider</span>"</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">                                </span><span style="COLOR: red; FONT-SIZE: 10pt">enablePasswordRetrieval</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: blue">false</span>"</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">                                </span><span style="COLOR: red; FONT-SIZE: 10pt">enablePasswordReset</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: blue">true</span>"</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">                                </span><span style="COLOR: red; FONT-SIZE: 10pt">requiresQuestionAndAnswer</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: blue">true</span>"</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">                                </span><span style="COLOR: red; FONT-SIZE: 10pt">requiresUniqueEmail</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: blue">false</span>"</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">                                </span><span style="COLOR: red; FONT-SIZE: 10pt">passwordFormat</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: blue">Hashed</span>"</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">                                </span><span style="COLOR: red; FONT-SIZE: 10pt">type</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: blue">System.Web.Security.SqlMembershipProvider</span>"</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">                                </span><span style="COLOR: red; FONT-SIZE: 10pt">maxInvalidPasswordAttempts</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: blue">7</span>"</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">/></span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">      </span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">             <</span><span style="COLOR: maroon; FONT-SIZE: 10pt">add</span><span style="COLOR: red; FONT-SIZE: 10pt">name</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: blue">AdminMembershipProvider</span>"</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">                         </span><span style="COLOR: red; FONT-SIZE: 10pt">connectionStringName</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: blue">ConnectionString</span>"</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">                     </span><span style="COLOR: red; FONT-SIZE: 10pt">applicationName</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: blue">MyMembership</span>"</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">                     </span><span style="COLOR: red; FONT-SIZE: 10pt">enablePasswordRetrieval</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: blue">false</span>"</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">                     </span><span style="COLOR: red; FONT-SIZE: 10pt">enablePasswordReset</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: blue">true</span>"</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">                     </span><span style="COLOR: red; FONT-SIZE: 10pt">requiresQuestionAndAnswer</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: blue">false</span>"</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">                     </span><span style="COLOR: red; FONT-SIZE: 10pt">requiresUniqueEmail</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: blue">false</span>"</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">                     </span><span style="COLOR: red; FONT-SIZE: 10pt">passwordFormat</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: blue">Hashed</span>"</span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">                     </span><span style="COLOR: red; FONT-SIZE: 10pt">type</span><span style="COLOR: blue; FONT-SIZE: 10pt">=</span><span style="FONT-SIZE: 10pt">"<span style="COLOR: blue">System.Web.Security.SqlMembershipProvider</span>"<span style="COLOR: blue"> /></span></span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">                     </span></div>
<div style="LINE-HEIGHT: normal; MARGIN: 0in 0in 0pt"><span style="COLOR: blue; FONT-SIZE: 10pt">       </span></div>
<div style="MARGIN: 0in 0in 10pt"><span style="LINE-HEIGHT: 115%; COLOR: blue; FONT-SIZE: 10pt">       </span><span style="LINE-HEIGHT: 115%; COLOR: blue; FONT-SIZE: 10pt"></</span><span style="LINE-HEIGHT: 115%; COLOR: maroon; FONT-SIZE: 10pt">providers</span><span style="LINE-HEIGHT: 115%; COLOR: blue; FONT-SIZE: 10pt">></span> </div>
<div style="MARGIN: 0in 0in 10pt"> </div>
<div style="MARGIN: 0in 0in 10pt">You can use 2 membership provider for same asp.net web application.</div>]]></description></item><item><title><![CDATA[10 Minutes to Your Google Sitemap...]]></title><link><![CDATA[http://www.progx.us:80/progxus/Default.aspx?pg=366e0caf-9620-4376-9259-938cda3dd6b1&detail=08941528-285f-4276-81ef-567164cdd1a5#094c838b-0213-43d9-aef7-0e93f6e36a82]]></link><description><![CDATA[<table height="114" width="99%">
    <tbody>
        <tr>
            <td align="left" height="22">
            <div align="justify"><span class="style7"><font face="Tahoma" color="#000000" size="4"><strong>10 Minutes to Your Google Sitemap...</strong></font></span></div>
            </td>
        </tr>
        <tr>
            <td align="left" height="19">
            <div align="justify"><span class="style2"><strong><font color="#000000">by: <font face="Times New Roman" size="3">Ron Hutton</font></font></strong></span></div>
            </td>
        </tr>
        <tr>
            <td align="left" height="12"><span class="style2">Copyright 2005 Ron Hutton<br />
            <br />
            Google's calling your name... <br />
            <br />
            Hi, Google here. We want to index your website...<br />
            <br />
            Is anyone there?<br />
            <br />
            This article has a free corresponding online video tutorial that shows you how to summons the magic Googlebot to spider and index every page on your website, and it will only take about 10 minutes of your time.<br />
            <br />
            Go here now to watch exactly what to do, step-by-easy-step... <br />
            <br />
            http://www.gothrive.com/google-sitemap-video.htm<br />
            <br />
            What you have access to with the new Google Sitemaps program is truly a gift from the Google gods. They've offering you a tool that you can use to keep your site constantly indexed and updated in the search engine database. With Google Sitemaps, webmasters can now take charge and make sure that their entire site is crawled and indexed.<br />
            <br />
            One important note to make is that the Google Sitemaps program will not necessarily improve the ranking of your site's pages. It only ensures that Google knows what you've got online for them to look at.<br />
            <br />
            Before reading the following statement, promise yourself that you won't stop reading if you see a term that seems a little scary. OK? Promise? Good. Go ahead and keep reading then.<br />
            <br />
            The format specified by Google for "their" sitemap is XML (extensible markup language). Did I loose you yet? No? Good again.<br />
            <br />
            You do not need to understand how to code XML to participate in the Google Sitemap program. There are plenty of free online tools that will create your XML sitemap for you with no XML knowledge required on your part. More on this in a second.<br />
            <br />
            What information is including in this XML sitemap?<br />
            <br />
            1) The URL for every file on your website.<br />
            <br />
            2) A relative priority rank that you can assign telling Google which pages on your site are most important for them to look at.<br />
            <br />
            3) The date last modified for each page.<br />
            <br />
            4) Anticipated change frequency per URL. This again is a variable that you control.<br />
            <br />
            According to Google, your XML sitemap can include up to 50,000 URL's. If your site is a real monster and has in excess of 50,000 URL's, then you'll need to create a hierarchy of sitemaps with one leading to the next. This way you'll be able to lead Google to all of your pages.<br />
            <br />
            The options for generating and maintaining your Google Sitemap range from complex systems that are highly automated to very simple systems using online sitemap generators that require nothing more than clicking a few buttons.<br />
            <br />
            Google now keeps a list of these 'third party suppliers' of generators on their site. Find them here: http://code.google.com/sm_thirdparty.html <br />
            <br />
            The program that's demonstrated in our free video tutorial (http://www.gothrive.com/google-sitemap-video.htm) is found here: http://www.auditmypc.com/free-sitemap-generator.asp<br />
            <br />
            In a nutshell, here are the steps involved with using online generators:<br />
            <br />
            1) Start the program. <br />
            2) Enter your site's URL <br />
            3) Click the "Start Crawling" button <br />
            4) Customize URL priorities and change frequencies <br />
            5) Save the site map to your local hard drive <br />
            6) Upload your new Google XML sitemap to your website in the root directory (where your home page resides) <br />
            7) Validate your new sitemap <br />
            (can be done here: http://www.smart-it-consulting.com/internet/google/submit-validate-sitemap/) <br />
            8) Submit your XML sitemap to Google.<br />
            <br />
            You can access the pages for the Google Sitemap program here: https://www.google.com/webmasters/sitemaps/login<br />
            <br />
            8 steps in about 10 minutes. That's all there is to it.<br />
            <br />
            One question that you might ask is whether or not you still need an HTML sitemap, and the answer is "Yes, you still need your conventional sitemap". XML sitemaps are not intended for human visitors. To see what I mean, take a look at the two following sitemaps:<br />
            <br />
            HTML sitemap: http://www.gothrive.com/sitemap.html<br />
            <br />
            XML sitemap: http://www.gothrive.com/sitemap.xml<br />
            <br />
            Which version do you prefer? Your visitors will like the HTML and Google prefers XML. <br />
            <br />
            When you add pages or new content to your site and you want Google to go back to have a fresh look, just log in to your Google Sitemaps control panel, select the sitemap to revisit, and click "Resubmit". It's never been easier to get Google to spider and index a website. Don't miss your opportunity to use this tool to your advantage.<br />
            <br />
            <br />
            About the author:<br />
            Ron Hutton is a 20 year sales and marketing veteran with a passion for coaching and training. Subscribe to "GoThrive Online", for big juicy marketing tips in small, easy-to-chew, bite size servings. Free Video Tutorial Archives Here: http://www.gothrive.com/free-video-library/video-directory.html <br />
            </span></td>
        </tr>
    </tbody>
</table>]]></description></item><item><title><![CDATA[Network Marketing Do's and Don'ts]]></title><link><![CDATA[http://www.progx.us:80/progxus/Default.aspx?pg=366e0caf-9620-4376-9259-938cda3dd6b1&detail=a1c17b46-5596-4974-bb8f-089715199b34#094c838b-0213-43d9-aef7-0e93f6e36a82]]></link><description><![CDATA[<font color="#000000"><strong><font size="5">Network Marketing Do's and Don'ts</font><br />
 by: </strong></font><font color="#ff6600"><font color="#000000"><strong>Nial Robbins</strong></font> </font>
<p>Why did you become a network marketer? Most people immediately respond, “for the money!” However, this is not the real reason. </p>
<p>No one subjects them to the hard work of building a business just for little pieces of paper with the faces of dead presidents. The truth is you work in order to obtain what those little pieces of paper can bring you. </p>
<p>The first thing you need to do is to find the reason WHY you are a network marketer. Is it the freedom to choose whatever you want to do whenever you want to do it? Maybe you are looking for a different lifestyle. If there is one thing that is critical to your network marketing success, this is it. If you don’t have a reason, there is no motivation to succeed. </p>
<p>A network marketing business is a teaching and coaching business. If you don’t like interaction with other people, a network marketing business probably is not for you. There’s a concept that most network marketers just can’t seem to get a handle on. You do not sponsor “reps,” you sponsor “people!” </p>
<p>If you have to find a reason why you are building your business, then doesn’t it stand to reason that other people will have to do the same thing? If that’s the case, then why is it that network marketers continually focus on how much money your prospect can earn? </p>
<p>There’s no way you are going to convince “Joe Sixpack,” to get out of his Lazyboy recliner unless you find out what his motivation is. Most network marketers literally pound in the amount of money Joe can earn. They bombard him with message after message about how “Successful Sam” has just purchased his 10th Porsche, refurnished his 25,000 square foot cottage and promise Joe that he can do the same! </p>
<p>Just how realistic is this approach? Joe isn’t stupid. He works long, hard hours at his job in order to provide for his family and truly believes that the best thing he can hope for is saving enough money by summer to pay for a camping trip. Then here you come, promising Joe that he can have everything that Sam has and he can have it if he will just sign that piece of paper making you his sponsor! </p>
<p>You will probably sponsor a few people that way, but if you are in business for the long haul you need to change your approach and do it fast. </p>
<p>The proper approach is so simple, but in your rush to sponsor another “rep” instead of helping another person, all too often you talk yourself into and straight out of sponsoring the Joes of the world. </p>
<p>God gave you two ears and one mouth and he did it for a reason. We are supposed to “listen” twice as much as we “speak.” </p>
<p>Instead of pouncing on Joe with the latest and greatest network marketing program of all time, find out what Joe wants and needs. Ask him questions, lots of questions. In fact, in your first meeting with Joe, don’t even mention your business! Yes, that’s what I said. Don’t even bring it up. Remove yourself from the super duper network marketing persona and spend time making a new friend. </p>
<p>Follow these recommendations and you are set to grow your business exponentially. </p>
<p> </p>]]></description></item><item><title><![CDATA[Secret Signs of an Easy Home Business]]></title><link><![CDATA[http://www.progx.us:80/progxus/Default.aspx?pg=366e0caf-9620-4376-9259-938cda3dd6b1&detail=021c721c-880b-40b3-b188-1bfe6192aa70#094c838b-0213-43d9-aef7-0e93f6e36a82]]></link><description><![CDATA[<table height="114" width="99%">
    <tbody>
        <tr>
            <td align="left" height="22">
            <div align="justify"><span class="style7"><font face="Tahoma" color="#000000" size="4"><strong>6 Secret Signs of an Easy Home Business</strong></font></span></div>
            </td>
        </tr>
        <tr>
            <td align="left" height="19">
            <div align="justify"><span class="style2"><strong><font color="#000000">by: <font face="Times New Roman" size="3">Jack Sinclair</font></font></strong></span></div>
            </td>
        </tr>
        <tr>
            <td align="left" height="12"><span class="style2">If you take a look around the Internet, you'll find hundreds of thousands of people who are looking for an easy home business. But what exactly does EASY mean? The answer depends on who is answering the question! <br />
            <br />
            In this article, I'm going to show you six things that easy home businesses have in common - things you should look for when starting a low effort easy home business. Picking a business with these features will greatly increase your chance of success in your business ventures. <br />
            <br />
            Here are the six things to look for in an easy home business: <br />
            <br />
            1. A Well-Established Company With A Great Track Record <br />
            <br />
            It's no secret that most so-called easy home businesses fail. There are a thousand reasons why, and it would take a business degree to really understand it all, but one thing that easy home businesses share is a great track record. <br />
            <br />
            If a company is able to survive and thrive for 4 years, it means they have everything in place to run the business - and that means you can join up and hit the ground running. <br />
            <br />
            2. Popular Products <br />
            <br />
            This ties closely with Item 1 - an easy home business must have products that people want! It sounds simple, but many "fast cash" businesses you see being marketed on the Internet have products that you would NEVER buy in a thousand years. Yet they expect you to sell them! <br />
            <br />
            By choosing an easy home business that has products that are easy to sell, it makes everything easier. You don't need to twist arms, or deal with a high percentage of product returns. Everthing goes smoothly when people are calling YOU to order! <br />
            <br />
            3. No Large Up-Front Costs <br />
            <br />
            This might sound surprising, but CASH is in short supply when you start any easy home business. That's right - every easy home business has this problem. It's important to know that the cost of getting into a business is not your only cost - there are marketing costs to consider, for instance. How will you attract new customers and new sales? You'll need to have business cards, a telephone (try not to use your home phone, just in case your business skyrockets or, Lord fordbid, goes bankrupt), and other expenses. You may need to attend teleconferences, or travel to events, and these costs should be considered BEFORE you jump in to any easy home business with both feet. <br />
            <br />
            4 No Inventory to Maintain <br />
            <br />
            We've all seen the easy home business opportunity that lets you get in on their hot opportunity - if you'll fill your garage with products. Those days are gone! <br />
            <br />
            In today's environment, easy home businesses do all the product handling for you - they will produce it, package it, ship it, and even bill the customer on your behalf. Your only requirement is to tell them where to send your earnings! <br />
            <br />
            Be sure that the easy home business you choose has no inventory requirements. <br />
            <br />
            5. An Easy Way to Attract New Customers <br />
            <br />
            A great easy home business is one that has customers coming to YOU. This is achieved by having a system in place that lets customers find you. <br />
            <br />
            6. A Great Marketing System <br />
            <br />
            The best easy home businesses come with a fine-tuned marketing system that you can use. This is a system that you can plug into with minimal effort, and see results in a very short timeframe. Things like replicated websites, co-op advertising, and low cost marketing kits are things that indicate a great marketing engine is in place. You'll need these tools if you are going to attract potential customers quickly. <br />
            <br />
            Summary <br />
            <br />
            If you spend some time looking at easy home businesses, you'll find some that have the six features in this arcticle. Choosing a business with these features is the best way to maximize your chances of success, and gives you a greater likelihood of seeing positive cashflow in a relatively short timeframe. There's no guarantees, but this checklist will really improve your odds of success! <br />
            <br />
            <br />
            About the author:<br />
            Jack Sinclair is a successful entrepreneur, Internet Marketer and loving husand and father who likes to help others succeed. Get his free 7 day course to learn how to find multiple income streams, at <a class="navigation" target="_blank" href="http://www.passive-income-source.com/">http://www.passive-income-source.com</a></span></td>
        </tr>
    </tbody>
</table>]]></description></item><item><title><![CDATA[Don't Focus too Much on your Internet Business Website Ranking]]></title><link><![CDATA[http://www.progx.us:80/progxus/Default.aspx?pg=366e0caf-9620-4376-9259-938cda3dd6b1&detail=7055fae3-52d9-4589-a75c-02ef2eaaafc6#094c838b-0213-43d9-aef7-0e93f6e36a82]]></link><description><![CDATA[<table height="114" width="99%">
    <tbody>
        <tr>
            <td align="left" height="22">
            <div align="justify"><span class="style7"><font face="Tahoma" color="#000000" size="4"><strong>Don't Focus too Much on your Internet Business Website Ranking </strong></font></span></div>
            </td>
        </tr>
        <tr>
            <td align="left" height="19">
            <div align="justify"><span class="style2"><strong><font color="#000000">by: <font face="Times New Roman" size="3">Arthur</font></font></strong></span></div>
            </td>
        </tr>
        <tr>
            <td align="left" height="12"><span class="style2">By © Arthur, The Online Internet Home Business Opportunity <br />
            <br />
            No doubt, having a high search engine ranking is very important to a home business owner as it will increase their business revenue. Much money have been spend on search engine optimization software, books, ebook and SEO services in order to obtain a high ranking website. <br />
            <br />
            The goal of every webmaster for their website is to obtain the HIGHEST ranking available in google. However, the algorithm <br />
            of google kept changing and it is not an easy task to reach that status. <br />
            <br />
            There are many OPEN secrets on how you can obtain a high ranking in the world largest search engine "google". <br />
            <br />
            The top open secret is to obtain reciprocal links by exchanging link with other website or one way back linking via article <br />
            writing, forum posting or even blogging. So if every webmaster have done that, then wouldn't all of them obtain a high ranking. <br />
            <br />
            As the largest search engine, google wouldn't be that dumb to just obtain the results just because a website has many thousands of links pointing to it. What usually happened is that if the knowledge is available to many of the webmaster, google engineers would know the strategy that millions of webmaster are applying. <br />
            <br />
            It will then lower the points given to linking and create new linking criteria such as: <br />
            - the number of relevant links pointing to the website <br />
            - the number of irrelevant links pointing to the website <br />
            - the number of relevant outgoing links pointing to other website <br />
            - the rank of the back linking website <br />
            - the anchor text used during the linking etc. <br />
            <br />
            As you can see, a high ranking strategy is a never ending ball game. The search engine criteria results will always be changing <br />
            and it will always remain an Internal Top Secrets for the Search Engine Companies. However, what google and other search <br />
            engine wants to achieve is that no one can or should be able to manipulate their search results. The end users of the search <br />
            engine will be to obtain nothing but RELEVANT results that they are searching for. <br />
            <br />
            All this is not that bad because it give new webmaster and their website a chance in the google search engine. As long as your <br />
            website contents are fresh, unique and relevant, it will stand a great chance of begin display in the google search engine results. Google employed many smart software engineers and any loop holes which webmaster tried to exploit now will eventually be cover up. Many webmasters have learn the hard way after their website are penalized for trying to exploit some of the search engine weakness. <br />
            <br />
            Therefore, do what you can to make your website search engine friendly but don't focus too much on your search engine <br />
            ranking. There are also other useful Internet Advertising method such as PPC Search Engine Advertising, Forum Posting, <br />
            Blogging etc. <br />
            <br />
            Wishing you success in advertising your Internet Business Website. <br />
            <br />
            About the author:<br />
            Copyright @ Arthur <br />
            <a class="navigation" target="_blank" href="http://www.online-internet-home-business-opportunity.com/">http://www.online-internet-home-business-opportunity.com</a><br />
            Helping to groom potential entrepreneurs into the next Business Star. Most Financial Successful individuals Grow Rich by starting their own business. You too can own your dream business. </span></td>
        </tr>
    </tbody>
</table>]]></description></item><item><title><![CDATA[5 Ways Google Will Help You With Your Traffic]]></title><link><![CDATA[http://www.progx.us:80/progxus/Default.aspx?pg=366e0caf-9620-4376-9259-938cda3dd6b1&detail=46879098-c13c-4c63-8368-3ed5b27f8be8#094c838b-0213-43d9-aef7-0e93f6e36a82]]></link><description><![CDATA[<font color="#000000"><strong><font size="5">5 Ways Google Will Help You With Your Traffic</font><br />
 by: </strong><strong>Tinu AbayomiPaul</strong></font><font color="#ff6600"> </font>
<p>If you’ve ever had a severe drop in your Google rankings in search results, you may think of Google more of an enemy than an ally. </p>
<p>But if you knew what I do, you’d realize that there are tools provided by the search engine that help you learn more about your traffic, and may even help drive visitors to your site. </p>
<p>Here are five ways that Google provides free traffic assistance. </p>
<p>#1 - Google will Help Your Pages Get Discovered with Google Sitemaps <br />
<a target="new" href="https://www.google.com/webmasters/sitemaps/login">https://www.google.com/webmasters/sitemaps/login</a> </p>
<p>Google Sitemaps is a program that gives you the opportunity to present your site’s pages to Google in XML or text. Google will then come by and spider the pages, getting you indexed faster. </p>
<p>Take note that this doesn’t necessarily mean that your pages will be listed for your favorite keywords, only that discovery will take place a lot faster than with manual submission. Google Sitemaps will also give you some basic site stats if you verify your site, such as the top keywords for discovery, errors it found when crawling, and the types of documents at your site. </p>
<p>If you find compiling your sitemap for Google in the correct format difficult, try the SOFTplus GSiteCrawler Google Sitemap generator. It’s my favorite Sitemap generator, free and easy to use. </p>
<p>#2 - Google Will Talk To You and Your Webmaster In His or Her Native Tongue or Plain English with the Webmaster Section <br />
<a target="new" href="http://www.google.com/webmasters/">http://www.google.com/webmasters/</a> </p>
<p>The Google Information Page for Webmasters should be your first stop when you want to know more about anything that has to do with your site and its relationship to Google and any of its many flavors of search such as Froogle. Particularly for new site owners or operators, checking this page first has saved many from needless anxiety. </p>
<p>Most of the basic information is in straightforward language, with links to details for geeks like me. </p>
<p>#3 - Google will Tell You What It Knows with Web Page Information </p>
<p>If you type info:yoursite.com into Google, Google will tell show you a page that has your link at the top of the page, with a short description, and the following phrase “Google can show you the following information for this URL”. </p>
<p>This special page compiles several queries about your site including pages that contain your URL (all the pages Google knows of that are linked to you). </p>
<p>#4 - Google will Help You Analyze Your Traffic with Google Analytics <br />
<a target="new" href="http://www.google.com/analytics/">http://www.google.com/analytics/</a> </p>
<p>After a recent purchase of Urchin Stats, a free online version has been made available, and re-branded as Google Analytics. This cookie-based invisible visitor tracker can give you information that go a bit beyond standard stats such as bounce rates, visitor loyalty, keyword discovery results for a single day, click paths through your site, and page views per visit. </p>
<p>With the ability to analyze your traffic, you can help learn where the holes in your site are, and how to keep them on your site for longer periods of time, as well as better ways to steer a visit towards a specific action, such as a subscription. Results come in flavors for the executive and the search marketer alike. </p>
<p>There’s currently a waiting list to use Google Analytics due to popular demand. </p>
<p>#5 - Google Will Advise On Getting the Most from Your Traffic with Conversion University <br />
<a target="new" href="http://www.google.com/analytics/conversionuniversity.html">http://www.google.com/analytics/conversionuniversity.html</a> </p>
<p>Google Analytics also has two content sections that are available to all, called Conversion University. While the articles are decidedly slanted towards AdWords users, a prudent read yields many clues that can be applied to preparing for visitors who arrive through organic search discovery. One reference area is called “Driving Traffic”, the other “Converting Visitors.” </p>
<p>At the end of the day, the process by which your site gets ranked in Google search engine results is a computation of a complex algorithm, which means Google - the search engine - really isn’t capable of being your best friend or your worst enemy. </p>
<p>Meanwhile, Google - the company - also provides access to resources that will help give your site a fighting chance. </p>
<p>Copyright 2005 Tinu AbayomiPaul </p>]]></description></item></channel></rss>