CLR support for SQL Server 2005

Next >>

Overview of integration of CLR with SQL Server.

User-defined types and aggregates are written as entire classes. The developer compiles the code and creates an assembly..................
Read answer

Advantages of CLR integration.

Some of the benefits of using CLR procedures are:..................
Read answer

Next >>

XSLT in SQL Server 2005

Overview of XSLT and the components that make up an XSLT style sheet.
What is XSLCompiledTransform class of the .NET Framework?
What is XSLTSetting class of the .NET Framework?...........

What is XSL?

Answer - XSL is a language for expressing style sheets. An XSL style sheet is a file that describes the way to display an XML document...............

What is XML Namespace?

Answer - An XSL sheet or a document may have duplicate elements and attributes. Therefore, the XML namespaces define a way to distinguish between..............

How do you load data from XML file to a ORACLE table?

Answer - You need to first create a table in oracle that matches with the fields of the XML data...............

What are XML indexes and secondary XML indexes?

Answer - The primary XML index is a B+tree and is useful because the optimizer creates a plan for the entire query. ..............