No announcements
Forums [ view all ]
-
Select allSQL Server Data WarehousingSQL Server Integration ServicesData MiningSQL Server Reporting Services, Power ViewSQL Server Analysis ServicesSQL Server ToolsTransact-SQL.NET Framework inside SQL ServerSQL Server Data AccessSQL Server SMO/DMOSQL Server XMLSQL Server ReplicationSQL Service BrokerSQL Server SecuritySQL Server Database EngineSQL Server DocumentationSQL Server Setup & UpgradeSQL Server High Availability and Disaster RecoverySQL Server Notification ServicesSQL Server CompactGetting started with SQL ServerDatabase MirroringSQL Server ExpressMicrosoft Drivers for PHP for SQL ServerSQL Server SearchSQL Server SpatialDatabase DesignSQL Server Master Data ServicesSQL Server ManageabilitySQL Server PowerPivot for SharePointSQL Server PowerPivot for ExcelSQL Server Application and Multi-Server ManagementSQL Server Samples and Community ProjectsMicrosoft StreamInsightSQL Server MigrationSQL Server Data Quality ServicesSQL Server Distributed Replay
-
Select allSystem Center Mobile Device Manager
-
Select allBizTalk Server GeneralBizTalk Server Adapters and Adapter PackBizTalk Server EDI and AS2BizTalk Server RFIDBizTalk Server Host Integration Server
-
Select allExchange Server 2013 - General DiscussionExchange Server 2013 - Administration, Monitoring, and PerformanceExchange Server 2013 - High Availability and Disaster RecoveryExchange Server 2013 - Outlook, OWA, POP, and IMAP ClientsExchange Server 2013 - Mobility and ActiveSyncExchange Server 2013 - Setup, Deployment, Updates, and MigrationExchange Server 2013 - Extended Components, Tools, and UtilitiesExchange Server 2013 - Mail Flow and Secure MessagingExchange Server 2013 - Unified MessagingExchange Server 2013 - Sharing and Collaboration: Site Mailboxes and Public FoldersExchange Server DevelopmentExchange Server 2013 Preview (locked)
-
Select allTechNet Website FeedbackMSDN and TechNet Search FeedbackTechNet Wiki Discussion
-
Select allForefront Identity Manager 2010
-
Select allMicrosoft Operations Framework -- MOF 4.0
-
Select allIT Management Planning and Technology
-
Select allTraining and Certification
-
Select allLive Meeting General DiscussionLive Meeting - Creating, Joining Meetings, Configurations and SettingsLive Meeting - In Meeting Experience, Console and Add-insLive Meeting - Media DiscussionLive Meeting - Rollout/Deployment Programs
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Sticky0VotesWelcome message and some guidelines
Welcome dear seeker of XML knowledgePlease take some time to read this welcome message that can help you find your answer quicker.Please take a look at previous postings to see whether your question ...3 Replies | 36405 Views | MRys - Friday, November 04, 2005 8:20 PM | Last Reply mafsar09 - Tuesday, February 12, 2013 3:53 PM
-
Unanswered0Votes
Search for string in xml column
0 ) Is there any other method other than casting the column as varchar so that performance of the query is increased?7 Replies | 63 Views | IT researcher - Friday, June 21, 2013 11:14 AM | Last Reply Erland Sommarskog - 4 hours 27 minutes ago -
Unanswered0Votes
xml table join issue
I have below xml DECLARE @t TABLE ( ID INT IDENTITY, Data ...3 Replies | 43 Views | Vishnu Dalwadi - 23 hours 43 minutes ago | Last Reply Erland Sommarskog - 15 hours 24 minutes ago -
Unanswered0Votes
How can I created a typed XML column from a schema file on a remote server?
We create our database using SQLCmd with files containing the DDL, using the :r directive. This has worked well on both local and remote systems. Recently we had to add in a typed XML column, ...1 Replies | 54 Views | captnbli - Friday, June 21, 2013 4:52 AM | Last Reply Erland Sommarskog - Friday, June 21, 2013 12:38 PM -
Unanswered0Votes
Executing an XML template from URL using SQLXML 4.0
Hi, We have a solution built with SQLXML 3.0 which executes a template which in turn calls a stored procedure with FOR XML command to return data from an SQL database to the ...0 Replies | 39 Views | APoull - Friday, June 21, 2013 9:27 AM -
Unanswered0Votes
Generate xml using FOR XML PATH from table with hierarchy
I need to create xml from a table like: EL1 EL2 EL3 Attr01 Attr02 Attr03 Attr04 E10, , ,a,b,c,d E10,E1010, ...1 Replies | 57 Views | BigTao - Wednesday, June 19, 2013 11:57 PM | Last Reply wBob - Thursday, June 20, 2013 2:05 AM -
Answered1Votes
Generating XML from multiple rows in SQL server
I have the following table below and i would like to generate an XML from it. How do i go about doing this please. All help appreciated. Thanks ...2 Replies | 65 Views | ONeil T - Wednesday, June 19, 2013 3:58 PM | Last Reply wBob - Wednesday, June 19, 2013 10:19 PM -
Unanswered0Votes
FOR XML AUTO, ELEMENTS XSINIL, BINARY BASE64 removing some whitespace from nvarchar(max) column
Hi, Currently I create a FOR XML based select query for tables on the fly in a shared stored procedure. On tables with columns of type nvarchar, in this case ...2 Replies | 7375 Views | Nick Harris - MSFT - Friday, March 13, 2009 6:04 AM | Last Reply wBob - Wednesday, June 19, 2013 9:36 PM -
Unanswered0Votes
Unable to read from the Extended Event parser
This is not working...in SQL Server 2012 also.. Getting the below error, while reading from the Extended Events (.xel ...2 Replies | 43 Views | SM DBA - Wednesday, June 19, 2013 8:15 AM | Last Reply Russ Loski - Wednesday, June 19, 2013 4:39 PM -
Unanswered1Votes
Sql server StandardBusinessDocument xml in ApplicationResponse node query
declare @x xml set @x='<sh:StandardBusinessDocument xsi:schemaLocation="http://www.unece.org/cefact/namespaces/StandardBusinessDocumentHeader PackageProxy.xsd" ...3 Replies | 88 Views | Erhan İMREN - Tuesday, June 18, 2013 1:06 PM | Last Reply wBob - Wednesday, June 19, 2013 10:58 AM -
Answered1Votes
OPENXML question
Hi, I have the following xml file: <Root> ...6 Replies | 151 Views | ScottCabral - Friday, June 14, 2013 3:11 PM | Last Reply wBob - Tuesday, June 18, 2013 8:43 PM -
Answered0Votes
Update xml attribute from sql server 2008 r2 table based on attribute value
The following is the xml column in a table I am working with drop table T go CREATE TABLE T (i int, x xml) go INSERT INTO T ...4 Replies | 121 Views | GiveItAShot - Monday, June 17, 2013 6:14 AM | Last Reply GiveItAShot - Tuesday, June 18, 2013 10:36 AM -
Answered0Votes
How to find all values from a tag of an XML feed in a sql table
Create table #test (Key int, Feed XML) Insert into #test ...2 Replies | 108 Views | gans07 - Monday, June 17, 2013 3:35 PM | Last Reply gans07 - Tuesday, June 18, 2013 2:42 AM -
Proposed4Votes
Unable to persist language specific characters into the database column of xml datatype
I need to save language specific characters in a column of xml datatype, because XML is the format that I want it to be when I retrieve it. Just before persisting, I see the ...7 Replies | 162 Views | abhimanyu435 - Thursday, June 13, 2013 4:19 PM | Last Reply abhimanyu435 - Monday, June 17, 2013 7:42 AM -
Discussion1Votes
How to list varying list of drivers from XML Feed as columns in SQL table
I have an SQL table Create table #test t (Code int , Feed XML) Insert into #test('1','<R xmlns:xsi="http://www.w3.org" ...1 Replies | 151 Views | gans07 - Friday, June 14, 2013 8:54 PM | Last Reply Erland Sommarskog - Friday, June 14, 2013 9:34 PM -
Answered0Votes
Finding all tags of XML column from a SQL Table
Hello, I have an SQL table Create table #test (Key int, Feed XML) Insert into #test('1','<Input> ...5 Replies | 255 Views | gans07 - Thursday, May 30, 2013 3:50 AM | Last Reply gans07 - Friday, June 14, 2013 8:00 PM -
Answered0Votes
SQL to RSS Products. Which ones are available?
Does anyone know of some SQL to RSS Feed applications that you can recommend? We are currently using xSQL RSS ...3 Replies | 230 Views | JetRocket11 - Friday, June 07, 2013 4:38 PM | Last Reply Allen Li - MSFT - Friday, June 14, 2013 9:54 AM -
Answered0Votes
SQLXML Error on converting some varchar values to int with FOR XML PATH
Hi All I have a select statement in a stored procedure using FOR XML PATH It contains amongst others a select on a VARCHAR col called 'Remark' which is output as ...4 Replies | 147 Views | APoull - Wednesday, June 12, 2013 7:10 AM | Last Reply APoull - Thursday, June 13, 2013 7:14 AM -
Answered0Votes
SQL XML Format datetime conversion
I have datetime column in my table with value: 2011-12-10 00:00:00:000 I tried converting that column to create XML file as ...1 Replies | 185 Views | SQL Insane - Friday, June 07, 2013 8:00 PM | Last Reply SQL Insane - Friday, June 07, 2013 8:48 PM -
Answered0Votes
Create xml file in the following format
-- DROP TABLE #Temp CREATE TABLE #Temp (LastName VARCHAR(100), ...4 Replies | 257 Views | SQL Insane - Monday, June 03, 2013 10:56 PM | Last Reply SQL Insane - Friday, June 07, 2013 7:53 PM -
Answered1Votes
Help Need parsing XML Multiple Attributes...
Hi I have a below XML Document which I want to Parse an XML document... I need to see the Thanks Desired ...3 Replies | 212 Views | Sonic.Jessy - Thursday, June 06, 2013 5:57 PM | Last Reply Erland Sommarskog - Thursday, June 06, 2013 9:34 PM - Items 1 to 20 of 3033 Next ›
.png)
