|
|
|
|
|
Total Hits: 3 | Today: 0
|
Author: singh
|
Rating:
|
|

I was looking for a very simple wrapper generator that can give me ability generate C# code for my sql 2005 table. At the same time, I wanted flexibility to create various select queries based on various parameters. However, I couldn't find exactly what I was looking for. I also wanted optional capability to use Transactions. This lead me to create this code. I hope you can use this code to generate simple wrappers for yourself....
|
|
|
|
Total Hits: 4 | Today: 0
|
Author: Alaric Dailey
|
Rating:
|
|

I started out by reading the uuid RFC, the wikipedia article on uuids and the documentation on newid(). It turns out that it generates a version 4 uuid. Those are based on random or pseudo-random numbers, with certain nibbles set to certain values. To explain what that means, in simple terms if we replace all the random numbers with 'x', you will see that at position 14 there is the number '4', and at position 19, is a 'y'....
|
|
|
|
Total Hits: 4 | Today: 0
|
Author: Aaron Skonnard
|
Rating:
|
|

Microsoft .NET introduces a new suite of XML APIs built on industry standards such as DOM, XPath, XSD, and XSLT. The .NET Framework XML classes also include innovations that offer convenience, better performance, and a more familiar programming model, tightly coupled with the new .NET data access APIs—ADO .NET. XmlWriter, XmlReader, and XmlNavigator classes and classes that derive from them, including XMLTextReader and XMLTextWriter, encapsulate a number of functionalities that previously had to...
|
|
|
|
Total Hits: 4 | Today: 0
|
Author: Microsoft Corporation
|
Rating:
|
|

With XML support in SQL Server 2000, you can query SQL over HTTP with a URL, bring the data down to the browser, and manipulate it on the client machine. By adding Internet Explorer 5.0 to the mix and using XSL to convert the XML to HTML, you can lighten the load on your database server. Going still one step further, by using Vector Markup Language you can even create drawings on the fly using the data from your SQL queries....
|
|
|
|
Total Hits: 4 | Today: 0
|
Author: Dave Grundgeiger, Anson Goldade, and Varon Fugman
|
Rating:
|
|

Front-end developers frequently want to add functionality to the presentation tier of an n-tier architecture, but such requests can require changes on all tiers just to get the data and present it. This process can be made easier and more flexible by using SQL Server stored procedures to automate the delivery of data in XML format from the database to the front-end components. In the component presented here, stored procedures are invoked by XML strings, XML is returned, converted using XSL, and...
|
|
|
|
Total Hits: 4 | Today: 0
|
Author: Nancy Michell
|
Rating:
|
|

How can I get HTML code out of an XML document and into an HTML document? I have an XML document that looks like the following document:...
|
|
|
|
Total Hits: 6 | Today: 1
|
Author: Nancy Michell
|
Rating:
|
|

I want to add a number of dropdown boxes to the home page of my company's Web site so users can choose where they want to go from a number of categories (see Figure 1 for an example). What's the best way to implement this?...
|
|
|
|
Total Hits: 5 | Today: 0
|
Author: Nancy Michell
|
Rating:
|
|

I have a problem involving JScript® and ActiveX® objects. My code uses Visual Basic® to create an ActiveX object inside a JScript class. The problem is that when the page is refreshed, ActiveX is not released so the memory consumption grows....
|
|
|
|
Total Hits: 2 | 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: 6 | 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: 5 | Today: 0
|
Author: Nancy Michell
|
Rating:
|
|

What's the best way to store large amounts of XML data in SQL Server™? What are the performance implications of storing it in large chunks versus breaking it out into tables?...
|
|
|
|
Total Hits: 5 | Today: 0
|
Author: Microsoft Corporation
|
Rating:
|
|

WS-I stands for the Web Services Interoperability Organization, a new industry consortium whose goal is to promote interoperability across Web Services implementations. The WS-I was announced in February of this year. Founding members include Microsoft®, IBM, Intel, Oracle, SAP, HP, BEA Systems, Fujitsu, and Accenture. The founding members have already been joined by a long list of additional member companies, all of whom seem serious about ensuring interoperability between their various (and of...
|
|
|
|
|
|