/****** Object:  StoredProcedure [dbo].[xp_msver]    Script Date: 18.03.2023 16:44:35 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

create   procedure [dbo].[xp_msver]
as
begin

declare @t table ([Index] int primary key, Name nvarchar(200), Internal_Value bigint null, Character_Value nvarchar(200))

insert into @t([Index],Name,Internal_Value,Character_value) values (1,'ProductName',null,'Microsoft SQL Server')
insert into @t([Index],Name,Internal_Value,Character_value) values (2,'ProductVersion',1048576,'16.0.4003.1')
insert into @t([Index],Name,Internal_Value,Character_value) values (3,'Language',NULL,'English')
insert into @t([Index],Name,Internal_Value,Character_value) values (4,'Platform',null,'NT x64')
insert into @t([Index],Name,Internal_Value,Character_value) values (5,'Comments',null,'SQL')
insert into @t([Index],Name,Internal_Value,Character_value) values (6,'CompanyName',null,'Microsoft Corporation')
insert into @t([Index],Name,Internal_Value,Character_value) values (7,'FileDescription',null,'SQL Server Windows NT - 64 Bit')
insert into @t([Index],Name,Internal_Value,Character_value) values (8,'FileVersion',null,'2022.0160.4003.01 ((sql2022_rtm_qfe-cu1).230128-0022)')
insert into @t([Index],Name,Internal_Value,Character_value) values (9,'InternalName',null,'SQLSERVR')
insert into @t([Index],Name,Internal_Value,Character_value) values (10,'LegalCopyright',null,'Microsoft. All rights reserved.')
insert into @t([Index],Name,Internal_Value,Character_value) values (11,'LegalTrademarks',null,'Microsoft SQL Server is a registered trademark of Microsoft Corporation.')
insert into @t([Index],Name,Internal_Value,Character_value) values (12,'OriginalFilename',null,'SQLSERVR.EXE')
insert into @t([Index],Name,Internal_Value,Character_value) values (13,'PrivateBuild',null,'')
insert into @t([Index],Name,Internal_Value,Character_value) values (14,'SpecialBuild',262340609,'')
insert into @t([Index],Name,Internal_Value,Character_value) values (15,'WindowsVersion',262340609,'6.2 (9200)')
insert into @t([Index],Name,Internal_Value,Character_value) values (16,'ProcessorCount',8,'8')
insert into @t([Index],Name,Internal_Value,Character_value) values (17,'ProcessorActiveMask',null,'              ff')
insert into @t([Index],Name,Internal_Value,Character_value) values (18,'ProcessorType',8664,'')
insert into @t([Index],Name,Internal_Value,Character_value) values (19,'PhysicalMemory',16310,'16310 (17102405632)')
insert into @t([Index],Name,Internal_Value,Character_value) values (20,'Product ID',null,'')

select * from @t
order by [Index]

end
GO