|
XML Processing Instructions and CDATA Sections
By:
CI-tech1
Processing Instructions
Processing instructions (PIs) are an escape hatch to provide information to an application. Like comments, they are not textually part of the XML document, but the XML processor is required to pass them to an application.
Processing instructions have the form: <?name pidata?>...
XML Elements, Attributes, Entity References and Comments
By:
CI-tech1
Elements
Elements are the most common form of markup. Delimited by angle brackets, most elements identify the nature of the content they surround. Some elements may be empty, as seen above, in which case they have no content. If an element is not empty, it begins with a start-tag, <element>, and ends with an end-tag, </element>...
What Do XML Documents Look Like?
By:
CI-tech1
you are conversant with SGML or HTML, XML documents will look familiar. Here is a simple XML document:
<?XML version="1.0"?>
<oldjoke>
<burns>Say <quote>goodnight</quote>, Gracie.</burns>
<allen><quote>Goodnight, Gracie...
How Is XML Defined?
By:
CI-tech1
XML is defined by four specifications:
XML, the Extensible Markup Language
Defines the syntax of XML. The XML specification is the primary focus of this article.
XLL, the Extensible Linking Language
Defines a standard way to represent links between resources...
XML Development Goals
By:
CI-tech1
The XML specification sets out the following goals for XML:
It shall be straightforward to use XML over the Internet.
Users must be able to view XML documents as quickly and easily as HTML documents. In practice, this will only be possible when XML browsers are as robust and widely available as HTML browsers, but the principle remains...
Why XML?
By:
CI-tech1
This section does not appear in the Journal version.
In order to appreciate XML, it is important to understand why it was created. XML was created so that richly structured documents could be used over the web. The only viable alternatives, HTML and SGML, are not practical for this purpose...
So XML Is Just Like SGML?
By:
CI-tech1
No. Well, yes, sort of. XML is defined as an application profile of SGML. SGML is the Standard Generalized Markup Language defined by ISO 8879. SGML has been the standard, vendor-independent way to maintain repositories of structured documentation for more than a decade, but it is not well suited to serving documents over the web (for a number of technical reasons beyond the scope of this article)...
So XML is Just Like HTML?
By:
CI-tech1
No. In HTML, both the tag semantics and the tag set are fixed. An <h1> is always a first level heading and the tag <ati.product.code> is meaningless. The W3C, in conjunction with browser vendors and the WWW community, is constantly working to extend the definition of HTML to allow new tags to keep pace with changing technology and to bring variations in presentation (stylesheets) to the Web...
What is XML?
By:
CI-tech1
This section does not appear in the Journal version.
XML is a markup language for structured documentation.
Structured documents are documents that contain both content (words, pictures, etc.) and some indication of what role that content plays (for example, content in a section heading has a different meaning from content in a footnote, which means something different than content in a figure caption, etc...
Display Number of Working days month wise
By:
chandu
SQL SERVER Display Number of Working days month wise query.
DECLARE @NoOfDays int, @startDate datetime, @endDate datetime, @d1 datetime
SET @NoOfDays = 0
set @startDate = dateadd(m, -1 * (datepart(m, dateadd(d, -1 * (datepart(d, getdate())-1), getdate()))-1), dateadd(d, -1 * (datepart(d, getdate())-1), getdate()))
set @endDate = dateadd(d, -1 * (datepart(d, dateadd(m, (12 - datepart(m, getdate())), getdate()))-1), dateadd(m, (12 - datepart(m, getdate())), getdate()))
while @startDate <= @endDate
begin
set @d1 = @startDate
SET @NoOfDays = 0
while month(@startDate) = month(@d1)
begin
if(SUBSTRING(DATENAME(dw,@d1),1, 3) <> 'sun')
set @NoOfDays = @NoOfDays + 1
set @d1 = DATEADD(dd,1,@d1)
end
SELECT @startDate 'Month', @NoOfDays NumberOfWorkingDays
set @startDate = DATEADD(mm,1,@startDate)
end
|