pwalter83 (1/29/2013)

---

Thanks Sean,

I have come to a point where I need to add the sql code within this:

---------------------------------------

Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click

End Sub

---------------------------------------

The SQL code...

SteveEClarke (1/29/2013)

---

Sean Lange (1/28/2013)

---

SteveEClarke (1/28/2013)

---

I have managed to answer my own question - through a little digging -

Using the DELETED table as the before data.

New Trigger;

ALTER TRIGGER [dbo].[trgGenMasterUpdate]

...

Why are you using task manager to close SSMS "very often"?

Please don't cross post. Direct all replies to the original thread here. http://www.sqlservercentral.com/Forums/Topic1412675-1550-1.aspx

SteveEClarke (1/28/2013)

---

I have managed to answer my own question - through a little digging -

Using the DELETED table as the before data.

New Trigger;

ALTER TRIGGER [dbo].[trgGenMasterUpdate]

ON...

???

Anybody else is going to ask you for the same thing. There is no need for a...

How about some ddl and sample data? Read the first link in my signature.

L' Eomot Inversé (1/28/2013)

---

Sean Lange (1/28/2013)

---

Lowell (1/28/2013)

---

in our case, we have a config file that has the connection string information, and a single row table that contains a lot of...

The sample you posted won't work because there is no DocId specified on the inserts into Doc.

I need to understand the relationship between these two tables. The way you have...

mail4bbt (1/28/2013)

---

Ok, Thanks, I new here and to sql.

I am trying to make Title in table 1 a computed column that will get updated every time the title column in...

This works on your example provided.

declare @String varchar(50) = 'Mon Jan 28 11:03:06 EST 2013'

select cast(left(right(@String, len(@String) - 4), 16) + right(@String, 4) as DateTime)

Depending on how things like single...

Are you trying to take a string and turn it into...

mail4bbt (1/28/2013)

---

How to create a computed column based on the Title nvarchar(max) column of another field: I want to make Title in table 1 a computed column from table2 based...

As in you figured out your query or you understood my suggestion?

Lowell (1/28/2013)

---

in our case, we have a config file that has the connection string information, and a single row table that contains a lot of settings relevant to the application...