Slightly different flavour of the same

😎

DECLARE @TXML XML = '<?xml version="1.0" encoding="utf-8"?>

<DataSet xmlns="http://tempuri.org/">

<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">

<xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">

<xs:complexType>

<xs:choice minOccurs="0" maxOccurs="unbounded">

<xs:element name="Table">

<xs:complexType>

<xs:sequence>

<xs:element name="KeyID" type="xs:string" minOccurs="0" />

<xs:element name="LicenseAcquisitionUrl" type="xs:string" minOccurs="0"...

Guess he merits a Master...

Thanks Gregory for this nice peace, good job!

Missed seeing one essential thing though in the injection part and that is a strong coupling to the metadata. If a user can...

Yes, unless it is wrapped in an explicit transaction.

😎

From a slightly humours point of view, often there is quite a resemblance to Chinese Whispers in Data Collection, Processing and Analysis processes, which in turn makes one at least...

You can use a variable if you have an expression for the relevant property in the connection manager.

😎

mallikachowdhary 98955 (7/24/2014)

---

Hi ,

I have a issue regarding a query showing very late response on one server while it works perfectly on another.

I have a job defined in SQL server...

dkriplani97 (7/24/2014)

---

create table #tmpcopylibrary

(

dataid int,

value int

)

insert #tmpcopylibrary select 1,999

UPDATE TableA

SET Value = isnull((select top 1 Value from...

Slightly puzzled how you got those procedure to work, are you certain that you posted the right code? Quickly looking at the first procedure:

1. Typo, flaot should be FLOAT, this...

shah_khan_1289 (7/23/2014)

---

Hello,

i have created a stored procedure with dynamic query and using sp_executesql . stored procedure is work fine.

now i want to call stored procedure in select statement...

ScottPletcher (7/23/2014)

---

If you're willing to push back against the myth that identity should be default clustering key, and base the clustering key(s) choice on data instead, you can change the...

You promise?

😎

pmscorca (7/23/2014)

---

Ok. I repeat the last time my question.

I haven't SQL Server 2012 media.

I need to prepare a SQL Server 2012 installation having SQL Server 2014 installation.

It is possible to...

N_Muller (7/23/2014)

---

Thanks everyone for the replies.

In regards to the XML storage as VARCHAR(MAX), we can receive XML that does not go through XSD validation and may not even be a...

pmscorca (7/23/2014)

---

I don't use the Retail channel to buy SQL Server.

I repeat that I know that SQL Server 2014 has rights to downgrade.

Simply, I want to know how technically I...