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...
I created a unique constraint on a column called Col1 in table Test1 to enforce uniqueness with the exception of NULL. The entry for "Unique Constraint" in SQL Server Books Online (BOL) specifically says that you can create a unique constraint on...
table.downloadBox {
width: 100%;
border: solid 1px #666;
border-collapse: collapse;
}
table.downloadBox th {
background: #276C9F;
padding: 3px;
color: #fff;
font-size: 14px;
text-align: center;
}
...
Editor's Note: SQL Server Magazine welcomes feedback about the magazine. Send your comments to letters@sqlmag.com. Please include your full name, email address, and daytime phone number with your letter. We edit all letters and replies for style...
table.downloadBox {
width: 100%;
border: solid 1px #666;
border-collapse: collapse;
}
table.downloadBox th {
background: #276C9F;
padding: 3px;
color: #fff;
font-size: 14px;
text-align: center;
}
...
The only measures useful in some types of analysis are measures that are derived from multiple loaded measures (i.e., those from the fact table) or from some calculation that uses other dimensions. In such cases, you need to create a cube that has...
Windows 2000's Kerberos authentication has a lot of bite for your buck...
In SQL Server 2000, how can I list a database's stored procedures and their change dates...