 <?xml-stylesheet type="text/css" href="http://www.prlsoftware.com/Data/style/rss1.css" ?> <?xml-stylesheet type="text/xsl" href="http://www.prlsoftware.com/Data/style/rss1.xsl" ?>
<rss version="2.0">
  <channel>
    <title>Tips n Tricks</title>
    <link>http://www.prlsoftware.com/tips-n-tricks.aspx</link>
    <description>SQL Server Tips and Tricks</description>
    <copyright>Copyright 2009 Philip Leitch</copyright>
    <docs>http://www.rssboard.org/rss-specification</docs>
    <generator>mojoPortal Blog Module</generator>
    <managingEditor>Philip@prlsoftware.com</managingEditor>
    <ttl>120</ttl>
    <item>
      <title>Identity Insert Options</title>
      <description><![CDATA[Here are the Help definitions:
&#160;
IDENT_CURRENT returns the last identity value generated for a specific table in any session and any scope.
&#160;
@@IDENTITY returns the last identity value generated for any table in the current session,... <a href='http://www.prlsoftware.com/identity-insert-options.aspx'>read more</a><div>&nbsp;</div>]]></description>
      <link>http://www.prlsoftware.com/identity-insert-options.aspx</link>
      <author>Philip Leitch</author>
      <comments>http://www.prlsoftware.com/identity-insert-options.aspx</comments>
      <guid isPermaLink="true">http://www.prlsoftware.com/identity-insert-options.aspx</guid>
      <pubDate>Fri, 07 Aug 2009 05:45:17 GMT</pubDate>
    </item>
    <item>
      <title>Hypothetical Indexes</title>
      <description><![CDATA[Normal
 0
 
 
 false
 false
 false
 
  
  
  
  
  
 
 MicrosoftInternetExplorer4
 

 
 




 /* Style Definitions */
 table.MsoNormalTable
	{mso-style-name:"Table... <a href='http://www.prlsoftware.com/hypothetical-indexes.aspx'>read more</a><div>&nbsp;</div>]]></description>
      <link>http://www.prlsoftware.com/hypothetical-indexes.aspx</link>
      <author>Philip Leitch</author>
      <comments>http://www.prlsoftware.com/hypothetical-indexes.aspx</comments>
      <guid isPermaLink="true">http://www.prlsoftware.com/hypothetical-indexes.aspx</guid>
      <pubDate>Fri, 07 Aug 2009 05:38:33 GMT</pubDate>
    </item>
    <item>
      <title>SP_ Prefix</title>
      <description><![CDATA[What is it?
SP_ indicates a "System Procedure".&#160; Any user with enough rights can create a system procedure.
What does it do?
They provide global scope to a Stored Procedure.&#160; A procedure is normally only visible when it exists in the... <a href='http://www.prlsoftware.com/sp_-prefix.aspx'>read more</a><div>&nbsp;</div>]]></description>
      <link>http://www.prlsoftware.com/sp_-prefix.aspx</link>
      <author>Philip Leitch</author>
      <comments>http://www.prlsoftware.com/sp_-prefix.aspx</comments>
      <guid isPermaLink="true">http://www.prlsoftware.com/sp_-prefix.aspx</guid>
      <pubDate>Sat, 20 Jun 2009 04:20:05 GMT</pubDate>
    </item>
  </channel>
</rss>
