Feeds:
Posts
Comments

Archive for August 1st, 2005

FOR XML and ADO.NET

Posted in Everything, Software Development, tagged , on August 1, 2005 | 1 Comment »

My esteemed colleague Sahil Malik has blogged about using FOR XML in SQL server.  The following C# example demonstrates how to retrieve XML data from a SQL Server 2K5 database as XML: using (SqlConnection conn = new SqlConnection(“…”)) { using (SqlCommand cmd = new SqlCommand( “select’Rob’ as [Employee/@EmployeeName],’A cool dude’ as [Employee] FOR XML PATH(‘Staff’)”, [...]

Read Full Post »

Follow

Get every new post delivered to your Inbox.