Click here to Skip to main content
13,900,823 members

SQL-server-2000

Great Reads

by Wonde Tadesse
This tip/trick helps to set a default value for blob data type such as Image, VarBinary.
by aleksisa
Build a process to import Leads records from Excel into MS CRM via email.
by Md. Marufuzzaman
How easy to read a file without using of the seven extended stored procedures.
by Sven Cipido
How to add a "select all" option to your parameter lists in SQL Reporting.

Latest Articles

by Alejandro Xalabarder
An efficient and flexible layout mananger.
by Ebenezar John Paul
An Ideal Code Review Checklist that applies for most programming languages
by BharatRamV
Finds the Best Table for a given set of columns
by Mark W Solomon
In this article, I developed a way to determine all the SQL Servers in our environment at will and filter this information into Microsoft's Sunset report for Microsoft SQL Server and present all this information in an SSRS report.

All Articles

Sort by Score

SQL-server-2000 

10 Mar 2005
Sven Cipido
How to add a "select all" option to your parameter lists in SQL Reporting.
19 Dec 2007
Bryan Sachdeva
This article describes how to create a wrapper class for the native Phone API, and then uses it to retrieve and store the call history.
17 Oct 2007
Adam Page
Setting up an SMS gateway to conduct an SMS survey and storing the survey results in an MS Access database, from which you can generate/print out reports.
20 Apr 2009
András Slyuch
This class collects data rows in the memory and saves them into a Microsoft SQL database with SqlBulkCopy.
28 Aug 2012
akhil khare
Find multiple strings (delimenated by space) in all selected columns.
1 May 2012
Jean-Francois Lanouette
This is an alternative for "Simple & Advanced Pivots with C# and ASP.NET"
8 Aug 2012
ManojKumar19
This tip demonstrates how table data can be shared in two stored procedures.
24 Jun 2009
Kuldip Rindani
Monitoring group of Linked SQL Servers from a SQL Server
12 Jan 2014
Christian Graus
In this third installment, we look at how Common Table Expressions can simplify your SQL and help you perform complex tasks
16 Jan 2014
Christian Graus
Discussion on pivot and other ways to turn columns of data in to rows in SQL Server
28 Apr 2005
emadns
How to start a connection using ATL OLE DB consumer classes and how to obtain a session so that you can use it to query or edit the database.
12 Jul 2005
Chester Ragel
A tool which can be used to do common tasks which Microsoft Content Management Server API provides.
22 Aug 2009
Md. Marufuzzaman
This article will give you an idea about how to integrate an OLE Object that is a COM+ API with SQL Server and write a message into a Windows event log.
17 Aug 2005
Omar Al Zabir
Comprehensive guide to development of .NET 2.0 Smart Clients working with existing Service Oriented Architecture based XML web services, fully utilizing the Enterprise Library
21 Jan 2014
Christian Graus
A description of the best way to create tally tables, and how to use them
11 Jun 2008
Billy McCafferty
This article describes best practices for leveraging the benefits of NHibernate 1.2, ASP.NET, generics and unit testing together.
25 Jul 2009
Md. Marufuzzaman
This article will demonstrate the procedure to shrink the database transaction log.
3 Oct 2016
Mark W Solomon
In this article, I developed a way to determine all the SQL Servers in our environment at will and filter this information into Microsoft's Sunset report for Microsoft SQL Server and present all this information in an SSRS report.
19 Aug 2009
Md. Marufuzzaman
A list of Global variables in SQL Server and their uses in Transact-SQL
26 Jun 2008
johnnycantcode
Create and manage your mobile database using SQL Management Studio and export them to SQL Compact Edition databases
30 Nov 2006
siva pinnaka
This article explains how to migrate data between different SQL Server environments.
18 Oct 2013
Brian C Hart
To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express -- updated for SQL Server 2008 Express Edition!
22 Aug 2004
Shams Mukhtar
This article will enhance your vision on the usage of Robustness Analysis in conjunction with Model View Controller, using UML with application in ASP.NET. This article is a sequel to my articles on Architecture and Design with ASP.NET.
7 Aug 2006
craigd
Save your database diagrams *outside* the database in a Transact-SQL text file, for backup and/or source-control.
30 Jun 2004
Charles Horan
A utility application that generates .NET code for wrapping stored procedures.
23 May 2017
Alejandro Xalabarder
An efficient and flexible layout mananger.
28 Jul 2009
Shivprasad koirala
Concurrency handling, compiled queries, CRUD implementation, and mapping simple .NET classes with XML file configuration.
20 May 2010
Shivprasad koirala
6 steps to implement DUAL security on WCF using User name + SSL
15 Jun 2009
Md. Marufuzzaman
This article will demonstrate how we can integrate T-SQL with an external application.
6 Apr 2005
Stefan Prodan
Deploy MS SQL Server databases using System.Configuration.Install and a VS.NET Setup Project.
4 Jan 2005
DGoins
This article explains a brief introduction to SOA and a Subscriber-Publisher model, along with how to implement one using WSE SOAP Receiver and WSE SOAP Sender classes inside a Windows .NET application.
9 Dec 2010
AnupKumarYadav
Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)
24 Sep 2015
Alberto Venditti
Using a .NET Windows service as an engine for specialized custom plug-ins execution
24 Feb 2017
Ebenezar John Paul
An Ideal Code Review Checklist that applies for most programming languages
4 Feb 2009
C.L. Moffatt
This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.
26 Jan 2010
BackyardHackMechanic
Describes how to get more control over the XML output when using the FOR XML AUTO statement. For instance, when adding XML tags.
17 Jan 2005
Sumit Amar .
1 alternative  
Stored procedure to generate INSERT..VALUES statements in SQL Server.
23 Aug 2010
Shivprasad koirala
VS 2010 Deployment (Package, One click deploy and Web.config transformation)
15 Apr 2006
Raj Lal
A dynamic web application needs an admin section for CRUD actions on the records/tables in the database. Wouldn't it be nice to have a database admin, which can be plugged to any web application? Just give your SQL connection string and it dynamically manages all table operations in just five pages.
8 Sep 2009
Muhammad Akhtar Shiekh
An artcile on End to End solution to optimized paging and sorting in ASP.NET GridView using Object Data Source.
6 Jun 2005
smiling4ever
To make a dictionary that will work with Google Suggest like Dictionary.
23 Jan 2005
Colin Angus Mackay
Discusses various aspects of SQL Injection attacks, what to look for in your code, and how to secure it against SQL Injection attacks.
13 Sep 2009
Md. Marufuzzaman
A simple example of SQL server admin tools.
8 Dec 2007
Hamidreza-Ghasemkhah
Automatically generates the required class and stored procedure to work with SQL databases
29 Apr 2009
Kamran Hazari
How to create Linked servers in a minute in an easy way
14 May 2012
Shivprasad koirala
An introduction to stack, heap, value types, reference types, boxing, and unboxing.
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to split a string using Transact-SQL.
28 Mar 2013
Khorshed Alam, Dhaka
How to execute multiple long running SQL Statement Asynchronously in smaller chunks
18 Apr 2005
earmitage
An article on enumerating SQL Server instances in C# using ODBC thus removing any dependancy on SQLDMO. Based on the C++ article by Santosh Rao.
27 Sep 2005
Mikael Håkansson
QueryCommander SQL editor with IntelliSense, wrapped in a Visual Studio type of environment. QueryCommander supports: Microsoft SQL Server 6.5-2005, MySQL 4.*-5.1, and Oracle 9i.
10 Sep 2004
mysorian
A step-by-step approach to creating a report from scratch using the SQl Server 2000 Reporting Services.
29 Jan 2009
Nitesh Maharaj
1 alternative  
How to create simple and advanced pivot tables in C# and ASP.NET
3 Jun 2006
Shabdar Ghata
Restore/backup selected objects in SQL Server.
4 Sep 2013
Mubin M. Shaikh
This article shows how to create and populate date dimension for data warehouse.
11 Jan 2008
Rafik Robeal
Build occasionally connected applications using Microsoft Synchronization Services for ADO.NET
8 Jul 2004
Simon Steed (SimonAntony)
This article explains how using caching within your Windows Forms application can speed up data access for frequently used data and avoid performance bottlenecks over the network.
3 Mar 2008
Alex Baker
Change collation order for all text columns in a database
4 Jun 2010
Syeda Anila Nusrat
Create a Business Logic Layer, Data Access Layer classes, and Stored Procedure scripts from a database table.
17 Mar 2005
Dan Farino
An Extended Stored Procedure to use regular expressions in T-SQL.
2 Nov 2015
icemanind
Easily create Business and Data Layers!
14 Nov 2004
Lars-Inge Tønnessen
An article on how to setup and configure the MSFT MSDE 2000.
14 Aug 2012
Duong Ba Hong Minh
A good way to setup and install a multi-tree level structure by using a MS SQL Server database.
29 Jul 2009
Md. Marufuzzaman
This article will demonstrate the best practice to protect SQL server code object.
9 May 2007
Peter Weissbrod
This is the second part in a two-piece article focused on optimizing the efficiency of your NHibernate ORM layer.
6 Jan 2014
Christian Graus
Just a quick explanation of why it's not always a good idea to use DISTINCT
29 Jun 2011
michael.neubrander
Multi account synchronizer for GMail, AD, and SQL Server.
25 Oct 2006
Jürgen Bäurle
This article describes how to create Data Access Layer Components (DALC) using ASP.NET build providers and a self-defined description language in C#, including an easy scanner, parser, and CodeDOM generator.
4 Nov 2006
Uwe Keim
An application to manage support request with tickets and events
5 Apr 2016
SQLMonger
SQL Function to parse a delimited string and return it as a table. Handles multi-character delimiters and returns the results as a table.
14 Jan 2013
liron.levi
A C# utility to automatically do conversion from a SQL Server DB to a SQLite DB
11 Jan 2012
Venkat Chaitanya Kanumukula
T-SQL Code for Converting Stored Procedure results to Tables Dynamically
8 Sep 2006
Shahed.Khan
This paper demonstrates an extensible mass emailing framework (Smart Mass Email SME). The demo implementation uses cutting edge .NET technologies available today such as C#, .NET 2.0, Microsoft® SQL Server 2005 Service Broker, MS Provider Pattern, Enterprise Library January 2006 etc.
22 Sep 2009
Abhijit Jana
Basic overview of temporary Tables in SQL Server 2005
12 Jan 2007
Mark J. Miller
Defining (rather loosely) ad hoc queries as SQL commands built as strings by an SQL client application and submitted to SQL Server.
10 Jan 2005
Kim Sheffield
The RDL Project is an open source (GPL) implementation of the RDL for the .NET environment created by fyiReporting Software. RDL is an XML based language created by Microsoft with the goal of promoting interoperability of reporting products. Project RDL is a compact implementation of RDL.
4 Apr 2006
Salvatore Vetro
The art of swap from a database to another changing a flag
17 Oct 2009
Nitinpatel
T-SQL script to generate the document of SQL 2000/2005 database
12 Mar 2014
Christian Graus
The second in my series digs in to some of the different things you can do within a select statement.
1 Jun 2009
Dwayne Macadangdang
An article on creating a Hybrid Smart Client for Twitter using the Windows Presentation Foundation and the TwitterLib class library
15 Aug 2004
Elvin Cheng
Solve the ViewState problems using the industry well-known pattern - Provider Model design pattern.
10 Oct 2005
Michael.Piccolo
How to add DataGrid columns dynamically with ITemplate, XML and templated controls.
22 Dec 2009
Suresh Suthar
How to execute DTS packages through VB.NET and use global variables.
17 Aug 2009
P. Ganesh Kumar
Helps in assigning row numbers in the returned result of an SQL query
18 Apr 2005
Gael Fraiteur
If you want to tune your SQL statements, you need to understand how the server executes them. The article explains this.
17 Aug 2010
Shivprasad koirala
.NET Best Practice No: 1:- Detecting High Memory consuming functions in .NET code
16 Aug 2012
Abdul Quader Mamun
Framework makes application more organized and efficient way to coding. It is helpful for newly assigned developer to understand code structure within a short time. It is essential for large application.
24 Oct 2005
Phorozan
When you create a backup, you must be able to restore this backup into the same database and same location. But this code also helps you to restore a backup into a new database or existing database.
22 Nov 2004
Dave Handley
A library of template classes that enables the rapid production of client-side database code.
1 Jul 2003
Saumendra Poddar
SQL Server Transactions and Error Handling
24 Nov 2005
James Curran
An article on locating MS SQL Server instances on the local network, and retrieving information about them.
7 Mar 2008
Alexander Kojevnikov
sqlTunes is a small tool that exports iTunes library information to the SQL server.
23 Jan 2014
Christian Graus
A discussion of ways to create random number sequences in SQL Server
16 May 2013
Peter Hancock
Using NAnt and CruiseControl.NET to continuously integrate database changes
22 May 2006
Jeff Modzel
How to create your own ASP.NET 2.0 custom resource provider to replace resource files (resx) with SQL Server.
5 Jan 2005
Teo Lachev
Introducing Microsoft Reporting Services.
13 Feb 2007
Vlad Hrybok
This article describes how to run DotNetNuke content management system on UltiDev Cassini web server, which unlike IIS can run on Windows XP Home and can be redistributed along with the DotNetNuke applications.
6 Jan 2013
Vimalsoft(Pty) Ltd
Coding an N-Tier application in C# without using Wizards.
20 Apr 2008
gan.gary
An article on a SQL IDE for different type of RDBMS databases
29 Oct 2004
Alexandru Ghiondea
Describes how to upload and download pictures to and from a SQL Server database.
11 Dec 2007
Danilo Mendez
Describes how to generate NHibernate objects and ASPX pages using Smart Code
17 Mar 2008
Shabdar Ghata
A Windows application to backup and restore SQL server tables,views,user defined functions and stored procedures
6 Jul 2007
Nguyen-Thanh-Tung
Use SOAP to communicate with a remote DB Server (Here I use SQL Server) on the Internet and get information or interact with the database
27 Dec 2004
Gavi Narra
An implementation of Google suggest using remote scripting.
23 Dec 2008
Neeraj Kr
Provides an insight into creating automated process for Backups and Restorations
10 Feb 2009
ozkary
A VBScript script which allows to script out all the SQL Server objects in each independent file
2 Oct 2008
Andrew J Dixon
Explaining Database deadlocking to non-technical people
13 May 2005
Anand Santhanam
In this article, I would like to demonstrate how we can leverage the SQL Reporting Services feature on to a Microsoft Access database, using the Visual Studio .NET as IDE.
7 Jun 2007
hoquet
A utility program that allows you to enter SQL to select data from Oracle, the program will then create a table in SQL Server and copy the data using SQLBulkCopy.
28 Apr 2005
Thomas Kurek
Unsatisfied with the accuracy of code online that assumes the Earth is a sphere, I have implemented the oblate spheroid model used in GPS.
19 Sep 2009
Paul Rony
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
12 Jan 2014
Christian Graus
In which we talk of ways to pass an arbitrary list of values to SQL Server
28 Jan 2006
Bahrudin Hrnjica
Putting and retrieving images files to and from a database, via ADO.
13 Jun 2005
Andrey Shchurov
With SqlWrapper, you can easily create your DAL classes writing the most minimum amount of code.
18 Jul 2007
Matt Perdeck
Shows how to add a Crystal Reports report to an ASP.NET page, with grouping, filtering, and drill down.
3 Jul 2007
Steve Abraham
This article is an introduction to the SQL Server Virtual Device Interface and how to access it via any .NET language
5 Sep 2004
Jose A. Gonzalvo
A small command prompt utility to help you document your SQL Server/MSDE database
11 Oct 2011
GraemeKMiller
This article explains how you can use IWA to improve your Users' experience and it also explains how it benefits your IT support team.
14 Sep 2008
Steven A. Lowe
Dashboards are immensely useful not only for business data but also for business applications, but only if they display metrics that can be used to "drive" (or "steer") in real-time.
30 Jul 2005
Klaus Salchner (Canada)
Indexing Server, SQL Server, Windows SharePoint Services, SharePoint Portal Server, Exchange Server and Windows Desktop Search provide full-text search capabilities. Each utilizes the so called IFilter components to index the content and then allows clients to search the index.
13 Feb 2006
IPC2000
A handy command line tool that checks whether stored procedures, views and functions in a database compile
6 May 2008
Igor Krupitsky
Unlike Date Dimension (with Year, Month, Date), Time Dimension (with Hour, Minutes, and Seconds) is not automatically created by SSAS (Microsoft SQL Server Analysis Services). This article explains how to create and use Time Dimension in Microsoft SQL Server Analysis Services.
15 Oct 2007
Thanh Huu Nguyen (Tony)
Look up a huge list of stock symbols from MS SQL database
19 Jul 2006
Dan Radu
This article describes how to efficiently store and access tree structures in a SQL Server database, and how to use them in OLAP implementations.
9 Nov 2006
Howard Richards
Techniques for using the XML data type for storing data.
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.
23 Jan 2008
Muigai Mwaura
LINQ to SQL Transformation: Open Source implementation of IQueryable, examples and source code
15 Feb 2007
Ben Allfree
Learn how to store data with a version history.
26 Apr 2008
Sudipta Chaudhari
This article gives a brief introduction about Triggers in SQL Server 2000/2005.
2 Oct 2004
Alberto Venditti
A proposed class to simulate the ADODB.Recordset behavior in .NET.
20 Feb 2006
PaulMcKenzie
This stored procedure will generate all the C# code for calling any Stored Procedure
23 Sep 2005
Mike Ellison
An approach to creating an aggregate report with a set of dynamic columns based on dates.
22 Jan 2008
Sajid.Majeed
This article will address tools and technologies to identify bottlenecks and key consideration points for performance improvement.
4 Oct 2009
Shaun Wilde
Custom MembershipProvider and RoleProvider implementations that use web services in order to separate the application and database servers.
13 Jan 2014
Christian Graus
A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012
19 Sep 2013
Shivprasad koirala
Software Architecture interview questions (Service Oriented Architecture interview questions: Part 1).
24 May 2005
Ameen AboDabash
Vertical/horizontal Marquee Web Custom Control consuming SQL Server DB/XML, with great design time attributes.
3 Mar 2006
Declan Brennan
Extending the RichTextBox to support form persistance and data binding.
8 Nov 2007
John-ph
This article shows different methods of implementing Dynamic WHERE-Clause in static SQL.
1 Dec 2005
Shahed.Khan, David.Grinberg
This paper demonstrates creating a flexible, extensible, plug-in-based .NET application (JOM - Smart Job Manager). JOM is an asynchronous job processing engine built using the MS Provider design pattern and the .NET technology available today.
12 Jun 2008
Jimmy Zhang
Introduces a simple, efficient, human-readable XML index called VTD+XML.
10 Jun 2007
Peter Weissbrod
A distilled methodology for detecting and isolating NHibernate-related performance and scalability issues
22 May 2009
Md. Marufuzzaman
An easy technique to store any file into SQL database
11 May 2009
Ladislav Nevery
Native MySql Client not requiring any special driver or library
11 Oct 2004
Rajesh Pillai
This project is meant to provide a tool similar to query analyzer which can be used to execute queries, create tables, and do all other common database activities.
21 Oct 2005
perlmunger
This article describes the DotNetNuke Module Packager application and source code. The application enables the user to generate DotNetNuke private assemblies that are useable out of the box from a custom module defined in the programmer's development environment.
17 Mar 2009
junnark
In Part 1, we built a simple web chat using Silverlight 2. We are going to add functionalities so that users are able to choose from multiple chat rooms as well as chat privately with other users.
20 Jul 2007
Johan Sassner
An addin to Sql Server Management studio that lets you configure keybindings
4 May 2005
Stephen Huen
Review of MCMS Connector for SharePoint Technologies.
5 Aug 2004
Jasmin Muharemovic
An article about optimization and performance testing of MS SQL Server 2000 stored procedures used for paging of large resultsets in ASP.NET
16 Jul 2005
TylerBrinks
Geo-Locating C# Smart Client Application using the 2.0 Framework
19 Aug 2009
Md. Marufuzzaman
This article will give you an idea about how to use CASE expression in T-SQL or as a formula of a particular column.
3 Jul 2004
Ansil
This article is about using CheckBoxes in a Datagrid control to select records as in a mail box.
27 May 2016
icemanind
How to automatically create data access layers and business layers from a Microsoft Access or a SQL Server database
12 Jun 2007
Psycho-*Coder*-Extreme
This article covers pitfalls found while doing a merge replication in SQL 2000
4 May 2004
Daniel Aioanei, Adi Malinaru, Andrei Postolache
An article on how to persist permutations of items in relational databases.
13 Oct 2006
Ewout Stortenbeker
This tool (ScriptDB4Svn) enables you to add your SQL Server databases to Subversion (SVN) source control.
20 Sep 2005
Brian Perrin
Eliminate the pain of calling SQL stored procedures from C#.
23 Jul 2007
Benedict Chan
Using .NET 2.0 to get the SQL Server schema and generate insertion statements.
15 Nov 2007
Marcelo Ricardo de Oliveira
This article shows how you can mix together Model-View-Presenter, Domain Model, Services, ActiveRecord, and Repository patterns to create a testable application.
27 Sep 2005
Weidong Shen
Adding secure communications to the Microsoft IssueVision sample application using WSE 2.0.
9 Apr 2005
theoutlander
An overview on inheriting a ListView and implementing design-time data binding capability.
8 Jan 2006
Michael Erasmus
This article is on a tool I wrote to generate executable osql deployment batch scripts.
23 Nov 2007
adambl
Provides a utility to generate a wrapper for stored procedures to improve performance and eliminate certain run-time errors
4 May 2007
Pete O'Hanlon
These articles are on prioritizing and improving query performance in SQL Server.
2 Jul 2004
TomKat
Simple ODBC Wrapper + Connection classes for several database types.
29 Nov 2005
Mukund Pujari
This article shows how to distribute or install MSDE with a .NET application.
27 Mar 2007
Sujith C Jose
Describes how to use a simple stored procedure in Visual Basic 6.0
15 Jun 2007
azamsharp
Implementing an auto-completion feature using ASP.NET 2.0 client callbacks
29 Feb 2008
EJocys
How to create and compile SQL XML Documentation comments
28 Nov 2005
Pedro J. Molina
This article provides a way for automatically testing SQL embedded in your Data Access Layer (DAL) before publishing a new release of your application.
20 Oct 2005
codeajay
A simplified SQL-CSV import/export functionality.
1 Jun 2005
Alexander Shirshov
Emulate TransactionScope functionality coming in .NET 2.0 with .NET 1.1.
10 Mar 2005
Todd Davis
An installation program for the popular DotNetNuke ASP.NET portal.
29 Sep 2007
DejaVudew
An article discussing how to accomplish paging and sorting in Microsoft SQL Server 2000 without using concatenated SQL.
14 Mar 2014
Christian Graus
In this installment, I talk about working with dates and date functions in SQL Server
25 Feb 2005
vivekthangaswamy
How to upload files to Web pages in ASP.NET? How to read an image from a database using ADO.NET and display it in a Web page?
14 Sep 2006
salysle
This article describes an easy approach to examining all of the tables, views, and columns in a database.
1 Sep 2006
ShirleySW
How to dynamically create an ASP.NET 2.0 Wizard control and load child controls at run-time.
8 Jul 2004
Simon Segal
An MVC meets FuseBox Hybrid pattern for .NET, implmented in C# with the the Northwind database.
7 Apr 2005
goodtime68
Cyber café software to keep track of buisness.
26 Apr 2006
Emad Al-Ashi
An easy graphical way to create complex nested SQL Join queries.
1 Jul 2009
mohamad halabi
Shows how to build new-design distributed applications with WF 4.0 and Data Services.


Advertise | Privacy | Cookies | Terms of Service
Web01 | 2.8.190306.1 | Last Updated 24 Mar 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid