http://www.sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL_Tutorial%2FSystem_Settings%2Fxp_msver
SQL Server/T-SQL Tutorial/System Settings/xp msver - История изменений
2026-05-24T01:30:59Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Settings/xp_msver&diff=6598&oldid=prev
в 13:46, 26 мая 2010
2010-05-26T13:46:16Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:46, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://www.sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Settings/xp_msver&diff=6599&oldid=prev
Admin: 1 версия
2010-05-26T10:23:48Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== EXEC master..xp_msver==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
2> EXEC master..xp_msver<br />
3> GO<br />
Index Name Internal_Value Character_Value<br />
------ -------------------------------- -------------- ------------------------------------------------------------------------------------------------------------------------<br />
1 ProductName NULL Microsoft SQL Server<br />
2 ProductVersion 589824 9.00.1399.06<br />
3 Language 1033 English (United States)<br />
4 Platform NULL NT INTEL X86<br />
5 Comments NULL NT INTEL X86<br />
6 CompanyName NULL Microsoft Corporation<br />
7 FileDescription NULL SQL Server Windows NT<br />
8 FileVersion NULL 2005.090.1399.00<br />
9 InternalName NULL SQLSERVR<br />
10 LegalCopyright NULL c Microsoft Corp. All rights reserved.<br />
11 LegalTrademarks NULL Microsoftr is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft Corporation<br />
12 OriginalFilename NULL SQLSERVR.EXE<br />
13 PrivateBuild NULL NULL<br />
14 SpecialBuild 91684864 NULL<br />
15 WindowsVersion 170393861 5.1 (2600)<br />
16 ProcessorCount 1 1<br />
17 ProcessorActiveMask 1 00000001<br />
18 ProcessorType 586 PROCESSOR_INTEL_PENTIUM<br />
19 PhysicalMemory 1023 1023 (1073201152)<br />
20 Product ID NULL NULL<br />
(20 rows affected)</source><br />
<br />
<br />
<br />
== xp_msver function==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
4> CREATE TABLE #VersionTable(<br />
5> [Index] int PRIMARY KEY,<br />
6> Name varchar(30),<br />
7> Internal_Value int,<br />
8> Character_Value varchar(250)<br />
9> )<br />
10> GO<br />
1><br />
2> INSERT INTO #VersionTable<br />
3> EXEC master..xp_msver<br />
4><br />
5> DECLARE @Version int<br />
6><br />
7> SELECT @Version = (SELECT Internal_Value<br />
8> FROM #VersionTable<br />
9> WHERE Name = "ProductVersion")<br />
10> IF (@Version) >= 524288<br />
11> PRINT "Running SS2K Beta 2 or Later"<br />
12> ELSE<br />
13> IF @Version >= 458752<br />
14> PRINT "Running 7.0 RTM or Later"<br />
15> ELSE<br />
16> PRINT "Running Pre 7.0 RTM Version"<br />
17> GO<br />
(20 rows affected)<br />
(20 rows affected)<br />
Running SS2K Beta 2 or Later<br />
1> DROP TABLE #VersionTable<br />
2> GO</source></div>
Admin