Hany Helmy (3/11/2015)

---

raulggonzalez (3/10/2015)

---

Sean Lange (3/10/2015)

---

I knew about fn_dblog but answered that you can't do it without third party because the question was asking for "whodunnit" which to the best...

raulggonzalez (3/10/2015)

---

Sean Lange (3/10/2015)

---

I knew about fn_dblog but answered that you can't do it without third party because the question was asking for "whodunnit" which to the best of my...

jeffgrammer (3/10/2015)

---

I was looking for help creating a flashing text box and found this forum post.

I accomplished it this way

on the fill color property I used this:

=iif(Second(Now) Mod 2,...

steve000 (3/10/2015)

---

After reading some on the syntax and use, I came up with the following.

CREATE TRIGGER dbo.trig_OccupiedSuites

ON [dbo].[MyTable]

AFTER UPDATE

AS

BEGIN

-- Your SQL goes...

I knew about fn_dblog but answered that you can't do it without third party because the question was asking for "whodunnit" which to the best of my knowledge you can't...

shalaran (3/9/2015)

---

Hi,

I'm working on a tsql query to return a column with the summed time units for each week. However, I'm only getting a summed total at Week6, and am...

You also should not litter your database with the NOLOCK hint. It seems to be on every one of your tables here. Are you with missing and/or duplicate data?

Here is...

It isn't hypothetical. It is a known issue when doing updates and/or deletes using the NOLOCK hint.

http://www.mssqltips.com/sqlservertip/3172/avoid-using-nolock-on-sql-server-update-and-delete-statements/%5B/url%5D

There dozens of other references...

JeeTee (3/9/2015)

---

No. I'm fully aware of all the implications of NOLOCK and the possibility of dirty...

steve000 (3/9/2015)

---

Thanks Sean,

That is where I am stumped - i have never created a trigger before. Might you be able to share a sample with the proper syntax? I wills...

It is...

Is there a reason not to calculate these values when you need them? It is best to avoid storing calculated values in the database. It is difficult to always be...

I agree with Phil. Honestly it somewhat seems like sql is the wrong place for what you are trying to do. This sounds like the kind of thing that belongs...

Not quite sure what you are trying to do here. Are you saying when somebody updates a given row you want to update a certain column from that row using...

BOR15K (3/9/2015)

---

Apologies if it is a silly question, Oracle allows Java to be integrated. Is it possible to integrate C# code with MSSQL?

Using STGeomFromText function, I would assume it...