Recent

• Simple Particle Engine for a shooter game
• Snake / Nibbles clone in C and Ncurses
• Please improve
• 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

Popular

• Parsing of XML data has high CPU usage
• Please improve
• Snake / Nibbles clone in C and Ncurses
• List the files in a directory without the directory name or the extension
• Convert simple Javascript to jQuery plugin
• Simple Particle Engine for a shooter game
• Active Record getting unique records
• Breadth first cartesian product iterator
• php refactoring
• first BST

Pastable version of Backup All MS SQL Server Databases

<pre class='prettyprint' language='cs'>Use Master Declare @DatabaseName sysname Declare @SQLCommand varchar(1024) Declare curDBName Cursor For Select [Name] From Master..Sysdatabases Where [Name] Not In ('tempdb') Open curDBName Fetch curDBName Into @DatabaseName While (@@fetch_status = 0) Begin if databasepropertyex (@DatabaseName,'Status') = 'online' Begin Select @SQLCommand = 'Backup Database ' + @DatabaseName + ' To Disk = ''D:\Backups\Databases\' + @DatabaseName + '.bak'' With Format' execute (@SQLCommand) End Fetch curDBName Into @DatabaseName End Close curDBName Deallocate curDBName</pre> <a href="http://www.refactormycode.com/codes/497-backup-all-ms-sql-server-databases" 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>