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 ...

In the last article we we looked at the new feature of .NET integration into the upcoming version of SQL Server 2005. This time we look at some more innovations in SQL Server by using the .NET ...

Microsoft continues to make positive strides in the world of open source. The company once considered open source software to be an anathema, but now it’s common for Microsoft to pull software ...

Microsoft says that dropping CLR into SQL Server will be a boon for enterprise developers because codejockeys will be able to use the .NET programming languages of their choice. For programmers who ...