No announcements
Found 2896279 threads
-
0 VotesHow Data is stored in sql server 2005?
Physically data is stored in database disk files.Answered | 6 Replies | 4398 Views | Created by developer_rk - Thursday, April 29, 2010 6:17 AM | Last reply by Dave Ballantyne - Thursday, April 29, 2010 11:14 AM
-
0 Votes
Querying XML data in SQL Server 2005
LINQ to SQL supports retrieving an XML column's data as a System.Xml.Linq.XElement instance but does not support running XQuery on that data.Answered | 5 Replies | 3703 Views | Created by johneanderson - Monday, February 23, 2009 9:17 PM | Last reply by Hooray Hu - Sunday, March 22, 2009 11:23 AM -
0 Votes
How to write C# Programming for Insert XML data to SQL Server 2005
>How to write C# Programming for Insert XML data to SQL Server 2005 SQL Server 2005 onwards we can pass a ...Answered | 4 Replies | 3725 Views | Created by PrasantaBangla - Saturday, June 11, 2016 7:12 AM | Last reply by Zhanglong Wu - Wednesday, June 15, 2016 7:55 AM -
6 Votes
XML data in a SQL Server column
I don't architect XML into my design for my business data unless there is a specific reason.Answered | 3 Replies | 9457 Views | Created by CYAD - Wednesday, August 25, 2010 1:18 AM | Last reply by JRStern - Wednesday, August 25, 2010 3:22 AM -
0 Votes
XML Data to SQL?
The catch in your case is that it will require that you provide a SQL-Server-annotated XSD file for each "flavor" of config file you want to ...Answered | 2 Replies | 11435 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 Server peer-to-peer synchronize between table and data stored in XML
</permissions> </data> The roles, permissions, etc. entities stored in the ...Answered | 6 Replies | 7413 Views | Created by Glenn2654 - Monday, June 7, 2010 3:30 PM | Last reply by jigu2014 - Tuesday, June 8, 2010 5:24 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 | 3674 Views | Created by kingraju - Thursday, August 11, 2011 1:54 PM | Last reply by DeepakKumarKalyanum - Thursday, August 11, 2011 2:04 PM -
0 Votes
Difficulty in partially shredding xml in sql server 2005
Try this example: DECLARE @xml XML SET @xml = '<start> <segment> <data ...Answered | 3 Replies | 6882 Views | Created by Ray53 - Wednesday, November 4, 2009 10:12 PM | Last reply by Ray53 - Thursday, November 5, 2009 5:11 PM -
0 Votes
Once MDF File store into 2 Drives in MS SQL server 2005?
SQL Server uses a proportionate fill method for writing data to the data files.Answered | 5 Replies | 5414 Views | Created by SAAD's - Friday, December 11, 2009 2:34 PM | Last reply by Jonathan Kehayias - Friday, December 11, 2009 7:58 PM -
0 Votes
SQL Server 2005 to SQL 2012 - XML Conversion
DECLARE @Xml TABLE ( Data XML ); INSERT INTO @Xml ( Data ) SELECT * FROM ...Answered | 3 Replies | 1813 Views | Created by Peter The Spate - Friday, September 20, 2013 11:09 AM | Last reply by Stefan Hoffmann - Friday, September 20, 2013 2:53 PM -
0 Votes
SQL Server 2005 Data File Location
This can be set in server properties (right-click SQL server in SSMS, look for Default Data File, and Default Log File) or you ...Answered | 7 Replies | 26166 Views | Created by EJLindsay - Tuesday, February 27, 2007 5:38 PM | Last reply by Ashish Kumar Mehta - Friday, November 26, 2010 6:06 AM -
0 Votes
XML Newbie: sql 2005 compliance to XML standards
The XML standard says users should not use names beginning with the letters x, m, l, but not does not strictly forbid it.Answered | 1 Replies | 6645 Views | Created by edm2 - Friday, November 24, 2006 8:27 AM | Last reply by SNMSDN - Sunday, November 26, 2006 1:59 AM -
0 Votes
Moving XML data into Sql Server
Hi Juniormint10, You can refer to the following link: Generate SQL schema from XSD and load XML files into SQL ...Answered | 7 Replies | 1843 Views | Created by Juniormint10 - Thursday, November 14, 2013 6:28 PM | Last reply by Allen Li - MSFT - Thursday, November 21, 2013 7:57 AM -
0 Votes
Storing data in XML file
I want to store the data in XML files.Answered | 2 Replies | 3444 Views | Created by Bob ONeill - Friday, February 20, 2009 2:30 AM | Last reply by Malleswara Reddy [MCTS, MCP] - Wednesday, February 25, 2009 2:15 PM -
0 Votes
Import XML data into SQL Server
What version of SQL Server are you using?Answered | 2 Replies | 10594 Views | Created by davidlcrooks - Monday, May 24, 2010 7:47 PM | Last reply by davidlcrooks - Wednesday, May 26, 2010 6:48 PM -
0 Votes
how to store XML data and retrieve xml data From .sdf
Other than this, there is no XML column type like in SQL Server 2008.Answered | 3 Replies | 8361 Views | Created by Sumit Chaturvedi - Monday, June 21, 2010 8:52 AM | Last reply by ErikEJ - Friday, June 25, 2010 6:53 AM -
0 Votes
Linked Server on SQL Server 2005 to Flat file stored on network drive
I was going to ask whether there is something that is configurable on the SQL Server itself, but from your comments, is it safe to say it all depends on which ...Answered | 3 Replies | 6162 Views | Created by Kontact00 - Tuesday, October 20, 2009 2:40 PM | Last reply by Lekss - Wednesday, October 21, 2009 9:46 AM -
0 Votes
SQL 2005 - Storing GPS tracking data in a database
Hi ANSA_Naz If you would like to store data from GPS watch into a SQL Server 2005 database, we need to note the data type in ...Answered | 5 Replies | 5575 Views | Created by ANSA_Naz - Thursday, October 10, 2013 4:02 PM | Last reply by jamie_isl - Saturday, November 30, 2013 7:41 PM -
10 Votes
How to debug stored procedure in SQL server 2005
I am using SQL server management studio in 2005 ?Answered | 18 Replies | 82518 Views | Created by Sujithf - Thursday, January 18, 2007 12:56 PM | Last reply by Kalman Toth - Thursday, November 29, 2012 10:59 AM -
1 Votes
Compatibility of SQL Server 2005 with XML/A (32-Bit)
Not sure much has changed between 2005 and 2008 in terms of XMLA.Answered | 2 Replies | 2130 Views | Created by Syed Anas Baqi - Tuesday, January 1, 2013 7:58 AM | Last reply by Syed Anas Baqi - Wednesday, January 2, 2013 7:08 AM - Items 1 to 20 of 2896279 Next ›
No announcements
