Recent

• Parsing of XML data has high CPU usage
• Convert simple Javascript to jQuery plugin
• Active Record getting unique records
• List the files in a directory without the directory name or the extension
• clean the code
• ohs system, recruitment software, hr software, oh&s software, human resources software, ohs software
• Array parsing in a block
• Learning JS
• Type Safety
• Euler Problem 2 solution

Popular

• Parsing of XML data has high CPU usage
• List the files in a directory without the directory name or the extension
• Convert simple Javascript to jQuery plugin
• Active Record getting unique records
• Breadth first cartesian product iterator
• php refactoring
• first BST
• Learning JS
• Too many if statements
• clean the code

Pastable version of Cache SQL Server Views

<pre class='prettyprint' language='cs'>Declare @Name varchar(128) Declare @Cursor Cursor Set @Cursor = Cursor For Select Name From SysObjects Where XType = 'V' Open @Cursor Fetch Next From @Cursor Into @Name While @@Fetch_Status = 0 Begin Declare @Table varchar(128) Set @Table = 'c' + SubString(@Name, 2, 128) If Exists(Select Name From SysObjects Where Name = @Table) Begin Print 'Drop Table ' + @Table Exec('Drop Table ' + @Table) End Exec('Begin Tran Select * Into ' + @Table + ' From ' + @Name + ' Commit') Fetch Next From @Cursor Into @Name End Close @Cursor Deallocate @Cursor</pre> <a href="http://www.refactormycode.com/codes/347-cache-sql-server-views" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://www.refactormycode.com/images/small_logo.gif" style="border:0" /></a>