在SQL Server 2008中反思？ [英] Reflection in SQL Server 2008?

问题描述

我想知道，SQL Server 2008中是否有任何反射支持，就像c＃支持反射一样。基本上，我对SQL Server如何实现我们所有的（whereby，orderby，存在）子句感到好奇。它如何在后台实现所有这些功能。

I want to know, is there any reflection support in SQL Server 2008, like as c# support reflection. Basically I am curious about how SQL Server implements all our (where, orderby, exists) clauses. How it would implement all these in behind the scenes.

推荐答案

不久前，如果您将SQLServer与大多数面向对象的语言进行比较，那您一定会为之震惊。事实上，SQLServer揭示了更多有关其内部工作原理的信息。

It's not that long ago when if you compared SQLServer to most object-oriented languages, that you would have been struck by the fact that SQLServer reveals a lot more about its inner workings than they do.

SQL和事务数据库的概念固有的是，有关它们如何运行的许多信息工作存储在数据库本身中。例如，所有表都由系统数据库中表中的行表示，所有列，存储过程等也是如此。

Its inherent to the concept of SQL and transactional databases, that a lot of the information about how they work is stored in the database itself. All tables are, for example, represented by rows in a table in a system database, as are all columns, stored procedures, and so on.

如今，SQLServer在这方面没有达到C＃的水平，并且您可能会得出相反的结论。

These days however, SQLServer does not go as far as C# in this regard, and you may be struck by the opposite conclusion.

在您浏览时可能会产生一个类比如果您反映了课堂上的信息，您将在民主主义者的观念中触及原子，这是无法进一步分解的。要么由核心IL指令处理，要么在外部定义，无论哪种方式，您都可以深入到实施中。与.NET相比，SQLServer具有更多的功能，您无法窥视它们的工作原理。

An analogy could be drawn to the way that when you are browsing through reflected information on classes, you will hit "atoms" in the Democritian sense of something that can't be broken down any further. Either it'll be handled by the core IL instructions, or it'll be defined externally, and either way you can see any more "into" the implementation. SQLServer has more features that you can't peer into to see how they work than .NET

您可能会喜欢PostgreSQL，它在功能上更进一步可见它的许多功能。

You might enjoy taking a look at PostgreSQL, which goes a bit further in how visible many of its functions are.

这篇关于在SQL Server 2008中反思？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！