Posts

Showing posts from August, 2009

Webpart Overview

MSDN article for Webpart Overview: http://msdn.microsoft.com/en-us/library/ms432401.aspx

Open Source Bug Traker S/w

The Follwing is the open Source Bug Tracker Application, which is written in ASP.Net/C# and Sql Server2005. http://ifdefined.com/bugtrackernet.html Thank You.

Get SQL Records using XQuery

XML DataType Functions: Function Description Query Gets a set of nodes from an XML document/fragment (returns XML) Value Gets a single value from an element or attribute of an XML document/fragment (returns scalar value) Exist Returns a Boolean value indicating if the XQuery expression returns values Modify Changes values in an XML document/fragment Nodes Gets a context to a node based upon the XQuery expression The Following Query runs on AdventureWorks HumanResources.JobCandidate Table to get all Employee First Name & Last Name, Telephone Nos. SELECT Resume . query ( 'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume"; data(/Resume/Name/Name.First)' ) FirstName , Resume . query ( 'declare default elemen