|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Thursday, May 09, 2013 12:17 AM
Points: 174,
Visits: 95
|
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Monday, December 12, 2005 4:42 AM
Points: 5,
Visits: 1
|
|
Dinesh (As a side effect to the article), thanks for making me aware of the CREATE SCHEMA AUTHORIZATION command. raj
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Thursday, March 15, 2007 9:22 AM
Points: 238,
Visits: 1
|
|
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
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Wednesday, July 16, 2003 12:00 AM
Points: 1,
Visits: 1
|
|
Pardon my ignorance but what is BOL?
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Thursday, May 09, 2013 12:17 AM
Points: 174,
Visits: 95
|
|
Hi noggin,
BOL stand for Books Online
Dinesh
MCP MCSE MCSD MCDBA
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Thursday, August 30, 2012 12:27 PM
Points: 49,
Visits: 38
|
|
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 4 Incorrect syntax near the keyword 'NULL'.
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Thursday, May 09, 2013 12:17 AM
Points: 174,
Visits: 95
|
|
Hi Currym, I have tested the script and had not found any error. Let me know the exact code you ran.
Dinesh
MCP MCSE MCSD MCDBA
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Thursday, August 30, 2012 12:27 PM
Points: 49,
Visits: 38
|
|
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.
|
|
|
|
|
SSCarpal Tunnel
       
Group: General Forum Members
Last Login: Yesterday @ 6:59 PM
Points: 4,557,
Visits: 8,215
|
|
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 datetime AS BEGIN 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.
|
|
|
|