After the publication of "Set Sail with Visual Studio .NET," February 2002, InstantDoc ID 23457, I received lots of questions from DBAs and developers who realized the importance of Visual Studio .NET to the next release of SQL Server, Yukon. Here...
Can I create in T-SQL a stored procedure that loops through rows and concatenates data into a variable, as I do in Visual Basic (VB)?
There are two basic ways to solve problems in T-SQL: row-by-row processing or set-based logic. Row-by-r...