We care, we listen, and we want to serve you better! This week, I want to gather information about you and your SQL Server deployments so we can tailor the contents of SQL Server Magazine UPDATE to meet your needs as effectively as possible. I...
XML plays a key role in the .NET Framework because XML is widely used and tightly integrated with ADO.NET and because many classes that you can use to read, write, and navigate in XML documents support XML as a file format. The .NET Framework...
You've probably heard of Simple Object Access Protocol (SOAP). Now, we also have XML-based messaging and envelopes. The MessageML Forum, an industry standards body, is working on MessageML, an open standard for sending XML messages. Somewhere...
T-SQL includes ReadText(), WriteText(), and UpdateText() functions that you can use to work with the data that text, ntext, and image columns contain. However, unlike the much more powerful ADO Stream functions, these T-SQL functions are limited...
Last week, I discussed IBM's acquisition of Informix and its declared intention to come out on top in the database wars. This week, I explore the same issue from a different angle. On May 15, IBM DB2 (interestingly, running on Linux) posted a new...
Calculated cells let you vary numerical accuracy on a cell-by-cell basis ...
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;
}
...
Use SQL-DMO to manage SQL Server views and stored procedures