Tags » XQuery

Generate XML from Data Tables

I was tasked with creating an API which would allow the user to call the API passing in the name of a database table and receiving an xml representation of the data in return.  647 more words

SQL Server

ExcelTable 1.6 : support for cell comments

Here’s the new version of ExcelTable, which can now extract cell comments as regular columns.
Not much change in the user interface, except an extended column syntax specification to declare a request for cell metadata instead of its value : … 714 more words

SQL

Openxml vs Xquery Performance

Openxml vs xquery whose performance is better? It really depends on what are you trying to do.

Background

There are some occasions I need to parse and save content from xml into database. 505 more words

Performance

Java Developer

Location : krakow

  • First and foremost contribute to the development of our products and guide the future evolution of our systems
  • Apply best development practices…
  • 147 more words
Poland Jobs

She Wore FLWORs In Her Hair...

Okay, okay…that was a bad, bad pun.  As the parent of a teenage son, I view it as my Sacred Duty to toss out “groaners” to keep people on their toes. 716 more words

XQuery: Where do I begin?

You’ve  been working with SQL-based databases for years and years, and all of a sudden you are a captive audience on the NoSQL bandwagon.  Instead of tables and rows, you are now looking at XML documents (not to be confused with Word, Excel, bla bla documents). 711 more words

SQL Server - Extended Event - Metadata - Get Current Target File

Background

For some optimization work that we are doing, I will like to know the name of the Extended Events’ Engine currently targeted file.

Code… 109 more words

Microsoft