https://www.developerfusion.com/t/sql/code/ SQL Sample code from Developer Fusion http://www.rssboard.org/rss-specification en-GB Sat, 01 Apr 2006 17:47:00 GMT This is a code sample for using health monitoring... http://www.developerfusion.com/code/5543/health-monitoring-in-aspnet-2/ http://www.developerfusion.com/code/5543/health-monitoring-in-aspnet-2/ Sat, 01 Apr 2006 17:47:00 GMT This class includes some useful methods for working with Misrosoft SQL Server in .NET simply and quickly. http://www.developerfusion.com/code/5445/sql-data-provider-vbnet-class/ http://www.developerfusion.com/code/5445/sql-data-provider-vbnet-class/ Sat, 25 Feb 2006 08:59:00 GMT Importing Data from Text File using Transact-SQL is not a tough task, we can import data from Flat File in just 3 steps. http://www.developerfusion.com/code/5357/bulk-insert-from-flat-file-using-transactsql/ http://www.developerfusion.com/code/5357/bulk-insert-from-flat-file-using-transactsql/ Tue, 07 Feb 2006 11:51:00 GMT M M Harinath One of the more significant improvement in .NET 2.0 is the transactions area. Now with a single line it becomes extremely easy to support transactional code blocks using the concept of “ambient” transaction thanks to TransactionScope in the System.Transactions namespace. http://www.developerfusion.com/code/5282/transactions-made-easy-with-net-20/ http://www.developerfusion.com/code/5282/transactions-made-easy-with-net-20/ Wed, 25 Jan 2006 01:18:00 GMT Xavier Larrea Learn how to use the little-known Http Handler functionality of ASP.NET to serve images from a database. http://www.developerfusion.com/code/5223/using-ashx-files-to-retrieve-db-images/ http://www.developerfusion.com/code/5223/using-ashx-files-to-retrieve-db-images/ Sun, 15 Jan 2006 12:37:00 GMT Harry Pierson Here's now to randomly sort records in SQL Server 2000 - so you can potentially select say 10 random items from a table. http://www.developerfusion.com/code/4680/randomly-sorting-records/ http://www.developerfusion.com/code/4680/randomly-sorting-records/ Fri, 25 Mar 2005 13:52:00 GMT James Crowley This short snippet shows how to discover how large a particular table or an entire database is in SQL Server. http://www.developerfusion.com/code/4661/calculate-diskspace-used-by-a-table-or-database/ http://www.developerfusion.com/code/4661/calculate-diskspace-used-by-a-table-or-database/ Sun, 30 Jan 2005 14:08:00 GMT James Crowley A neat way of fetching an image stored in SQL Server and resizing it before save/sending it anywhere. http://www.developerfusion.com/code/4651/resizing-images-retrieved-from-sql-server/ http://www.developerfusion.com/code/4651/resizing-images-retrieved-from-sql-server/ Sun, 09 Jan 2005 14:43:00 GMT Simon Soanes Demonstrates a useful debugging technique taking advantage of traces in ASP.NET. http://www.developerfusion.com/code/4649/debug-aspnet-pages-using-tracing/ http://www.developerfusion.com/code/4649/debug-aspnet-pages-using-tracing/ Fri, 07 Jan 2005 08:48:00 GMT Julian Roberts You can save code by piling SQL statements into one SqlCommand and then getting a DataReader with multiple result sets. http://www.developerfusion.com/code/4638/how-to-run-through-multiple-datareader-results/ http://www.developerfusion.com/code/4638/how-to-run-through-multiple-datareader-results/ Fri, 17 Dec 2004 15:16:00 GMT Edward Tanguay A simple helper class to make generating an RSS feed a piece of cake - its the one we use on Developer Fusion too! http://www.developerfusion.com/code/4597/rss-feed-helper-class/ http://www.developerfusion.com/code/4597/rss-feed-helper-class/ Fri, 02 Apr 2004 05:44:00 GMT James Crowley Demonstrates how to connect to a MySQL database with C#. http://www.developerfusion.com/code/4596/how-to-access-a-mysql-database-with-net/ http://www.developerfusion.com/code/4596/how-to-access-a-mysql-database-with-net/ Thu, 01 Apr 2004 14:47:00 GMT Edward Tanguay Demonstrates how Databind the SqlTypes using the PropertyDescriptor class and the ITypedList Interface. http://www.developerfusion.com/code/4408/databinding-sqltypes/ http://www.developerfusion.com/code/4408/databinding-sqltypes/ Sun, 08 Feb 2004 07:00:00 GMT Dan Glass This code shows you how to delete records with an SQL statement and get the number of records deleted returned back as an integer. http://www.developerfusion.com/code/4391/how-to-delete-records-with-sqlcommand/ http://www.developerfusion.com/code/4391/how-to-delete-records-with-sqlcommand/ Wed, 04 Feb 2004 11:36:00 GMT Edward Tanguay ADO class containing useful functions - counting records, creating database from scratch, openning/closing database, filling listbox/combo box with an sql statements, manipulating records....and much more. http://www.developerfusion.com/code/3205/ado-utility-class/ http://www.developerfusion.com/code/3205/ado-utility-class/ Mon, 26 Jan 2004 11:20:00 GMT NeverMalchik Discusses some unexpected implications of using the 'On Error Resume Next' statement in Visual Basic applications. http://www.developerfusion.com/code/4325/on-error-resume-next-considered-harmful/ http://www.developerfusion.com/code/4325/on-error-resume-next-considered-harmful/ Wed, 21 Jan 2004 04:23:00 GMT Palo Mraz An example of how to get metadata - such as all the databases on the server, all of their tables, and the corresponding field information for that table. http://www.developerfusion.com/code/3945/get-metadata-on-mysql-databases/ http://www.developerfusion.com/code/3945/get-metadata-on-mysql-databases/ Wed, 13 Aug 2003 10:26:00 GMT Edward Tanguay Generate graphics on the fly to provide a graphical page hit counter, storing the counter in a text file or SQL database. http://www.developerfusion.com/code/3734/aspnet-graphical-page-hit-counter/ http://www.developerfusion.com/code/3734/aspnet-graphical-page-hit-counter/ Mon, 07 Jul 2003 10:32:00 GMT Raam Kumar These groups of Procedures will allow you to Open Databases, Run SQL Statements, as Well as Execute Stored Procedures without hassle... http://www.developerfusion.com/code/3292/activex-data-object-simple-routines/ http://www.developerfusion.com/code/3292/activex-data-object-simple-routines/ Fri, 28 Feb 2003 12:44:00 GMT Macky M Just supply your database connection string and this code will give you a radio button list of all your SQL Server tables and will show their fields. http://www.developerfusion.com/code/3243/display-sql-server-table-data-in-a-browser/ http://www.developerfusion.com/code/3243/display-sql-server-table-data-in-a-browser/ Sat, 11 Jan 2003 09:51:00 GMT Edward Tanguay