Advertisement

1 - 10 of 12 containing alltags:("SQL Server 2005 / XML") (0.003 seconds)
Hi, I am in the process of sending out emails on an individual basis from my .net app, so I created an html template containing replaceable text for personalization, such as Name and other info. ...
Zones: Internet Marketing, Email Clients, Internet Adverti...Date Answered: 08/25/2008 Grade: A Views: 46
I have been searching this forum and have posted a question out there regarding asp.net System.Net.Mail and using eFax services. It seems that you have got this working ... I can successfully send ...
Zones: ASP.Net Programming, Visual Studio, WebApplicati...Date Answered: 03/24/2008 Grade: A Views: 0
I'm using bcp to generate an XML file that I'll e-mail to a customer via sp_send_dbmail.  The command I'm using looks something like this: xp_cmdshell 'bcp "SELECT field1, field2, field3 FROM my...
Zones: SQL Server 2005, MS SQL Server, XMLDate Answered: 03/05/2008 Grade: A Views: 0
Hi, We have a SP that accepts XML document as input to insert the set of records into the database and we need to return the inserted Object IDs (Identity primary key) along with the inserted da...
Zones: SQL Server 2005, Databases, XMLDate Answered: 04/08/2008 Grade: A Views: 48
Hi, We are receiving a XML document as input to update the records in a table. Inorder to update the data we are using the Primary Key columns (Identity Column) and a timestamp column. As par...
Zones: SQL Server 2005, XMLDate Answered: 09/20/2008 Grade: A Views: 103
I have a stored procedure which parses an XML and inserts into Database. I have the attached XML  and I want to insert Name, Phone, PIN into a table called "Person" Could you please help me how t...
Zones: SQL Server 2005, XMLDate Answered: 07/21/2008 Grade: A Views: 0
Greetings! I'm building some large xml documents from a number of relational tables in my database (SQL Server 2005).  Due to the scale of it, I have a number of scalar UDFs that return xml and ...
Zones: SQL Server 2005, MS SQL Server, SQL Serv...Date Answered: 09/03/2008 Grade: A Views: 8
Hi all, I have an XML document containing different nodes. Many of the nodes have attributes also. This document is inserted in database in one column which has XML data type...The database is i...
Zones: XML, SQL Server 2005Date Asked: 01/02/2008 Points: 500 Comments: 2
I have a xml path for example G:\xmlfiles\a.xml and tablename as a input for the stored procedure where i need to process the  xml file information and read the file s tags for example <proces...
Zones: SQL Server 2005Date Answered: 04/21/2008 Grade: B Views: 0
I am using FOR XML PATH. I would like to get rid of <row></row> ekements my SELECT produces. I want to be able to a) remove <roe> elemsnt b) replace it with <myElement> elements.
Zones: SQL Server 2005Date Answered: 07/24/2008 Grade: B Views: 0