Read And write xml data in xml column in sqlserver

Suppose I have an entry


assetsIDs_xml  '119'

update Designs set assetsIDs_xml = ''
where ( assetsIDs_xml.exist('/root/id[text()=119]') =1 ) 


SELECT
           Columnlist
      FROM
            tableName c
      WHERE
            AND ((c.userIDs_xml.exist('/root/id[text()=sql:variable("@userID")]') = 1)  

Comments

Post a Comment

Popular posts from this blog

Difference between asynchronous (AJAX) and synchronous request? Now-a-days, this is a very common question that been asked in all most every basic interview – What is the main strength of AJAX? Or why and when should we use AJAX in web application? And the most common answer is – “AJAX does not refresh or reload the whole page”. But, the more perfect answer is – “AJAX is an asynchronous technology where others request are synchronous.” So, what is the difference? In a word, a program does not wait for response after requesting an asynchronous call whereas synchronous does so. Here is a simple example – function check() { var a=0; a = getStatus(“getstatus.php?id=5”); if(a==1) { alert(“active”); } else { alert(“not active”); } } Here getStatus() function sends a AJAX request to the server with “getstatus.php?id=5” url and the php file decides (from database may be) the status and output/response as 1 or 0. But, this function wi...
Read more

IIS not work, Give error "HRESULT...." or When IIS start gives error "Already running a process on this port"

Hello All, In my pc, IIS was working fine as I know. Today when I want to run my site from IIS. It gives me above error . I am searching lot for my this issue. Even I was did stop my firewall , still getting the same. So I googling and get solution that skype is also share the same port of IIS : 80. So follow below to solve this issue. The cmd NETSTAT -ano showed Skype (via the PID) was using port 80. This was preventing IIS starting a local website with the message: The process cannot access the file because it is being used by another process. (Exception from HRESULT: 0x80070020) This was resolved in Skype by unchecking T ools > Options... > Advanced > Connection > "Use port 80 and 443 as alternatives for incoming connections" Refer link :Prevent Skype using port 80 and causing IIS to throw a HRESULT: 0x80070020 Exception
Read more
 Today is the auspicious day for me as I buying a new home from almost last year. And now the dream come true. Today DD of home loan 27lk will be generated from SBI(Parasbhai) and probably in next month we will get the possession.  House address as G-1003, Ashray-10, Nr. Khodiyar temple, New Ranip, Ahmedabad - 382480 My first step I taken on last year on 24-Oct-2019 via Sureshbhai , Hasmukhlal Patel and Amit Mandal In janurary, expeced that we will get the house, so I aggree and taken the sanction letter from SBI. But the time was gone and in mid the Corona virus comes in March 22 2020 and lock down start. Wife and children were at Bikaner and coming on 1st April 2020 and they fuss gaye.
Read more