Need help on ‘predefined functions/subroutins’

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Need help on ‘predefined functions/subroutins’

Author

Topic

ky2009
Starting Member

3 Posts

Posted - 2009-03-19 : 15:56:59

I am new to the sql server environment.
I need help to locate source code of a SQL code .

I am looking at the following sql statements and have questions:
1- Are these ‘dbo.Get***95th’ statements predefined function/subroutine ?

2- Are these predefined function/subroutine source codes stored somewhere on the sql server. Where can I find these predefined function/subroutine source codes ?

3- I would like to find out the tables these ‘predefined function/subroutine accessed and the ‘where’ clause of these sql statements.

dbo.GetInBps95th(AA.InterfaceID, @StartDate, @EndDate) AS Maxbps_In95
dbo.GetOutBps95th(AA.InterfaceID, @StartDate, @EndDate) AS Maxbps_Out95
dbo.GetMaxBps95th(AA.InterfaceID, @StartDate, @EndDate) AS Maxbps_95

Thank you .

----------- Original sql starts -------------

DECLARE @StartDate DateTime
DECLARE @EndDate DateTime

SET @StartDate = CAST (DATEDIFF(d, 0, DATEADD(d, 1 - day(getdate()), getdate()))as datetime)
SET @EndDate = GetDate()

SELECT Interfaces.InterfaceId,
Nodes.Caption AS NodeName,
Nodes.VendorIcon AS Vendor_Icon,
Interfaces.Caption AS Interface_Caption,
Interfaces.InterfaceIcon AS Interface_Icon,
Maxbps_In95,
Maxbps_Out95,
Maxbps_95
FROM Nodes
INNER JOIN Interfaces
ON (Nodes.NodeID = Interfaces.NodeID)
---------------------
INNER JOIN
(
SELECT InterfaceID, dbo.GetInBps95th(AA.InterfaceID, @StartDate, @EndDate) AS Maxbps_In95
FROM (
SELECT DISTINCT A.InterfaceID
FROM dbo.InterfaceTraffic A
WHERE A.DateTime >= @StartDate AND A.DateTime <= @EndDate
) AS AA
) as RESULT_IN
ON (Interfaces.InterfaceID = RESULT_IN.InterfaceID)
---------------------
INNER JOIN
(
SELECT InterfaceID, dbo.GetOutBps95th(AA.InterfaceID, @StartDate, @EndDate) AS Maxbps_Out95
FROM (
SELECT DISTINCT A.InterfaceID
FROM dbo.InterfaceTraffic A
WHERE A.DateTime >= @StartDate AND A.DateTime <= @EndDate
) AS AA
) as RESULT_OUT
ON (Interfaces.InterfaceID = RESULT_OUT.InterfaceID)
---------------------
INNER JOIN
(
SELECT InterfaceID, dbo.GetMaxBps95th(AA.InterfaceID, @StartDate, @EndDate) AS Maxbps_95
FROM (
SELECT DISTINCT A.InterfaceID
FROM dbo.InterfaceTraffic A
WHERE A.DateTime >= @StartDate AND A.DateTime <= @EndDate
) AS AA
) as RESULT_MAX
ON (Interfaces.InterfaceID = RESULT_MAX.InterfaceID)
---------------------
ORDER BY NodeName, Interface_Caption

----------- sql ends -------------

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-03-19 : 16:36:47

One way is to:
From Management Studio use the Object Explorer to navigate to the server/database where these reside.
Then navigate into Programmability | Functions | Scalar-valued Functions

F8 toggles object explorer. You may need to "register" your server in the "Registered Servers" tab (Menu | View | Registered Servers)

Be One with the Optimizer
TG