|
|
|
|
|
Total Hits: 6 | Today: 0
|
Author: Christian Thilmany
|
Rating:
|
|
XML is becoming the ubiquitous data format on the Web, and XML support in SQL Server is evolving to meet the additional demand. Using XML, SOAP, HTTP, and SQL Server, you can now build powerful Web Services easily. To show just how simple it is with SQLXML 3.0, this article walks the reader through the process step by step, from setting up a virtual directory enabling data access via HTTP to executing queries and building Web Services. Finally, the author illustrates the creation of two Web Serv...
|
|
|
|
Total Hits: 3 | Today: 0
|
Author: Nancy Michell
|
Rating:
|
|
What's the best way to write data back to SQL Server™? Writing stored procedures seems reasonable using OPENXML, but it also seems that I have to manually specify the structure of my XML document every time I want to use OPENXML. What is the best way to pass XML back to SQL Server? Is there a way to specify a schema file when I do complex inserts or updates with OPENXML inside a stored proc?...
|
|
|
|
Total Hits: 9 | Today: 0
|
Author: Atif Aziz
|
Rating:
|
|
One major inconvenience of using SQL stored procedures from code is having to match type information. You have to write long wrapper functions around the procedures just to expose the data types. In the .NET Framework, however, the reflection services of the System.Reflection namespace allow you to query rich metadata that describe data types. This article explains how to use reflection in .NET to end your stored procedure nightmares. The author creates four custom classes, including one that ge...
|
|
|
|
Total Hits: 3 | Today: 0
|
Author: John Papa
|
Rating:
|
|
Handheld and other portable devices are shipping with ever growing feature sets. These devices can now communicate on private networks and over the Internet through Wi-Fi and built-in wireless modems that are combined with cell phones. Handheld devices are popular not only for personal use, but also many businesses are taking advantage of the mobility they offer. The growing demand for better portability means an increasing demand for mobile applications. One example could be an application that...
|
|
|
|
Total Hits: 3 | Today: 0
|
Author: Peter W. DeBetta
|
Rating:
|
|
The next version of SQL Server, code-named "Yukon," will offer enhanced support for user-defined types (UDTs). Because UDTs can be managed by the CLR, you can represent a wide variety of data structures to create types not possible with previous versions of SQL Server. With UDTs you can more precisely control the kind of data your type accepts, resulting in better data management. This article explores UDTs in "Yukon" and covers their design and implementation....
|
|
|
|
Total Hits: 3 | Today: 0
|
Author: James McCaffrey
|
Rating:
|
|
Many Windows®-based applications have a SQL Server™ back-end component that contains stored procedures. Although techniques to automatically test functions in the front-end code are well known, the techniques to write test automation for stored procedures are not. SQL Server 2005 will provide greatly enhanced integration with the Microsoft® .NET Framework including the ability to write stored procedures in C# and other .NET-targeted languages. This will certainly increase the use of stored proce...
|
|
|
|
Total Hits: 7 | Today: 0
|
Author: James Yip
|
Rating:
|
|
SQL Server™ 2005 Reporting Services from Microsoft is a great tool that offers a centralized approach to storing and rendering reports. It also allows users to view and download reports without installing additional software. But what's most convenient for users is that reports can be saved in any number of different formats using custom report renderers. In this article, I will demonstrate how to develop one such report renderer that outputs HTML reports, but the skills you'll learn can easily ...
|
|
|
|
Total Hits: 4 | Today: 0
|
Author: John Papa
|
Rating:
|
|
SQL Server™ 2000 includes several XML features that let you transform relational rowsets into hierarchical XML documents, read XML documents, and bulk load data via XML. For example, you can pass an XML document to a stored procedure, join the XML to some tables and return a rowset, or even modify data in the database. The inclusion of the OPENXML function and the FOR XML statement have been prompted by the ever-expanding role of XML in today's enterprise systems. Some of these features not only...
|
|
|
|
Total Hits: 3 | Today: 0
|
Author: Jeffrey Richter
|
Rating:
|
|
In my career, I have architected and implemented many thread synchronization techniques. This has provided me with a lot of experience that has shaped the way I now think about thread synchronization problems. In this new column about concurrency, I will discuss my way of thinking on the subject and offer some code that I think you'll find useful when dealing with thread synchronization problems yourself....
|
|
|
|
Total Hits: 4 | Today: 0
|
Author: Jeff Prosise
|
Rating:
|
|
Now that ASP.NET 2.0 is a shipping product, it seems appropriate to revisit an issue that tops the new features wish lists of many developers: a SQL Server™ site map provider.
As you probably know, ASP.NET 2.0 vastly simplifies the process of building data-driven site navigation interfaces. You build a site map, slap a SiteMapDataSource control onto the page, and bind a Menu or TreeView control to the SiteMapDataSource. The SiteMapDataSource uses the default site map provider (typically XmlSi...
|
|
|
|
Total Hits: 8 | Today: 0
|
Author: Sumit Garg From Chandigarh
|
Rating:
|
|
Data type synonyms can be used instead of the corresponding base data type name in data definition language (DDL) statements, such as CREATE TABLE, CREATE PROCEDURE, or DECLARE @variable. However, after the object is created, the synonyms have no visibility. When the object is created, the object is assigned the base data type that is associated with the synonym. There is no record that the synonym was specified in the statement that created the object....
|
|
|
|
Total Hits: 6 | Today: 0
|
Author: pinaldave
|
Rating:
|
|
I recently received few comments that I have not written on simple subjects recently. In fact, this blog is dedicated to all those who are really learning SQL Server and almost all the articles and posts are posted here keeping this goal in mind. One of the questions in the email which requested to write simple subjects was “Does the order of columns in UPDATE statements matter?” Let me try to answer this question today....
|
|
|
|
|
|
