No announcements
Found 1178728 threads
-
0 VotesSQL. connectiondstrings?
The XML itself was generated from a SQL Server database and we had a forms application made in Access that directly interacted with the SQL Server so that the ...Unanswered | 4 Replies | 19 Views | Created by Anonymous - Monday, January 8, 2018 5:08 PM | Last reply by Anonymous - Monday, January 15, 2018 9:01 AM
-
0 Votes
XML performance problem
This 'repro' (reproduction) runs in a second on my laptop ( Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) ): USE tempdb GO CREATE ...Answered | 3 Replies | 7251 Views | Created by mpaulf - Wednesday, February 24, 2010 6:14 PM | Last reply by mpaulf - Thursday, February 25, 2010 8:10 PM -
2 Votes
Biztalk to transform XML into SQL
HTH, Naushad Alam When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, ...Answered | 4 Replies | 5189 Views | Created by Malek Safa - Wednesday, April 11, 2012 8:44 AM | Last reply by Naushad.Alam - Wednesday, April 11, 2012 10:39 AM -
0 Votes
Azure SQL DB performance
the bottle neck was the bulk import and the issue was the storage was in Europe and sqldb in US :) it's still 2 times slower than on prem...but i assume you will never get the same ...Answered | 4 Replies | 594 Views | Created by PC_07 - Thursday, April 12, 2018 7:58 PM | Last reply by JRStern - Friday, April 13, 2018 5:21 PM -
0 Votes
XML Data to SQL?
Then you can write T-SQL and make use of the XQuery functions exposed by the XML-typed column to retrieve the specific data you want from those config files.Answered | 2 Replies | 11426 Views | Created by dm32813281 - Sunday, June 12, 2011 8:45 PM | Last reply by opc.three - Thursday, June 16, 2011 8:51 PM -
0 Votes
SQL to XML
DECLARE @T TABLE(column1 VARCHAR(99),column2 VARCHAR(99)) INSERT INTO @T VALUES('this is col1','this is col2') INSERT INTO @T VALUES('this is ...Answered | 4 Replies | 1609 Views | Created by Deepujagan - Friday, March 20, 2015 2:29 PM | Last reply by Eric__Zhang - Monday, March 23, 2015 3:29 AM -
0 Votes
SQL Variable XML to SQL Table
Then use INSERT-SELECT to perform the insert.Answered | 3 Replies | 4304 Views | Created by Nishit Badani - Monday, November 26, 2012 11:25 PM | Last reply by Nishit Badani - Tuesday, November 27, 2012 12:17 AM -
1 Votes
T-SQL query as XML
I use the xml data for a migration, because *.csv is way bulkier that xml :) Thank you!Answered | 5 Replies | 8110 Views | Created by Kirizzle - Wednesday, February 2, 2011 12:45 PM | Last reply by Naomi N - Tuesday, February 8, 2011 2:14 AM -
0 Votes
sql and xml
Have a look through this article: Introduction to XQuery in SQL Server ...Answered | 4 Replies | 4021 Views | Created by SunnyIngulia - Friday, November 5, 2010 9:15 AM | Last reply by SunnyIngulia - Friday, November 5, 2010 11:17 AM -
0 Votes
SQL to XML to ZIP via SSIS
The second one might be because your sql server agent job proxy account does not have access to the folder where it is trying to write the xml file.Answered | 14 Replies | 4756 Views | Created by _c - Wednesday, September 5, 2012 10:58 AM | Last reply by pareri - Tuesday, September 18, 2012 7:27 AM -
6 Votes
XML data in a SQL Server column
In those cases I generate and keep the XML when I send and keep the XML I got from some other source.Answered | 3 Replies | 9451 Views | Created by CYAD - Wednesday, August 25, 2010 1:18 AM | Last reply by JRStern - Wednesday, August 25, 2010 3:22 AM -
0 Votes
insert xml data into sql
Im trying to get the xml into a CTE, using the following code but I get incorrect syntax on line 38 (the last bracket): DECLARE @xml ...Answered | 5 Replies | 4694 Views | Created by airwalker2000 - Tuesday, January 15, 2013 3:28 PM | Last reply by wBob - Friday, January 18, 2013 11:53 AM -
0 Votes
Parsing xml column in SQL
./... you will find that this performs better: DECLARE @xml xml = ' <GLPosting xmlns:xsd="http://www.w3.org/2001/XMLSchema" ...Answered | 7 Replies | 1050 Views | Created by wkpli - Friday, February 3, 2017 3:28 PM | Last reply by Hilary Cotter - Wednesday, February 8, 2017 8:40 PM -
0 Votes
Sql server XML
A simple search on SQL Server XML brings you lots of articles including ...Answered | 7 Replies | 1377 Views | Created by ponraman M - Friday, November 7, 2014 8:02 AM | Last reply by Visakh16 - Friday, November 7, 2014 9:38 AM -
1 Votes
SQL to XML
Also see http://visakhm.blogspot.in/2013/12/generating-nested-xml-structures-with.html Please Mark This As Answer if it helps to solve the issue Visakh ...Answered | 5 Replies | 1761 Views | Created by canadianCode - Friday, February 14, 2014 2:41 PM | Last reply by Visakh16 - Friday, February 14, 2014 5:48 PM -
0 Votes
Dynamic 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 | 12158 Views | Created by Developer_Usa - Tuesday, December 9, 2008 4:58 PM | Last reply by Desu - Tuesday, February 24, 2009 4:26 AM -
1 Votes
Exactly what is the Use of POCO, and Self tracking entites
What are Self-Tracking Entites Defination of STE, from MSDN "The ADO.NET Self-Tracking Entity Generator template generates the object-layer code ...Answered | 1 Replies | 1768 Views | Created by N S R Krishna Sombhotla - Friday, August 24, 2012 1:42 PM | Last reply by Glenn Condron - Friday, August 24, 2012 4:35 PM -
0 Votes
xml and Transact SQL
Go to http://beyondrelational.com/xml/default.aspx, navigate to the very first page and start reading from the first lab to the next.Answered | 5 Replies | 5169 Views | Created by SunnyIngulia - Wednesday, November 3, 2010 3:46 PM | Last reply by SunnyIngulia - Thursday, November 4, 2010 8:17 AM -
0 Votes
T-SQL for importing XML
OPENROWSET has to take literal filenames but you can work round using dynamic SQL, sp_executesql and OUTPUT variables, eg DECLARE @rawXml NVARCHAR(MAX) DECLARE ...Answered | 7 Replies | 4227 Views | Created by Andy_Jansen - Wednesday, July 31, 2013 12:30 PM | Last reply by wBob - Thursday, August 1, 2013 2:30 PM -
0 Votes
XML IMPORT TO SQL SERVER AND EXPORT TO XML FROM SQL SERVER SSIS
Check the data flow task where there is XML source and you can load the data from XML Source to SQL Server destination.Answered | 1 Replies | 3646 Views | Created by kingraju - Thursday, August 11, 2011 1:54 PM | Last reply by DeepakKumarKalyanum - Thursday, August 11, 2011 2:04 PM - Items 1 to 20 of 1178728 Next ›
No announcements
