Search:
Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in Data Transformation Services (DTS)

Interview Question :: Help in SqlServer 2000

Create dts package in sql server 2000
that will execute stored procedure and display output as an xml file.

in short, i need,
steps To create an XML file from a SQL stored procedure in Sql Server 2000.

Answers to "Help in SqlServer 2000"

RE: Help in SqlServer 2000?
You use the FOR XML clause in your queries to return XML data instead of a record set. When used in a SELECT statement, the FOR XML clause tells SQL Server to return the data as XML as opposed to a standard rowset. You can specify the mode: RAW, AUTO, or EXPLICIT. Each offers a different way to transform the XML. For more information, read this article: http://msdn.microsoft.com/en-us/magazine...
Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Top Tags

- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers

Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in Data Transformation Services (DTS)

Interview Question :: Help in SqlServer 2000

Top Tags