The application migration process can appear complicated. There are many architectural differences between each relational database management system (RDBMS). The words and terminology used to describe Oracle architecture often have completely different meanings in Microsoft SQL Server. Additionally

There have been quite a few requests on how to take a string of comma-separated values (CSV), and parse out the values individually. graz's article uses a stored procedure to extract each value into a variable. However, if you have a table with a column of CSV values, and you want to translate t

SQL Server 2000 Wins eWEEK's eXcellence award for enterprise systems development. eWEEK on Thursday named 21 products and services as winners in its first annual eXcellence Awards program, the online competition to select the best new e-business products and services introduced during

From SQL Team Alex writes "I have a need to run a stored procedure which will insert multiple rows in the database. Biggest problem that I don't know from the begging how much inserts I need to do. I need to pass in the stored procedure an array of variables and loop over it. How I can

This article discusses facets of Microsoft SQL Server 7.0 textual searches such as: how SQL queries can be used on file systems lacking tables; how to use SQL extensions to make full-text queries; and how to work with a combination of file and database information. This article also discusses how Ba

SQL Server 7.0 Service Pack 3 (SP3) includes a fix for a problem with transactional replication of updates.

As you develop your SQL Server application, you look for ways to take advantage of features and code that already exist, rather than reinventing these features yourself. Consider the following possibilities:

This article describes how to use partitions to improve the manageability, query performance, and load speed of data warehouses in SQL Server 2000 Enterprise Edition. Horizontal partitioning of dimensional schema, both in the relational database and in Analysis Services cubes, is addressed.

From SQL Team.com…melanie writes "I am trying to return a string using Select *, left (newsitembodytext, 150) . . . As you can guess it is returning incomplete words. I need the last word to be complete any ideas?" I think we can put some string functions to use and solve this one.

Here is a portable, efficient way to access the entire SQL Server Magazine article database plus code listings and web exclusives. The CD includes topic, author, and issue indexes, comprehensive full text searching and no advertisements. It’s fast and easy. Click here to order your subscription.