tag:blogger.com,1999:blog-7805972021499203804.post4286990816795134161..comments2023-10-30T06:24:14.411-07:00Comments on ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview: SQL Server Convert Table Data to XML Format using XML PATH, XML AUTO or XML RAWSuresh Dasarihttp://www.blogger.com/profile/01337689983379917267noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-7805972021499203804.post-70589203568961378592014-11-05T17:45:30.022-08:002014-11-05T17:45:30.022-08:00The SQL syntax is specific for SQL server right?The SQL syntax is specific for SQL server right?johnhttp://www.aspdotnet-suresh.com/2014/10/how-to-make-simple-usb-desktop-locker-in-c-sharp.htmlnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-14550946266819774922014-11-02T05:23:27.772-08:002014-11-02T05:23:27.772-08:00This comment has been removed by a blog administrator.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-20056371365622380942014-10-29T06:27:24.997-07:002014-10-29T06:27:24.997-07:00This comment has been removed by a blog administrator.Anonymoushttps://www.blogger.com/profile/07782484480116292216noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-9624877306641471232014-10-20T22:38:57.717-07:002014-10-20T22:38:57.717-07:00Not getting complete data from the table. only get...Not getting complete data from the table. only getting mentioned numbers.<br /><br />select len((<br /> SELECT * FROM [tblDocument] FOR XML PATH('Document'), ROOT('Documents')<br /> )) --1018504<br /> <br /> select len((<br /> select * from [tblDocument] FOR XML RAW('Document'), ROOT('Documents')<br /> )) --802396<br /> <br /> select len((<br /> select * Anonymoushttps://www.blogger.com/profile/09140337468665190677noreply@blogger.com