What is Xquery?
secondary XML indexes?
What is FOR XML
in SQL Server?
What is the
OPENXML statement in SQL Server?
How to call
stored procedure using HTTP SOAP?
What is XMLA?
SQL Server XML integration - March 10, 2009 at 22:00
PM by Rajmeet Ghai
What is Xquery?
Xquery is used to query XML data. This may be either a database or a file. It
used xpath expressions that can be used to extract elements and attributes from
What are XML indexes?
XML indexes are created on XML data type columns. Having XML indexes will reduce
cost with respect to maintenance and data modification. Use of XML indexes
avoids the need to parse the complete data at runtime thereby increasing query
What are secondary XML indexes?
XML indexes can either be primary or secondary. When the XML type column has its
first index, it is called as a primary index. Using this primary index,
secondary indexes like PATH, VALUE and PROPERTY are supported. Depending on the
nature of queries, they help in query optimization.
Path secondary index if used speeds up queries if the query specifies a path.
Path secondary index if used speeds up queries are value based.
Path secondary index if used speeds up queries if the query retrieves one or
more values from individual XML instances.
What is FOR XML in SQL Server?
FOR XML allows data to be retrieved in an XML format. The FOR XML clause needs
to be mentioned at the end of SELECT statement. There are three modes of FOR
RAW mode: - An XML element is formed for each row in the query
AUTO mode: - The query results are returned as nested XML
Explicit mode: - the format of the XML document returned by the
query can be completely controlled by the query.
What is the OPENXML statement in SQL Server?
OPENXML is a row set provider, in which a row set view over an XML documented is
provided. It is used to parse the complex XML function.
OPENXML(idoc int [in],rowpattern nvarchar[in],[flags byte[in]]) [WITH
(SchemaDeclaration | TableName)]
Idoc is the document handle of an XML document which is created by calling
Xpath is the pattern used to identify the nodes.
Flag is for mapping between the XML data and the relational rowset
WITH clause is used to provide a rowset format.
How to call stored procedure using HTTP SOAP?
Stored procedures can be called using HTTP SOAP by creating endpoints. A SOAP
endpoint is identified by a URL. Each endpoint supports a protocol, either HTTP
Syntax for Endpoint:
CREATE ENDPOINT name_of_end_point
STATE = STARTED
PATH = specifies path of the service
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = name of the host computer
WEBMETHOD – name of the web method
to be used.
BATCHES = DISABLED,
WSDL = DEFAULT,
DATABASE = name of the database
NAMESPACE = specifies a name space
for end point.
What is XMLA?
XML for Analysis facilitates communication of client applications with OLAP data
sources. Communication is done via XML, HTTP, or SOAP. XMLA open standards
support data access to data sources on the WWW.
Answer - The Bulk Copy is a command utility that transfer SQL
data to or from a data file.
This utility mostly used to transfer huge data to SQL server from other
Answer - Distributed Query is a query which can retrieve data
from multiple data sources including distributed data........
Answer - Temporary Stored Procedure is stored in TempDB
database. It is volatile and is deleted once connection gets terminated or
server is restarted......
Answer - The column or columns of the table whose value
uniquely identifies each row in the table is called primary key. You can define
column as primary key using primary key constraint while you create table.....
Answer - Index can be thought as index of the book that is used
for fast retrieval of information. Index uses one or more column index keys and
pointers to the record to locate record.........