Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored ...

SQL Server 2008, aka “Katmai,” gives SQL Server shops plenty of reasons to get excited. The best SQL Server release to date, it sports more nice new features than you can count, and the improvements ...

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...

BlueFinity will demonstrate how to create a simple SSIS transformation to move MultiValue data into MS SQL Server using mv.SSIS in a free webinar on November 30. Microsoft SQL Server includes a ...

BlueFinity International, a member of the Mpower1 Group of Companies, will present a free webinar on Thursday, June 18. The webinar will focus on how to create a simple SSIS transformation to move ...

SQL Server 2008 has a ton of new DBA features, but if you really want to make this thing go, just crank out a little code. SQL Server 2008 is mostly in the domain of system and database administrators ...

Editor's note: The CTP of next SQL Server "Katmai" was released. When Microsoft announced details of its next SQL Server database last month, the company went to great length to position it as a ...

Examine the similarities and differences between Windows security and SQL Server security and you'll find that most of the concepts you already know from managing a network will map quite nicely into ...

Many small businesses use databases to hold customer data, such as addresses and contact numbers, or financial information such as banking records. SQL, or Structured Query Language, is used to ...