Click here to Skip to main content
14,544,540 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 Tharaka MTR
This post will show you how to fix orphaned SQL users.

Latest Articles

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.
by GhostHost
Automatic creation of non clustered indexes using system SQL entities

All Articles

Sort by Updated

SQL-server-2000 

24 Feb 2017
Ebenezar John Paul
An Ideal Code Review Checklist that applies for most programming languages
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.
27 May 2016
icemanind
How to automatically create data access layers and business layers from a Microsoft Access or a SQL Server database
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.
2 Nov 2015
icemanind
Easily create Business and Data Layers!
23 Sep 2015
Alberto Venditti
Using a .NET Windows service as an engine for specialized custom plug-ins execution
24 Sep 2014
Duncan Edwards Jones
A simple unit testing framework for T-SQL
14 Mar 2014
Christian Graus
In this installment, I talk about working with dates and date functions in SQL Server
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.
5 Mar 2014
Shivprasad koirala
Steps to use a logging utility in your projects using Application Blocks.
23 Jan 2014
Christian Graus
A discussion of ways to create random number sequences in SQL Server
21 Jan 2014
Christian Graus
A description of the best way to create tally tables, and how to use them
16 Jan 2014
Christian Graus
Discussion on pivot and other ways to turn columns of data in to rows in SQL Server
13 Jan 2014
Christian Graus
A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012
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
12 Jan 2014
Christian Graus
In which we talk of ways to pass an arbitrary list of values to SQL Server
6 Jan 2014
Christian Graus
Just a quick explanation of why it's not always a good idea to use DISTINCT
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!
19 Sep 2013
Shivprasad koirala
Software Architecture interview questions (Service Oriented Architecture interview questions: Part 1).
4 Sep 2013
Mubin M. Shaikh
This article shows how to create and populate date dimension for data warehouse.
16 May 2013
Peter Hancock
Using NAnt and CruiseControl.NET to continuously integrate database changes
24 Apr 2013
Phuong Thanh Nguyen
Create a SQL Server database using C#.
28 Mar 2013
Khorshed Alam, Dhaka
How to execute multiple long running SQL Statement Asynchronously in smaller chunks
13 Jan 2013
liron.levi
A C# utility to automatically do conversion from a SQL Server DB to a SQLite DB
5 Jan 2013
Vimalsoft(Pty) Ltd
Coding an N-Tier application in C# without using Wizards.
28 Aug 2012
akhil khare
Find multiple strings (delimenated by space) in all selected columns.
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.
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.
7 Aug 2012
ManojKumar19
This tip demonstrates how table data can be shared in two stored procedures.
24 May 2012
Vimalsoft(Pty) Ltd
This article will show you how to build an N-Tier application in VB.NET.
19 May 2012
ilorgat
This is an alternative for "Generating INSERT statements in SQL Server"
14 May 2012
Shivprasad koirala
An introduction to stack, heap, value types, reference types, boxing, and unboxing.
1 May 2012
Jean-Francois Lanouette
This is an alternative for "Simple & Advanced Pivots with C# and ASP.NET"
11 Jan 2012
Venkat Chaitanya Kanumukula
T-SQL Code for Converting Stored Procedure results to Tables Dynamically
11 Jan 2012
Venkat Chaitanya Kanumukula
Export SQL Server tables to HTML/Excel/Word Document files dynamically.
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.
29 Jun 2011
michael.neubrander
Multi account synchronizer for GMail, AD, and SQL Server.
15 Apr 2011
Ayaz Awan
Generate 100,1000 lines of backend code and stored procedures by just one click on table name in SQL Server
14 Jan 2011
KarthikAnbarasan
This article explains the new tool in Visual Studio 2010 which most of the users use to see the comparison report of the 2 different database schemas.
9 Dec 2010
AnupKumarYadav
Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)
14 Oct 2010
Ganesan Krishnan
Data Synchronization in SQL Express
22 Sep 2010
Kannan K R
In this article, we see a stored procedure to create pivot tables with multiple summary functions from an existing table.
9 Sep 2010
Abhijit Mahato
This article discusses the pitfalls encountered and their workarounds during development of BizTalk Projects
23 Aug 2010
Shivprasad koirala
VS 2010 Deployment (Package, One click deploy and Web.config transformation)
16 Aug 2010
Shivprasad koirala
.NET Best Practice No: 1:- Detecting High Memory consuming functions in .NET code
4 Jun 2010
Syeda Anila Nusrat
Create a Business Logic Layer, Data Access Layer classes, and Stored Procedure scripts from a database table.
25 May 2010
Muhammad alaa
use date and time as separated components in SQL Server 2000 and above
20 May 2010
Shivprasad koirala
6 steps to implement DUAL security on WCF using User name + SSL
5 Mar 2010
Shabdar Ghata
A sample program to demonstrate how to save or store images in SQL server
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.
22 Dec 2009
Suresh Suthar
How to execute DTS packages through VB.NET and use global variables.
8 Dec 2009
Gordon Kushner
Utility program for generating SQL Server INSERT scripts
17 Oct 2009
Nitinpatel
T-SQL script to generate the document of SQL 2000/2005 database
13 Oct 2009
pinaldave
Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup
4 Oct 2009
Shaun Wilde
Custom MembershipProvider and RoleProvider implementations that use web services in order to separate the application and database servers.
29 Sep 2009
Andrey Chuvahin
Example dynamic configuration of DTS-packages for transferring DBF files to SQL Server with VB
27 Sep 2009
acarpio1975
Given date ranged data, adjust existing ranges on entry of a new ranged data.
25 Sep 2009
Thiru Sagadevan
Showing Tooltip for each cell with data of a table in a Datagrid
25 Sep 2009
George Oakes
This library allows a user to use functions in SQL Server to encrypt and decrypt text.
22 Sep 2009
Abhijit Jana
Basic overview of temporary Tables in SQL Server 2005
19 Sep 2009
Paul Rony
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
13 Sep 2009
Md. Marufuzzaman
A simple example of SQL server admin tools.
7 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.
28 Aug 2009
weilidai2001
Instead of using incremental INSERT to generate test data, this method effectly copies the existing data multiple times.
25 Aug 2009
Jeremy Likness
Common table expressions (CTEs) are a powerful new construct for building advanced queries.
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.
19 Aug 2009
Md. Marufuzzaman
A list of Global variables in SQL Server and their uses in Transact-SQL
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.
17 Aug 2009
P. Ganesh Kumar
Helps in assigning row numbers in the returned result of an SQL query
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to split a string using Transact-SQL.
29 Jul 2009
Md. Marufuzzaman
This article will demonstrate the best practice to protect SQL server code object.
27 Jul 2009
Shivprasad koirala
Concurrency handling, compiled queries, CRUD implementation, and mapping simple .NET classes with XML file configuration.
25 Jul 2009
Md. Marufuzzaman
This article will demonstrate the procedure to shrink the database transaction log.
30 Jun 2009
mohamad halabi
Shows how to build new-design distributed applications with WF 4.0 and Data Services.
24 Jun 2009
Kuldip Rindani
Monitoring group of Linked SQL Servers from a SQL Server
22 Jun 2009
Kuldip Rindani
This script calculates size of every user database with summary
15 Jun 2009
Md. Marufuzzaman
This article will demonstrate how we can integrate T-SQL with an external application.
8 Jun 2009
noahhath
Building a hybrid Active Directory and SQL table DataSource view.
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
22 May 2009
Md. Marufuzzaman
An easy technique to store any file into SQL database
13 May 2009
Mohammad Al Hoss
Passing an array as parameter to SQL server Procedure
11 May 2009
Ladislav Nevery
Native MySql Client not requiring any special driver or library
29 Apr 2009
Raspberry Man
How to make custom datasource for CrystalReports engine using push model and .NET
29 Apr 2009
Kamran Hazari
How to create Linked servers in a minute in an easy way
22 Apr 2009
Christopher Geyer
Creating a sortable GridView is easy. But, what if you want to perform a nonalphabetic sort on a column that is alphabetical? Answer below...
20 Apr 2009
András Slyuch
This class collects data rows in the memory and saves them into a Microsoft SQL database with SqlBulkCopy.
26 Mar 2009
Vimalsoft(Pty) Ltd
How to Store and Retrieve a ConnectionString from a Web.Config or App.Settings File
24 Mar 2009
Shivprasad koirala
4 steps to use readymade DAL component (Data application blocks)
16 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.
3 Mar 2009
Alden John Snow
This project demonstrates what is likely the fastest way to upload one of those fixed width reports from a mainframe to a SQL server table.
3 Mar 2009
Zenab_Zenab
This article focuses on developing a workflow client device application for Pocket PC in C# 2003.
26 Feb 2009
Lindsey Lewis
An article about a tool for comparing SQL database schema versions
10 Feb 2009
ozkary
A VBScript script which allows to script out all the SQL Server objects in each independent file
3 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.
30 Jan 2009
GaryWoodfine
An explanation of Views in SQL server 2000/2005 and the advantages of them
29 Jan 2009
Nitesh Maharaj
1 alternative  
How to create simple and advanced pivot tables in C# and ASP.NET
26 Jan 2009
Gil Shabat
Real-world Use Case: a flexible approach to present dynamic content with SQL Server, ASP.NET, and XSLT.
11 Jan 2009
6opuc
Fast and easy to use data access class library.
8 Jan 2009
Amir Mehrabi-Jorshari
With this tool, you can compare two databases and generate a difference report.
22 Dec 2008
Neeraj Kr
Provides an insight into creating automated process for Backups and Restorations
17 Dec 2008
s_arun_kumar
Format Excel Sheet from DTS when Excel is not installed on SQL Server
16 Dec 2008
Navin Pandit
Pagination with Repeater control / custome pagination with data control in C# ASP.NET 2.0
13 Dec 2008
Enrique Albert
Console and GUI utility application that executes SQL scripts against SQL Servers (7, 2000, and 2005) - version 2.0.1.2 is now available.
17 Nov 2008
xbadenx
Merge data tables with validation audits and error logging.
26 Oct 2008
David A. Gray
MD5 Digest XSP with error trapping and full Unicode support, in and out.
9 Oct 2008
R. Giskard Reventlov
Simple export of data from database a to database b using identical tables (SQL Server).
3 Oct 2008
funklet
Make backups of SQL databases and upload them to FTP server
2 Oct 2008
Andrew J Dixon
Explaining Database deadlocking to non-technical people
1 Oct 2008
Casper Leon Nielsen
T-SQL Coding Standard - for programming the Microsoft SQL Server 2005 (DRAFT)
24 Sep 2008
Rai Shahid
This control will allow user to backup SqlServer
19 Sep 2008
Emil Lerch
Command line tool to check validity of objects in SQL Server databases
19 Sep 2008
Mohammad Ashraful Alam
Along with specification, examples and tools, a new visual modeling technique is being introduced, termed as “nAML” (.NET Application Modeling Language), which overcomes the limitation of typical modeling languages in a revolutionary way!
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.
10 Sep 2008
Dave Elliott
How to sort tables so data can be retrieved for offline sychronization and not violate foreign key relationships.
23 Aug 2008
Muhammad Shujaat Siddiqi
Defining SQL Server Alerts (shujaatsiddiqi.blogspot.com)
20 Aug 2008
Shivprasad koirala
Some caching interview questions: Part 1.
31 Jul 2008
TSells
Utility to manage multiple DB connection strings for an application.
26 Jul 2008
John Kenedy S.Kom
This project enables developers to create a setup package that automatically installs MSDE and attaches database
24 Jul 2008
David Hoyt
Easy to use ASP.NET suite that gives you everything you need to get started and makes it all pathetically easy to use - Windows services (with UAC), localization (webpage and e-mail), e-mail templating, configuration, and much, much more!
11 Jul 2008
Wiltek Ghozali
This utility is used for convert query result into *.CSV, *.TXT, *.XLS or Fill Into Crystal Report, supported SQL Server and ODBC connection.
10 Jul 2008
John Kenedy S.Kom
This is a .NET 3.5 library that acts as Data Access Layer with many automatic features
2 Jul 2008
Member 3209760
Creating CSV from SQL Database table attaching it to MS word as datasource and then creating mailmerge document
28 Jun 2008
Simon Gulliver
A lighweight approach to creating AJAX.NET-enabled grids, with advanced functionality built in.
26 Jun 2008
johnnycantcode
Create and manage your mobile database using SQL Management Studio and export them to SQL Compact Edition databases
20 Jun 2008
JustChiragPatel
No need to create web service for SSIS package call
11 Jun 2008
Srinath Gopinath
How to handle an array parameter in a Stored Procedure [SQL Server].
11 Jun 2008
Jimmy Zhang
Introduces a simple, efficient, human-readable XML index called VTD+XML.
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.
9 Jun 2008
Deepak.M
This article describes on building a Database from scratch using Batch File from the existing Database
7 Jun 2008
Bappi M Ahmed
SQL Server 2005 database backup and restore using C#, .NET 2.0, and SMO.
29 May 2008
madgardener
Simple destination script to use do updates with a sub query.
18 May 2008
defwebserver
A wizard that allows you to FTP an application to a remote server and then launch the configuration wizard from the web browser to update the database connection.
10 May 2008
Tariq Younas
Article describes how to make backup and recovery plan of MOSS 2007.
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.
3 May 2008
WillCaptain
ORMaper solution based on .NET (C#), add-in for VS IDE, and auto generating ORMaper code.
26 Apr 2008
Sudipta Chaudhari
This article gives a brief introduction about Triggers in SQL Server 2000/2005.
20 Apr 2008
gan.gary
An article on a SQL IDE for different type of RDBMS databases
15 Apr 2008
Ali Hamdar
How we can access the Windows Indexing Service using OLEDB.
24 Mar 2008
jangtimjang
Do you want to know what your DB programmers are doing?
17 Mar 2008
Shabdar Ghata
A Windows application to backup and restore SQL server tables,views,user defined functions and stored procedures
11 Mar 2008
Joe Negron
The SQL MAX() function is a little tricky when trying to work with numeric data - Not quite the same in other languages.
7 Mar 2008
Alexander Kojevnikov
sqlTunes is a small tool that exports iTunes library information to the SQL server.
3 Mar 2008
Alex Baker
Change collation order for all text columns in a database
29 Feb 2008
EJocys
How to create and compile SQL XML Documentation comments
23 Feb 2008
T.Ashraf
How to pass values between user control and ASPX page without JavaScript
31 Jan 2008
Muigai Mwaura
Query multiple databases in one expression e.g. an Microsoft Access Database and an SQL Server Database
23 Jan 2008
Muigai Mwaura
LINQ to SQL Transformation: Open Source implementation of IQueryable, examples and source code
21 Jan 2008
Sajid.Majeed
This article will address tools and technologies to identify bottlenecks and key consideration points for performance improvement.
16 Jan 2008
Paritor
Application to show differences between two SQL Server databases.
11 Jan 2008
Rafik Robeal
Build occasionally connected applications using Microsoft Synchronization Services for ADO.NET
11 Jan 2008
Vinoth Kumar.S
A tip for one of the problems found with Footer Text of ReportDesigner
11 Jan 2008
wburdick
A tip for one of the problems found with Footer Text of ReportDesigner
6 Jan 2008
mysorian
An HTML Native web Service on SQL Anywhere Database Server
31 Dec 2007
Sree Nivas
This generates Basic linq codes just by giving necessary inputs
30 Dec 2007
Redskin9
A series of Database utilities for lookup and data manipulation written in C#
29 Dec 2007
ericm1000
A simple Windows screen host utility that returns connection information (server name and port number) for all instances of SQL Server 2005, 2000, and 7.0 on a local machine.
23 Dec 2007
james.wren
How to add a modified on column in SQL Server using triggers.
22 Dec 2007
Moiz hakimi
This is an article about backup utility of SQL server from Command prompt
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 Dec 2007
mfmaneef
Explains how to send bulk records to a database using OPENXML.
15 Dec 2007
craigd
Single-player game using GEOMETRY datatype and spatial functions in SQL Server.
14 Dec 2007
konamiman.MSX
A C# class that uses the local file system to cache binary objects stored in a database.
12 Dec 2007
codelion
Simple bit of Transact SQL to help locate text in a database using cursors