[font="Verdana"]You can also persist the calculated column, in which case it will only be calculated the once. Bits are good choices for persistance, since they take up soooo much...

[font="Verdana"]Hi Laura,

Can you explain why you need to do it with a trigger? Is this just a thing to try so you can learn how to write triggers?

If not,...

[font="Verdana"]Have you tried this?

In the report properties, set the language to "=User!Language". That will change the display format for dates to what the user expects. I'm not exactly...

[font="Verdana"]This isn't the recommended way of returning values from procedures. Try using an output parameter. The return value is really meant to be used for error status numbers.[/font]

[font="Verdana"]Dammit, all these years I have been missing out...

Replacing SQL Server Massages

😀

[/font]

[font="Verdana"]Thanks Matt.

That rings a bell. As you said, in SQL Server 2000, there was no try/catch. You could sort of handle errors by checking @@error after every statement.

The...

[font="Verdana"]Sam,

I have two recommendations. The first is to go onto the Oracle forums (start at http://www.oracle.com) and ask the same question there.

The second is to browse books...

[font="Verdana"]None that I have seen, but it wouldn't surprise me if they are out there.

Briefly, here's the approach I...

Lowell (2/8/2009)

---

[...]triggers can help capture changes that do not go through your n-tiered app, like ad hoc updates, or direct calls to stored proc. Both audits have their place, depending...

[font="Verdana"]I think it takes less disc space too. Takes less time to install? :w00t:[/font]

[font="Verdana"]Yeah. One of the features I miss (see earlier...

[font="Verdana"]Agreed. Done it, in fact. A design that requires tricky work-arounds isn't my preferred...

[font="Verdana"]Is there a question there? Or are you just wanting validation that it's a good approach to take?[/font]

[font="Verdana"]"Access is an application in Windows so it sometimes uses Windows permission but it cannot be compared to SQL Server which is less than Oracle."

Okay, I will bite. How...

[font="Verdana"]Oh, I love this question!

On your first look, triggers seem like the way to go. They can be used to guarantee that whenever you make a change to the...