Technology Questions

SQL Server is having a fantastic feature to retrieve data persisted in the form of XML format. The data in the XML format can be retrieved using FOR XML clause appending to the SELECT statement.

It offers 3 modes.

- “FOR XML AUTO": Returns XML elements that are nested, based on which tables are listed in the "from" part of the query, and which fields are listed in the "select" part.

- "FOR XML RAW": Returns XML elements with the "row" prefix (ex: ""). Each column in a table is represented as an attribute and null column values aren't included.

- "FOR XML EXPLICIT": Explicit mode is the most complex shaping method used in SQL Server 2000. It allows users to query a data source in such a way that the names and values of the returned XML are specified before the query batch is executed. 

FIND_GROUP(function) FIND_COLUMN(function)

var checkedP = window.document.getElementById("myCheckBox").checked;

Some of the new features provided in HTML5 are:

- It provides support for local storage

- New form controls, like calendar, date, time, email, url, search

- <canvas> element is provided to facilitate 2D drawing

- The <video> and <audio> elements are provided for media playback

- New content-specific elements are provided. For e.g. <article>, <header>, <footer>, <nav>, <section>

By using method.

The method used to set the data is called setter method.

- Name based is the virtual hosting that allows the virtual hosts to serve multiple hostnames that runs on single machine and having only one IP address.

- This is used when the web browser is used to request the resource from the server then the server respond using the hostname. 

- Web server uses HTTP protocol to respond to the requested hostname as the part of the request. 

- The server contains all the information of the website and the user that requests for the resources given. 

- Name based web hosting includes the resources and services that need to be given at the time of client’s request.

These are the new form elements introduced in HTML 5:

Color

Date

Datetime-local

Email

Time

Url

Range

Telephone

Number

Search

Structure and table both are 2/2 matrices but there are many differences between table and structure.

1. Table can store the data physically but a structure dose not store.
2. Table can have primary key but a structure dose not have.
3. Table can have the technical attribute but a structure dose not have.

structure doesn't contain technical attributes.
structure doesn't contain primary key.
structure doesn't stores underline database level.