They should be identical.  The datadd... part is used to strip the part time of the date.  However in this case it seems to be useless.  But I also assume...

This is one good way.  However there's a faster way if you have only 1 text information per row. 

CREATE FUNCTION dbo.fnStripHtmlTags (@Text AS VARCHAR(8000))

RETURNS VARCHAR(8000)

AS

BEGIN

 DECLARE @Return AS VARCHAR(8000)

 DECLARE @StartPos...

I want full audit, old row version / who / when / where (application and station) / what (sql statement).

I would most likely split the duplicate information to it's own table...

Books online would be your best friend at the moment.  The Inserted and Deleted tables are accessible only within triggers.  They contain the information on the data that has been...

Please do not cross-post, we monitor all boards.

Finish this thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=330820

Consider this thread closed.

What's the cost of using this code on all tables all the time for a very low transaction environement?

Average of about 2-3 transactions/second over an 8 hours period.  I'm looking to...

I'm sure it's possible but I need to know exactly what you need to help you.  Can you provide some sample data and the required output from that function so...

I was searching for a nice way to put it... and it was just that .

Yup that's the one.  Thanx for the research .

Can't be sure without the code, but I'm guessing that you are not updating a flag column, nor are you keeping the last record inserted.  Both which would allow you...

Is it faster than the original version?

It means that you have orphaned data in the child table.  Use a left join to find which rows they are.  Then you'll have to decide wether you want to...

After some testing it appears that the ascii version is constantly better, by almost 10%. Anyone wanted a proof that comparing strings is longer than comparing numbers ?!?!

I think my version could even be faster by switching the ascii() between 48 and 57 to substring between '0' AND '9'

For once in my life I think I found a better solution than Franks >> and I'm a little surprised that you didn't think about it yourself :