SQLServerCentral / Discuss Content Posted by Dinesh Priyankara / Article Discussions / Article Discussions by Author / UDF as Computed Column Part 2 / Latest Posts

RE: UDF as Computed Column Part 2

Sergiy — Wed, 14 Jul 2004 16:28:00 GMT

Sorry, Dinesh, you've got so many titles... Just like number of operands in your script.

But what about performance of your scripts? It's good while it has only 4 rows to work out.

What if you replace your function with this one?

CREATE FUNCTION dbo.fn_getDuration (@STime datetime, @ETime datetime)RETURNS datetimeASBEGIN DECLARE @Duration Datetime

SET @Duration = @ETime-@STime RETURN @Duration - floor(convert(real, @Duration))

END

First, it's more precise: it counts not only hours and minutes, but seconds and milliseconds as well. So, it's more usefull;Second, it works times faster;And third, it returns datetime value, so you can use it in criteria check for select from big table: WHERE dbo.fn_getDuration (..) > '05:00:00'

Best regards,Sergiy.

RE: UDF as Computed Column Part 2

currym — Wed, 23 Jul 2003 03:16:00 GMT

Hmmmm... It was with the first script "Create Schema Authorization" but the entire exercise worked fine this morning. The fn_getDuration function is nice little headbanger. Thanks for your assistance.

RE: UDF as Computed Column Part 2

Dinesh Priyankara — Tue, 22 Jul 2003 04:38:00 GMT

Hi Currym,I have tested the script and had not found any error. Let me know the exact code you ran.DineshMCP MCSE MCSD MCDBA

RE: UDF as Computed Column Part 2

currym — Tue, 22 Jul 2003 01:52:00 GMT

Thanks for your work. I must have screwed something up but when I ran the 'Create Schema' script I received the following error:Server: Msg 156, Level 15, State 1, Line 4Incorrect syntax near the keyword 'NULL'.

RE: UDF as Computed Column Part 2

Dinesh Priyankara — Tue, 15 Jul 2003 21:41:00 GMT

Hi noggin,BOL stand for Books OnlineDineshMCP MCSE MCSD MCDBA

RE: UDF as Computed Column Part 2

noggin — Tue, 15 Jul 2003 14:03:00 GMT

Pardon my ignorance but what is BOL?

RE: UDF as Computed Column Part 2

bozo7 — Mon, 14 Jul 2003 08:29:00 GMT

I also was unaware of the CREATE SCHEMA AUTHORIZATION command thanks for taking a minute to explain it. It will truly come in handy in the future.Thanks for articles. I have been planning more UDFs since reading your first article and this second one confirms the path I was thinking down.Thanks,Ross

RE: UDF as Computed Column Part 2

rajenshah — Mon, 14 Jul 2003 02:30:00 GMT

Dinesh(As a side effect to the article), thanks for making me aware of the CREATE SCHEMA AUTHORIZATION command.raj

UDF as Computed Column Part 2

Dinesh Priyankara — Sat, 28 Jun 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dPriyankara/udfascomputedcolumnpart2.asp