A good analysis solution provides up-to-date, relevant information. For some businesses, the most important information predicts end-of-quarter sales figures. Using the FoodMart 2000 Sales cube, create a calculated measure that returns a...
I'm using an INSERT INTO...SELECT * FROM bulk statement to insert records into a table. If I write a trigger on the target table that executes on INSERT, will the trigger fire for each row inserted? If not, how can I get the trigger to fire for...
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;
}
...
I'm using Enterprise Manager to alter the structure of a table that has 3 million rows. Enterprise Manager locks up whenever I try to change the nullability of one column from NOT NULL to NULL. Is this problem a known bug...
Visual Studio .NET, the latest evolutionary step of Microsoft's premier application-development platform, includes more database-integration tools than earlier versions of Visual Studio (VS). Many of the new tools are direct descendants of the...
No discussion of Visual Studio .NET would be complete without a mention of the Microsoft .NET Framework software development kit (SDK). The two products are different but intimately related. Visual Studio .NET is an application-development tool...
Can I use bulk copy program (bcp) to copy the result set of a stored procedure to a file...