|
|
|
|
|
|
-
Jacob Sebastian Posted 2 Months ago through Presentations
How many of you have explored SQL Server 2012?<br/>What did you like most?<br/>...
|
|
|
-
Jacob Sebastian Commented 2 Months ago through Blogs
See [this books online page][1] which clarifies this.
It says:
In SQL Server, the page size is 8 KB. This means SQL Server databases have 128 pages per megabyte. Each page begins with a 96-byte header that is used to store system information abou...
|
-
Jacob Sebastian Commented 2 Months ago through Ask
Yes, solving challenges adds points to your profile....
|
-
Jacob Sebastian Commented 2 Months ago through Ask
I could not find anything detailed/advanced. To start with, the [XQuery white paper][1] may help. I once wrote a series of short tutorials called [XQuery Labs][2] and posted [here][3]. They are more like 'getting-started' kind of stuff. If you are speci...
|
-
Jacob Sebastian Commented 2 Months ago through Ask
The problem is with the expression `@Code="AAA" and @Deleted="false"` which causes a data type mismatch. You can fix this by applying a cast as follows:
UPDATE @XmlTest
SET MyContent.modify('
replace value of (/Root/MyNode[
@Code cast as xs...
|
-
Jacob Sebastian Commented 2 Months ago through Ask
At first glance, I do not see a problem with this XML. What exactly are you trying to do with this XML?...
|
-
Jacob Sebastian Commented 2 Months ago through Just Learned
I think synonyms should be used responsibly. I have seen excessive use of synonyms which resulted in hard-to-debug code in some environments....
|