<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="ru">
		<id>http://sqle.ru/index.php?action=history&amp;feed=atom&amp;title=SQL_Server%2FT-SQL_Tutorial%2FSystem_Settings%2FOBJECTPROPERTY</id>
		<title>SQL Server/T-SQL Tutorial/System Settings/OBJECTPROPERTY - История изменений</title>
		<link rel="self" type="application/atom+xml" href="http://sqle.ru/index.php?action=history&amp;feed=atom&amp;title=SQL_Server%2FT-SQL_Tutorial%2FSystem_Settings%2FOBJECTPROPERTY"/>
		<link rel="alternate" type="text/html" href="http://sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Settings/OBJECTPROPERTY&amp;action=history"/>
		<updated>2026-04-06T16:42:10Z</updated>
		<subtitle>История изменений этой страницы в вики</subtitle>
		<generator>MediaWiki 1.30.0</generator>

	<entry>
		<id>http://sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Settings/OBJECTPROPERTY&amp;diff=6600&amp;oldid=prev</id>
		<title> в 13:46, 26 мая 2010</title>
		<link rel="alternate" type="text/html" href="http://sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Settings/OBJECTPROPERTY&amp;diff=6600&amp;oldid=prev"/>
				<updated>2010-05-26T13:46:16Z</updated>
		
		<summary type="html">&lt;p&gt;&lt;/p&gt;
&lt;table class=&quot;diff diff-contentalign-left&quot; data-mw=&quot;interface&quot;&gt;
				&lt;tr style=&quot;vertical-align: top;&quot; lang=&quot;ru&quot;&gt;
				&lt;td colspan=&quot;1&quot; style=&quot;background-color: white; color:black; text-align: center;&quot;&gt;← Предыдущая&lt;/td&gt;
				&lt;td colspan=&quot;1&quot; style=&quot;background-color: white; color:black; text-align: center;&quot;&gt;Версия 13:46, 26 мая 2010&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; style=&quot;text-align: center;&quot; lang=&quot;ru&quot;&gt;&lt;div class=&quot;mw-diff-empty&quot;&gt;(нет различий)&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;</summary>
			</entry>

	<entry>
		<id>http://sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Settings/OBJECTPROPERTY&amp;diff=6601&amp;oldid=prev</id>
		<title>Admin: 1 версия</title>
		<link rel="alternate" type="text/html" href="http://sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Settings/OBJECTPROPERTY&amp;diff=6601&amp;oldid=prev"/>
				<updated>2010-05-26T10:23:48Z</updated>
		
		<summary type="html">&lt;p&gt;1 версия&lt;/p&gt;
&lt;p&gt;&lt;b&gt;Новая страница&lt;/b&gt;&lt;/p&gt;&lt;div&gt;== Check with OBJECTPROPERTY function==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- start source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
    &amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
5&amp;gt;    CREATE FUNCTION dbo.AveragePrice()&lt;br /&gt;
6&amp;gt;    RETURNS money&lt;br /&gt;
7&amp;gt;    WITH SCHEMABINDING&lt;br /&gt;
8&amp;gt;    AS&lt;br /&gt;
9&amp;gt;    BEGIN&lt;br /&gt;
10&amp;gt;       RETURN (SELECT AVG(Price) FROM dbo.Titles)&lt;br /&gt;
11&amp;gt;    END&lt;br /&gt;
12&amp;gt; GO&lt;br /&gt;
1&amp;gt;&lt;br /&gt;
2&amp;gt;    SELECT OBJECTPROPERTY(OBJECT_ID(&amp;quot;AveragePrice&amp;quot;), &amp;quot;IsDeterministic&amp;quot;)&lt;br /&gt;
3&amp;gt; GO&lt;br /&gt;
-----------&lt;br /&gt;
          1&lt;br /&gt;
(1 rows affected)&lt;br /&gt;
1&amp;gt;&lt;br /&gt;
2&amp;gt; drop FUNCTION dbo.AveragePrice;&lt;br /&gt;
3&amp;gt; GO&amp;lt;/source&amp;gt;&lt;br /&gt;
    &lt;br /&gt;
   &lt;br /&gt;
&lt;br /&gt;
== Returning Information about User-Defined Functions==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- start source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
    &amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
Syntax for the OBJECTPROPERTY() Function&lt;br /&gt;
OBJECTPROPERTY ( &amp;lt;object_id&amp;gt; , &amp;lt;property&amp;gt; )&lt;br /&gt;
IsScalarFunction&lt;br /&gt;
IsInlineFunction&lt;br /&gt;
IsTableFunction&lt;br /&gt;
IsDeterministic&lt;br /&gt;
IsSchemaBound&lt;br /&gt;
SELECT&lt;br /&gt;
  OBJECTPROPERTY(OBJECT_ID(&amp;quot;dbo.fibonacci&amp;quot;), &amp;quot;IsScalarFunction&amp;quot;)&amp;lt;/source&amp;gt;&lt;br /&gt;
    &lt;br /&gt;
   &lt;br /&gt;
&lt;br /&gt;
== Use OBJECTPROPERTY and OBJECT_ID to check the table existance==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- start source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
    &amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
5&amp;gt; USE master&lt;br /&gt;
6&amp;gt; SELECT OBJECTPROPERTY(OBJECT_ID(&amp;quot;syslockinfo&amp;quot;), &amp;quot;TableIsFake&amp;quot;),&lt;br /&gt;
7&amp;gt;     OBJECTPROPERTY(OBJECT_ID(&amp;quot;sysobjects&amp;quot;), &amp;quot;TableIsFake&amp;quot;)&lt;br /&gt;
8&amp;gt; GO&lt;br /&gt;
Changed database context to &amp;quot;master&amp;quot;.&lt;br /&gt;
----------- -----------&lt;br /&gt;
       NULL        NULL&lt;br /&gt;
(1 rows affected)&lt;br /&gt;
1&amp;gt;&amp;lt;/source&amp;gt;&lt;br /&gt;
    &lt;br /&gt;
   &lt;br /&gt;
&lt;br /&gt;
== Using the OBJECTPROPERTY Function to Check Whether a View is Indexable==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- start source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
    &amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
SELECT OBJECTPROPERTY(OBJECT_ID(&amp;quot;view_name&amp;quot;), &amp;quot;IsIndexable&amp;quot;)&amp;lt;/source&amp;gt;&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	</feed>