http://sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL_Tutorial%2FSystem_Tables_Views%2Fsysdatabases
SQL Server/T-SQL Tutorial/System Tables Views/sysdatabases - История изменений
2026-04-07T06:28:12Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Tables_Views/sysdatabases&diff=6945&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://sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Tables_Views/sysdatabases&diff=6946&oldid=prev
Admin: 1 версия
2010-05-26T10:24:48Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== sysdatabases contains a row for every system and user-defined database on the SQL Server system.==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
It appears only in the master database.<br />
5><br />
6> select top 10 * from sysdatabases;<br />
7> GO<br />
name dbid sid<br />
<br />
mode status status2 crdate reserved category cmptlevel filename<br />
version<br />
-------------------------------------------------------------------------------------------------------------------------------- ------ ----------------------------------------------------------------<br />
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
-------------------------------------------------- ------ ----------- ----------- ----------------------- ----------------------- ----------- --------- ------------------------------------------------<br />
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
------------ -------<br />
master 1 0x01<br />
<br />
0 65544 1090520064 2003-04-08 09:13:36.390 1900-01-01 00:00:00.000 0 90 c:\Program Files\Microsoft SQL Server\MSSQL.1\MS<br />
SQL\DATA\master.mdf<br />
611<br />
tempdb 2 0x01<br />
<br />
0 8 1090520064 2008-08-07 20:57:36.090 1900-01-01 00:00:00.000 0 90 c:\Program Files\Microsoft SQL Server\MSSQL.1\MS<br />
SQL\DATA\tempdb.mdf<br />
611<br />
model 3 0x01<br />
<br />
0 65544 1090519040 2003-04-08 09:13:36.390 1900-01-01 00:00:00.000 0 90 c:\Program Files\Microsoft SQL Server\MSSQL.1\MS<br />
SQL\DATA\model.mdf<br />
611<br />
msdb 4 0x01<br />
<br />
0 65544 1627390976 2005-10-14 01:54:05.240 1900-01-01 00:00:00.000 0 90 c:\Program Files\Microsoft SQL Server\MSSQL.1\MS<br />
SQL\DATA\MSDBData.mdf<br />
611<br />
(4 rows affected)</source><br />
<br />
<br />
<br />
== Verifying the existence of the default database.==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
14><br />
15> CREATE PROC pr_verifydb (@dbname varchar(30))<br />
16> AS<br />
17> DECLARE @dbid int<br />
18> SELECT @dbid = dbid from sysdatabases<br />
19> where name = @dbname<br />
20> IF @@rowcount = 0<br />
21> RETURN 50<br />
22> RETURN 0 -- Everything is perfect!!!<br />
23> GO<br />
1><br />
2></source></div>
Admin