Quick thought, look in to this sp_describe_first_result_set, does as it says on the tin.

😎

Ed Wagner (8/5/2014)

---

Jeff Moden (8/5/2014)

---

Eirikur Eiriksson (8/4/2014)

---

Jeff Moden (8/4/2014)

---

Eirikur Eiriksson (8/4/2014)

---

Koen Verbeeck (8/4/2014)

---

I am afraid I have...

Recommend that you use the nodes() method

😎

DECLARE @XmlDocument XML = N'<Attributes><Attribute name="ABCD">50405</Attribute></Attributes>';

SELECT

ATTRIB.DATA.value('@name','VARCHAR(10)') AS name

,ATTRIB.DATA.value('.[1]','INT') ...

Eirikur Eiriksson (8/4/2014)

---

mike 57299 (8/4/2014)

---

I get the following error with the code from Ten Centeries:

Msg 515, Level 16, State 2, Line 1

Cannot insert the value NULL into column 'scancode', table...

Jeff Moden (8/4/2014)

---

Eirikur Eiriksson (8/4/2014)

---

I'm...

mike 57299 (8/4/2014)

---

I get the following error with the code from Ten Centeries:

Msg 515, Level 16, State 2, Line 1

Cannot insert the value NULL into column 'scancode', table 'Solovue_Homart.dbo.scancode'; column...

First place to look are the values of the strings being cast into date.

😎

Here is a modification of the trigger which allows for multi-row inserts and uses the CONVERT function.

😎

CREATE TRIGGER dbo.scancode_scancode_autogen

ON SCANCODE

AFTER Insert

...

Quick thought, check the parameters, columns and the values data types as this is a datatype conversion error.

😎

The main difference would be some components like fuzzy matching and grouping are Enterprise only, everything else...

I'm relying on the ESP...

suresh0534 (8/4/2014)

---

Hi,

Below is the Exception:

System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'INFORMATION_SCHEMA.Columns'.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

...

mike 57299 (8/4/2014)

---

Hi all...

I am trying to generate a hex value automatically at time of insert. The column used for the hex # is an identity column. ...

SQLRNNR (8/3/2014)

---

Eirikur Eiriksson (8/3/2014)

---

Jeff Moden (8/3/2014)

---

TomThomson (8/3/2014)

---

Jeff Moden (8/2/2014)

---

Heh......

Jeff Moden (8/2/2014)

---

Thanks Eirikur. I've never looked at it but figured it might be so. That...