hi there...may i ask u about ur last posted "SQL Trigger to output to a text file" - 14 dec 2006
i have a task - need to retrieve data from txt file every 15minutes (if got any data changes or updates)..then the data will updated in existing table in db..but i dont know how to do it..i am a beginner in programming (asp.net + sql server)..hope u can help me...thanks
pr33tz
Last Activity: Apr 5 '07, 11:33 AM
Joined: Jul 6 '06
Location:
-
Thanks, that has partly worked. Is it possible to have the text file display the result in a csv format? i.e., "cust id","address"," tel_no" -
SQL Trigger to output to a text file
Hi,
I've been using SQL Server 2000 for a short while now and want to know if the following is possible. I've got two tables, Customer table and an Address table. I want to create a trigger that, when a new customer is added or amended, will output the changes to a text file. For example, if Mr Smith's address is created, it will pick up his name from the Customer table and his address from the Address table (linked by Cutomer_ID)... -
XML/XSLT Display Recursive Node
Hi all,
I have the following XSL file:
<xsl:template match="/">
<HTML>
<BODY>
<font face="Arial" size="4">Purcha se Order Details</font>
<xsl:apply-templates />
</BODY>
</HTML>
</xsl:template>
<xsl:template match="/por:Orders">
<TABLE WIDTH="100%"...
No activity results to display
Leave a comment: