<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:georss="http://www.georss.org/georss" xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#" xmlns:media="http://search.yahoo.com/mrss/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>C#, ASP.NET, SQL Server</title>
	
	<link>http://mycodelines.wordpress.com</link>
	<description>(FAQ's + Code + Just about anything else...!)</description>
	<lastBuildDate>Tue, 11 Oct 2011 14:52:17 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.com/</generator>
<cloud domain="mycodelines.wordpress.com" port="80" path="/?rsscloud=notify" registerProcedure="" protocol="http-post" />
<image><url>http://www.feedburner.com/fb/images/pub/fb_pwrd.gif</url></image>
	<atom:link rel="search" type="application/opensearchdescription+xml" href="http://mycodelines.wordpress.com/osd.xml" title="C#, ASP.NET, SQL Server" />
	
		<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/CsharpAspnetSqlServer-sravanthi-codelines" /><feedburner:info uri="csharpaspnetsqlserver-sravanthi-codelines" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://mycodelines.wordpress.com/?pushpress=hub" /><feedburner:emailServiceId>CsharpAspnetSqlServer-sravanthi-codelines</feedburner:emailServiceId><feedburner:feedburnerHostname>http://feedburner.google.com</feedburner:feedburnerHostname><item>
		<title>VS 2008 Solution Explorer Autohide</title>
		<link>http://feedproxy.google.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~3/eIn0Q153pGM/</link>
		<comments>http://mycodelines.wordpress.com/2009/09/12/vs-2008-solution-explorer-autohide/#comments</comments>
		<pubDate>Sat, 12 Sep 2009 12:09:07 +0000</pubDate>
		<dc:creator>Lakshmi Sravanthi Chowdam</dc:creator>
				<category><![CDATA[Programming Tips & Tricks]]></category>
		<category><![CDATA[auto hide]]></category>
		<category><![CDATA[autohide]]></category>
		<category><![CDATA[IDE]]></category>
		<category><![CDATA[Solution explorer]]></category>
		<category><![CDATA[toolbox settings]]></category>
		<category><![CDATA[Visual studio 2008]]></category>
		<category><![CDATA[VS 2008]]></category>
		<category><![CDATA[windows settings]]></category>

		<guid isPermaLink="false">http://mycodelines.wordpress.com/2009/09/12/vs-2008-solution-explorer-autohide/</guid>
		
			<content:encoded><![CDATA[In Visual Studio 2008, I lost AutoHide feature on that window. when I right click on Solution explorer I see that AutoHide is disabled. How can I enable it.  2) Also I like all my autohide windows on...<br/>
<br/>
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~4/eIn0Q153pGM" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://mycodelines.wordpress.com/2009/09/12/vs-2008-solution-explorer-autohide/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
	
		<media:content url="http://0.gravatar.com/avatar/288f66c081902691113152e3f6bd6895?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">sravanthiwinner</media:title>
		</media:content>
	<feedburner:origLink>http://mycodelines.wordpress.com/2009/09/12/vs-2008-solution-explorer-autohide/</feedburner:origLink></item>
		<item>
		<title>Memory Leak in CLR</title>
		<link>http://feedproxy.google.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~3/ZNyX0dWwPeE/</link>
		<comments>http://mycodelines.wordpress.com/2009/09/05/memory-leak-in-clr/#comments</comments>
		<pubDate>Sat, 05 Sep 2009 06:33:50 +0000</pubDate>
		<dc:creator>Lakshmi Sravanthi Chowdam</dc:creator>
				<category><![CDATA[Framework]]></category>
		<category><![CDATA[C#]]></category>
		<category><![CDATA[CLR]]></category>
		<category><![CDATA[Dispose]]></category>
		<category><![CDATA[Finalize]]></category>
		<category><![CDATA[finally]]></category>
		<category><![CDATA[garbage collector]]></category>
		<category><![CDATA[GC]]></category>
		<category><![CDATA[memory]]></category>
		<category><![CDATA[memory leak]]></category>
		<category><![CDATA[using]]></category>

		<guid isPermaLink="false">http://mycodelines.wordpress.com/?p=307</guid>
		
			<content:encoded><![CDATA[Definition of memory leak A memory leak occurs when memory is allocated in a program and is never returned to the operating system, even though the program does not use the memory any longer. The...<br/>
<br/>
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~4/ZNyX0dWwPeE" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://mycodelines.wordpress.com/2009/09/05/memory-leak-in-clr/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://0.gravatar.com/avatar/288f66c081902691113152e3f6bd6895?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">sravanthiwinner</media:title>
		</media:content>
	<feedburner:origLink>http://mycodelines.wordpress.com/2009/09/05/memory-leak-in-clr/</feedburner:origLink></item>
		<item>
		<title>ISNULL vs. COALESCE</title>
		<link>http://feedproxy.google.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~3/h3G7pB2B_BU/</link>
		<comments>http://mycodelines.wordpress.com/2009/09/05/isnull-vs-coalesce/#comments</comments>
		<pubDate>Sat, 05 Sep 2009 05:41:57 +0000</pubDate>
		<dc:creator>Lakshmi Sravanthi Chowdam</dc:creator>
				<category><![CDATA[RDBMS Concepts]]></category>
		<category><![CDATA[SQL Server FAQ's]]></category>
		<category><![CDATA[SQL Server Programming]]></category>
		<category><![CDATA[COALESCE]]></category>
		<category><![CDATA[ISNULL]]></category>
		<category><![CDATA[SQL Server]]></category>

		<guid isPermaLink="false">http://mycodelines.wordpress.com/?p=305</guid>
		
			<content:encoded><![CDATA[ISNULL() ISNULL is a TSQL Function which is built into SQL Server. It is NOT a function defined by ANSI-92 &#8211; rather it is a feature which Microsoft has elected to include in TSQL in addition to...<br/>
<br/>
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~4/h3G7pB2B_BU" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://mycodelines.wordpress.com/2009/09/05/isnull-vs-coalesce/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://0.gravatar.com/avatar/288f66c081902691113152e3f6bd6895?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">sravanthiwinner</media:title>
		</media:content>
	<feedburner:origLink>http://mycodelines.wordpress.com/2009/09/05/isnull-vs-coalesce/</feedburner:origLink></item>
		<item>
		<title>Finding Duplicates in a Table</title>
		<link>http://feedproxy.google.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~3/VsW1npPvo_Q/</link>
		<comments>http://mycodelines.wordpress.com/2009/09/05/finding-duplicates-in-a-table/#comments</comments>
		<pubDate>Sat, 05 Sep 2009 05:30:01 +0000</pubDate>
		<dc:creator>Lakshmi Sravanthi Chowdam</dc:creator>
				<category><![CDATA[RDBMS Concepts]]></category>
		<category><![CDATA[SQL Server FAQ's]]></category>
		<category><![CDATA[SQL Server Programming]]></category>
		<category><![CDATA[duplicate rows]]></category>
		<category><![CDATA[duplicate values]]></category>
		<category><![CDATA[find duplicates]]></category>
		<category><![CDATA[occurences]]></category>
		<category><![CDATA[SQL Server]]></category>
		<category><![CDATA[sql table]]></category>

		<guid isPermaLink="false">http://mycodelines.wordpress.com/?p=301</guid>
		
			<content:encoded><![CDATA[Here&#8217;s a handy query for finding duplicates in a table. Suppose you want to find all email addresses in a table that exist more than once: SELECT email, COUNT(email) AS NumOccurrences FROM...<br/>
<br/>
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~4/VsW1npPvo_Q" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://mycodelines.wordpress.com/2009/09/05/finding-duplicates-in-a-table/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://0.gravatar.com/avatar/288f66c081902691113152e3f6bd6895?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">sravanthiwinner</media:title>
		</media:content>
	<feedburner:origLink>http://mycodelines.wordpress.com/2009/09/05/finding-duplicates-in-a-table/</feedburner:origLink></item>
		<item>
		<title>@@IDENTITY And SCOPE_IDENTITY()</title>
		<link>http://feedproxy.google.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~3/LJJy3H29-Hs/</link>
		<comments>http://mycodelines.wordpress.com/2009/09/02/identity-and-scope_identity/#comments</comments>
		<pubDate>Wed, 02 Sep 2009 08:13:20 +0000</pubDate>
		<dc:creator>Lakshmi Sravanthi Chowdam</dc:creator>
				<category><![CDATA[RDBMS Concepts]]></category>
		<category><![CDATA[SQL Server FAQ's]]></category>
		<category><![CDATA[SQL Server Programming]]></category>
		<category><![CDATA[@@IDENTITY]]></category>
		<category><![CDATA[IDENT_CURRENT]]></category>
		<category><![CDATA[SCOPE_IDENTITY()]]></category>
		<category><![CDATA[SQL Server]]></category>

		<guid isPermaLink="false">http://mycodelines.wordpress.com/?p=298</guid>
		
			<content:encoded><![CDATA[SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY are similar functions because they return values that are inserted into identity columns. IDENT_CURRENT is not limited by scope and session; it is...<br/>
<br/>
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~4/LJJy3H29-Hs" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://mycodelines.wordpress.com/2009/09/02/identity-and-scope_identity/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://0.gravatar.com/avatar/288f66c081902691113152e3f6bd6895?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">sravanthiwinner</media:title>
		</media:content>
	<feedburner:origLink>http://mycodelines.wordpress.com/2009/09/02/identity-and-scope_identity/</feedburner:origLink></item>
		<item>
		<title>List All Database Objects in SQL Server</title>
		<link>http://feedproxy.google.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~3/BvGJQxmqVRE/</link>
		<comments>http://mycodelines.wordpress.com/2009/09/02/list-all-database-objects-in-sql-server/#comments</comments>
		<pubDate>Wed, 02 Sep 2009 05:52:04 +0000</pubDate>
		<dc:creator>Lakshmi Sravanthi Chowdam</dc:creator>
				<category><![CDATA[RDBMS Concepts]]></category>
		<category><![CDATA[SQL Server FAQ's]]></category>
		<category><![CDATA[SQL Server Programming]]></category>
		<category><![CDATA[information_schema.Tables]]></category>
		<category><![CDATA[procedures]]></category>
		<category><![CDATA[SQL Server]]></category>
		<category><![CDATA[sys.Tables]]></category>
		<category><![CDATA[syscolumns]]></category>
		<category><![CDATA[sysobjects]]></category>
		<category><![CDATA[systypes]]></category>
		<category><![CDATA[tables]]></category>
		<category><![CDATA[views]]></category>

		<guid isPermaLink="false">http://mycodelines.wordpress.com/?p=295</guid>
		
			<content:encoded><![CDATA[Below statemnent will list all tables int he current database. USE YourDBName GO 1) SELECT * FROM sys.Tables 2) SELECT    * FROM  information_schema.Tables Also, sysobjects, syscolumns and systypes...<br/>
<br/>
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~4/BvGJQxmqVRE" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://mycodelines.wordpress.com/2009/09/02/list-all-database-objects-in-sql-server/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://0.gravatar.com/avatar/288f66c081902691113152e3f6bd6895?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">sravanthiwinner</media:title>
		</media:content>
	<feedburner:origLink>http://mycodelines.wordpress.com/2009/09/02/list-all-database-objects-in-sql-server/</feedburner:origLink></item>
		<item>
		<title>Difference between Function and Stored procedure</title>
		<link>http://feedproxy.google.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~3/Cn4_ZDbUzW0/</link>
		<comments>http://mycodelines.wordpress.com/2009/09/01/difference-between-function-and-stored-procedure/#comments</comments>
		<pubDate>Tue, 01 Sep 2009 11:22:51 +0000</pubDate>
		<dc:creator>Lakshmi Sravanthi Chowdam</dc:creator>
				<category><![CDATA[RDBMS Concepts]]></category>
		<category><![CDATA[SQL Server FAQ's]]></category>
		<category><![CDATA[function]]></category>
		<category><![CDATA[SQL Server]]></category>
		<category><![CDATA[stored procedure]]></category>
		<category><![CDATA[user defined functions]]></category>

		<guid isPermaLink="false">http://mycodelines.wordpress.com/?p=292</guid>
		
			<content:encoded><![CDATA[The following are the differences between a User Defined Function and a Stored Procedure in SQL Server   Stored Procedure support deffered name resolution where as functions do not support deffered...<br/>
<br/>
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~4/Cn4_ZDbUzW0" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://mycodelines.wordpress.com/2009/09/01/difference-between-function-and-stored-procedure/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://0.gravatar.com/avatar/288f66c081902691113152e3f6bd6895?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">sravanthiwinner</media:title>
		</media:content>
	<feedburner:origLink>http://mycodelines.wordpress.com/2009/09/01/difference-between-function-and-stored-procedure/</feedburner:origLink></item>
		<item>
		<title>What is Self Join?</title>
		<link>http://feedproxy.google.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~3/KBraW8W21_E/</link>
		<comments>http://mycodelines.wordpress.com/2009/09/01/what-is-self-join/#comments</comments>
		<pubDate>Tue, 01 Sep 2009 11:20:26 +0000</pubDate>
		<dc:creator>Lakshmi Sravanthi Chowdam</dc:creator>
				<category><![CDATA[RDBMS Concepts]]></category>
		<category><![CDATA[SQL Server FAQ's]]></category>
		<category><![CDATA[SQL Server Programming]]></category>
		<category><![CDATA[COALESCE]]></category>
		<category><![CDATA[inner join]]></category>
		<category><![CDATA[joins]]></category>
		<category><![CDATA[left outer]]></category>
		<category><![CDATA[outer join]]></category>
		<category><![CDATA[right outer]]></category>
		<category><![CDATA[self join]]></category>
		<category><![CDATA[SQL Server]]></category>

		<guid isPermaLink="false">http://mycodelines.wordpress.com/?p=284</guid>
		
			<content:encoded><![CDATA[Use the script below to create Employee Table and populate it with some sample data. We will be using Employee Table to understand Self Join. CREATE TABLE EMPLOYEE( [EMPLOYEEID] INT PRIMARY KEY,...<br/>
<br/>
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~4/KBraW8W21_E" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://mycodelines.wordpress.com/2009/09/01/what-is-self-join/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://0.gravatar.com/avatar/288f66c081902691113152e3f6bd6895?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">sravanthiwinner</media:title>
		</media:content>

		<media:content url="http://mycodelines.files.wordpress.com/2009/09/employee11.gif" medium="image">
			<media:title type="html">Employee1</media:title>
		</media:content>

		<media:content url="http://mycodelines.files.wordpress.com/2009/09/selfjoin.gif" medium="image">
			<media:title type="html">SelfJoin</media:title>
		</media:content>

		<media:content url="http://mycodelines.files.wordpress.com/2009/09/selfjoin1.gif" medium="image">
			<media:title type="html">SelfJoin1</media:title>
		</media:content>

		<media:content url="http://mycodelines.files.wordpress.com/2009/09/selfjoin2.gif" medium="image">
			<media:title type="html">SelfJoin2</media:title>
		</media:content>
	<feedburner:origLink>http://mycodelines.wordpress.com/2009/09/01/what-is-self-join/</feedburner:origLink></item>
		<item>
		<title>In which scenario we use Abstract Classes and Interfaces</title>
		<link>http://feedproxy.google.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~3/lSqhMWbyono/</link>
		<comments>http://mycodelines.wordpress.com/2009/09/01/in-which-scenario-we-use-abstract-classes-and-interfaces/#comments</comments>
		<pubDate>Tue, 01 Sep 2009 10:16:58 +0000</pubDate>
		<dc:creator>Lakshmi Sravanthi Chowdam</dc:creator>
				<category><![CDATA[C# Concepts]]></category>
		<category><![CDATA[C# FAQ's]]></category>
		<category><![CDATA[abstract]]></category>
		<category><![CDATA[Abstract Class]]></category>
		<category><![CDATA[abstract classes in C#]]></category>
		<category><![CDATA[abstraction]]></category>
		<category><![CDATA[C#]]></category>
		<category><![CDATA[Interface]]></category>
		<category><![CDATA[override]]></category>
		<category><![CDATA[virtual]]></category>

		<guid isPermaLink="false">http://mycodelines.wordpress.com/?p=280</guid>
		
			<content:encoded><![CDATA[Interface: &#8211;&#62; If your child classes should all implement a certain group of methods/functionalities but each of the child classes is free to provide its own implementation then use...<br/>
<br/>
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~4/lSqhMWbyono" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://mycodelines.wordpress.com/2009/09/01/in-which-scenario-we-use-abstract-classes-and-interfaces/feed/</wfw:commentRss>
		<slash:comments>18</slash:comments>
	
		<media:content url="http://0.gravatar.com/avatar/288f66c081902691113152e3f6bd6895?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">sravanthiwinner</media:title>
		</media:content>
	<feedburner:origLink>http://mycodelines.wordpress.com/2009/09/01/in-which-scenario-we-use-abstract-classes-and-interfaces/</feedburner:origLink></item>
		<item>
		<title>Difference between UNIQUE constraint and PRIMARY key</title>
		<link>http://feedproxy.google.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~3/_VRmswE7J3o/</link>
		<comments>http://mycodelines.wordpress.com/2009/08/26/difference-between-unique-constraint-and-primary-key/#comments</comments>
		<pubDate>Wed, 26 Aug 2009 09:57:47 +0000</pubDate>
		<dc:creator>Lakshmi Sravanthi Chowdam</dc:creator>
				<category><![CDATA[RDBMS Concepts]]></category>
		<category><![CDATA[SQL Server FAQ's]]></category>
		<category><![CDATA[constraints]]></category>
		<category><![CDATA[Primary constraint]]></category>
		<category><![CDATA[Primary Key]]></category>
		<category><![CDATA[unique]]></category>
		<category><![CDATA[unique constraint]]></category>

		<guid isPermaLink="false">http://mycodelines.wordpress.com/?p=277</guid>
		
			<content:encoded><![CDATA[A UNIQUE constraint is similar to PRIMARY key, but you can have more than one UNIQUE constraint per table. When you declare a UNIQUE constraint, SQL Server creates a UNIQUE index to speed up the...<br/>
<br/>
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]<img src="http://feeds.feedburner.com/~r/CsharpAspnetSqlServer-sravanthi-codelines/~4/_VRmswE7J3o" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://mycodelines.wordpress.com/2009/08/26/difference-between-unique-constraint-and-primary-key/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
	
		<media:content url="http://0.gravatar.com/avatar/288f66c081902691113152e3f6bd6895?s=96&amp;d=identicon&amp;r=G" medium="image">
			<media:title type="html">sravanthiwinner</media:title>
		</media:content>
	<feedburner:origLink>http://mycodelines.wordpress.com/2009/08/26/difference-between-unique-constraint-and-primary-key/</feedburner:origLink></item>
	</channel>
</rss>

