Pretty close, almost...

SQL_Kills (8/5/2014)

---

1. If you look at the attachment , it is showing blank because when you deploy a ssis package to the server it will stored this to a file...

Quick thought (no...

Not much I would suggest here apart from the missing separator in the concatenation and a covering index. Otherwise this would be pretty much my first and probably only approach....

SQL_Kills (8/5/2014)

---

Hi,

So say I have a table called "TableA" and have two database one called "Hub" and the other Database called "Adventure". I then want to call a stored...

Don't think there is any reason to re-invent the wheel, it's more a matter of rephrasing the question so we can understand what you are after. There are quite few...

Guess one has to differentiate between five years of work and five years worth of experience. Questions like "what are the DAC limitations", "consequence of an idle connection holding a...

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

...