No announcements
Found 1284253 threads
-
0 VotesDynamic SQL and Datatype XML
Try this example: CREATE TABLE #temp (data XML) DECLARE @x XMLSELECT @x = '<name>jacob</name>' DECLARE @sql NVARCHAR(MAX)SELECT ...Answered | 4 Replies | 12181 Views | Created by Developer_Usa - Tuesday, December 9, 2008 4:58 PM | Last reply by Desu - Tuesday, February 24, 2009 4:26 AM
-
0 Votes
xml ,xsl and sincronization xml
Generating XSL to modify XML is a good idea but you need to take care (copy) all nodes you don't want to touch.Answered | 1 Replies | 3946 Views | Created by giuseppe500 - Tuesday, May 3, 2011 10:38 AM | Last reply by Kurt Song - Wednesday, May 4, 2011 1:13 PM -
0 Votes
Substitue for image datatype
XML format...Answered | 3 Replies | 3975 Views | Created by 498634333 - Friday, May 21, 2010 2:59 PM | Last reply by KiranKumar.Y - Friday, May 21, 2010 7:37 PM -
0 Votes
XML and XSL processing with c#
I am a newbee to XML and XSl.I have an xml and a corresponding xsl wherein the indivisual XML elements are displayed using textboxes and dropdowns ...Answered | 3 Replies | 3433 Views | Created by Bharath_See - Thursday, September 17, 2009 3:13 AM | Last reply by Martin Honnen - Thursday, September 17, 2009 10:44 AM -
0 Votes
xml to notepad using xsl in C#
At the time I just read required tags and write data to a text file from the xml file.Answered | 4 Replies | 3789 Views | Created by lookingtobe - Friday, August 15, 2008 2:34 AM | Last reply by lookingtobe - Monday, August 18, 2008 2:16 AM -
0 Votes
sql Image datatype in xsl/xml
User1288087783 posted I have image datatype and I am having also image handler to render images but how you create XML and generate ...Answered | 2 Replies | 24 Views | Created by Anonymous - Thursday, December 31, 2009 3:21 AM | Last reply by Anonymous - Wednesday, April 24, 2013 2:11 AM -
2 Votes
Help with XSL to display XML
The date format is exactly the same in your desired xml output.Answered | 4 Replies | 3904 Views | Created by WDC Online - Friday, October 7, 2011 3:08 AM | Last reply by Link.fr - Sunday, October 9, 2011 10:17 PM -
0 Votes
specifying datatype for xml tag
Something like this should work: DECLARE @employees TABLE ( employeeId INT IDENTITY PRIMARY KEY, employeeXML XML ) INSERT INTO @employees ( employeeXML ...Answered | 1 Replies | 4928 Views | Created by Navaneeth Adruguli - Thursday, August 2, 2012 1:57 PM | Last reply by wBob - Thursday, August 2, 2012 2:31 PM -
4 Votes
IN clause for xml datatype
You can also use it with .nodes method of the xml datatype.Answered | 11 Replies | 5420 Views | Created by IT researcher - Tuesday, January 22, 2013 7:50 AM | Last reply by wBob - Thursday, March 7, 2013 11:03 AM -
0 Votes
About xml datatype in SQLServer2005
Please tell me the method how can we use xml datatype in sql.Answered | 1 Replies | 15512 Views | Created by BhaktiSontakke - Thursday, March 13, 2008 9:16 AM | Last reply by Andrew Brenner - Monday, April 14, 2008 3:29 PM -
0 Votes
Image datatype and aggregates
) select a, b, c, image from cte where rn = 1Answered | 2 Replies | 4934 Views | Created by Azher Aziz - Tuesday, April 5, 2011 10:43 AM | Last reply by Christa Kurschat - Tuesday, April 5, 2011 10:52 AM -
0 Votes
restoring the table with datatype image
The adaption for the IMAGE data type can then be done be the people how want to help.Answered | 4 Replies | 1640 Views | Created by nikijain - Monday, December 19, 2011 10:29 AM | Last reply by Stefan Hoffmann - Monday, December 19, 2011 12:36 PM -
0 Votes
Merge 2 XML using XSL
xml version="1.0" encoding="utf-16" ?Answered | 15 Replies | 7585 Views | Created by RPaul18 - Tuesday, July 3, 2012 11:28 AM | Last reply by RPaul18 - Thursday, July 5, 2012 3:40 PM -
0 Votes
Converting a text datatype to xml datatype
xml version="1.0" encoding="utf-16"?Answered | 3 Replies | 7089 Views | Created by SelvaKumar Chandrasekar - Tuesday, November 17, 2009 7:35 AM | Last reply by Vankireddy Sreenadha - Tuesday, November 17, 2009 12:11 PM -
0 Votes
How to convert Image datatype to text datatype in SQLServer 2008 IntegrationServices
check if this link helps you http://cavemansblog.wordpress.com/2009/04/24/sql-how-to-convert-image-data-type-to-plain-text-and-back/ Nitesh Rai- ...Answered | 2 Replies | 23064 Views | Created by Gajula - Friday, September 4, 2009 5:16 AM | Last reply by Duane Douglas - Wednesday, September 9, 2009 7:32 AM -
0 Votes
Sql DataType
Hi, With fixed width datatypes ( char and nchar), number of bytes will be used even if the lenght of data is not big.Answered | 8 Replies | 2227 Views | Created by nikijain - Friday, June 22, 2012 11:30 AM | Last reply by Chintak Chhapia - Friday, June 22, 2012 1:56 PM -
0 Votes
Convert String to Sql Datatype!!!
Hi,Following code snippet may help to convert string to DataType: // Mock user's input.Answered | 3 Replies | 4471 Views | Created by Avani Raval - Thursday, October 8, 2009 1:26 PM | Last reply by eryang - Monday, October 12, 2009 7:46 AM -
0 Votes
SQL Send adapter call stored proc with xml datatype
Hi Vishy, The input xml needs to be added as encoded string.Answered | 3 Replies | 6754 Views | Created by VishyHCL - Tuesday, December 1, 2009 5:15 PM | Last reply by Wen-Jun Zhang - Tuesday, December 8, 2009 10:00 AM -
0 Votes
XML => XSL Transform can't get to work..
I do not how the XML file is created, however it is under ths namesapce: xmlns=http://microsoft.com/schemas/VisualStudio/TeamTest/2010 But the ...Answered | 8 Replies | 2344 Views | Created by Greg B Roberts - Wednesday, October 2, 2013 1:30 AM | Last reply by Fred Bao - Tuesday, October 29, 2013 9:55 AM -
0 Votes
XSL sub selecting from XML: All or just selected records?
However, the 'transformed' XML is returned as a result.Answered | 2 Replies | 8863 Views | Created by AAsk - Sunday, August 15, 2010 6:05 PM | Last reply by Qi Samuel Zhang - Monday, August 16, 2010 4:52 AM - Items 1 to 20 of 1284253 Next ›
No announcements
