forked from tSQLt-org/tSQLt
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathtSQLt.Info.sfn.sql
More file actions
27 lines (27 loc) · 814 Bytes
/
Copy pathtSQLt.Info.sfn.sql
File metadata and controls
27 lines (27 loc) · 814 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
IF OBJECT_ID('tSQLt.Info') IS NOT NULL DROP FUNCTION tSQLt.Info;
-- This will not work if executed outside of the build!
GO
---Build+
GO
CREATE FUNCTION tSQLt.Info()
RETURNS TABLE
AS
RETURN
SELECT Version = '$LATEST-BUILD-NUMBER$',
ClrVersion = (SELECT tSQLt.Private::Info()),
ClrSigningKey = (SELECT tSQLt.Private::SigningKey()),
V.SqlVersion,
V.SqlBuild,
V.SqlEdition
FROM
(
SELECT CAST(PSSV.Major+'.'+PSSV.Minor AS NUMERIC(10,2)) AS SqlVersion,
CAST(PSSV.Build+'.'+PSSV.Revision AS NUMERIC(10,2)) AS SqlBuild,
PSV.Edition AS SqlEdition
FROM tSQLt.Private_SqlVersion() AS PSV
CROSS APPLY tSQLt.Private_SplitSqlVersion(PSV.ProductVersion) AS PSSV
)V;
GO
---Build-
GO
SELECT * FROM tSQLt.Info() AS I;