It can be used directly by an application to query an XML document, as part of a larger operation such as applying an XSLT transformation to an XML document, or applying an XQuery to an XML document. In XPath injection, we ...
Scooped on:
XQuery & T-Sql
XQuery & T-Sql
new zorba xquery live demo http://t.co/BhRzx5i1 
This allows you to obtain aggregation information for individual rows in a result. Unfortunately, this does not work in MySQL, but it does work in both Oracle and T-SQL (transact SQL, which is what MS SQL Server uses). 
CONVERT CAST dates in T-SQL. Sometimes you need to compare dates as text rather than in date format, and this can be especially useful when comparing dates from different systems using different data types. 
One of my early blog posts highlighted how to get the first day of the current month. Well, another common task is get to the last day of a month and i'm (reasonably) pleased to see that SQL Server 2012 has an inbuilt function ... 
Last week, I submitted an entry for T-SQL challenge 8. This time, the contestants were asked to process a hierarchy using recursive CTEs without applying any filters inside the CTE. The big challen... 
New User-defined Server Roles in SQL Server 2012Database JournalSQL Server 2012 brings a couple of new security enhancements, one of which is to create a user defined server role.
Further to my post SQL Server: Querying XML fields – XPath, XQuery, I'd like to expand on this and cover updating XML fields too. Unfortunately it appears you can only do one update at at a time, so often looping is required, ... 
Most programmers think the XQuery language was developed to satisfy a niche market: A data querying and transformation language designed to handle XML data. 
PTI has created a series of 1 hour SQL Server 2012 Firestarter webcasts designed to give you a sneak peek at all the exciting changes, updates and toolkits that Microsoft will be offering in this new edition. 
Getting Started with Open XML Development. The first in a series of screen-casts for developers getting started in development with Open XML for the first time. In this video, I look at the Open XML standard from a high level. 
In this part three of this article series, Itzik Ben-Gan discusses how to write T-SQL windows functions in SQL Server 2012 'Denali'. 
Strate SQL - Questions, answers, opinions and scripts from a SQL Server DBA (@kekline That's xpath/xquery. 
More often than not, there is a myth in the developer community that Microsoft SQL Server does not provide the debugging abilities that other IDEs provide. Even SQL Server 2000 provided basic debugging ability. |
It will a lengthy and complex coding if we need to perform insert, update and delete statement individually. Instead of write separate statements for the insert, update and delete operation, we have one more option which can be very helpful in t... Loops in xQuery. There are multiple ways to loop through data in xQuery. The most famous in xQuery is the FLOWR expression. This provides readability and stability when it comes to document order. 
In today's SQL in Sixty Seconds Rick Morelan has presented very visual reach concept of SQL Server. We all have idea how SQL Server reacts when it encounters T-SQL Error. Today Rick explains the same in quick seconds. 
SQL Server 2012 (“Denali”): T-SQL Enhancements. SQL Server 2012 has a number of new T-SQL features. Listed below are all of the new features, along with the best links I have found that describe each feature: WITH RESULT SETS ... 
I didn't have quite the level of participation for T-SQL Tuesday #027 that I would have liked. I understand it was a holiday, and many people might have been otherwise occupied (a good thing), and there's less work for my ... 
Listing Directory Contents using T-SQL. In many cases during the development of a sophisticated SQL Server Agent job, you might need to access the file system. For example you might want to list the contents of a specific ...
T-SQL Tuesday #27 is hosted by Steve Jones (blog|twitter). This month's topic is “Big Data”. Purge Problems in Big Data – Not only a. 
DBPedias.com is a free interactive resource that uses real-world insight to help visitors make sense of all the information available on databases.
T-SQL: INSERT with XML shredding is very slow. Back in 2010, I came across a performance bug with SQL2008 SP1. When shredding XML using the nodes query, the performance is fine with a SELECT but when you want to ... XML World-Countries XPath and XQuery Exercises. XQuery. Question 1. Return the area of Mongolia. for $c in doc("countries.xml")/countries/country. where $c/@name = "Mongolia". return $c/data(@area). Question 2 ... 
Background in developing OLTP/document based databases, SQLXML and performance tuning with an unhealthy fascination for the SQL query optimiser! ... 
SQL SERVER – Finding Count of Logical CPU using T-SQL Script – Identify Virtual Processors. February 4, 2012 by pinaldave. I recently received email from one of my very close friend from California. His question was very interesting. |
| Previous |
|
1 | 2 | 3 |
|
Next |
