November 2008 - Posts

0
Comments

FLWOR in XQuery by Kasim.Wirama

FLWOR in XQuery By : Kasim Wirama, MCDBA, MCITP Like relational query statement, XQuery in SQL Server introduces FLWOR construct. FLWOR stands for For, Let, Where, Order by, Return. You can associate SELECT query statement with Return statement. For example...
Filed under:
0
Comments

XQuery Functions by Kasim.Wirama

XQuery Functions By : Kasim Wirama, MCDBA, MCITP XQuery has built-in functions such as min, max, true, false, not, sum, substring, concat, contains, etc. They are under namespace fn:. You can prefix those functions with fn: namespace but it is not mandatory...
Filed under:
0
Comments

Type Casting in XQuery by Kasim.Wirama

Type Casting in XQuery By : Kasim Wirama, MCDBA, MCITP XQuery has several data types. As a result of variety of data types in XQuery, a type of XML operands could be converted from a type to another type. For example an integer value in XML could be converted...
Filed under:
0
Comments

Relational to XML transformation with XQuery by Kasim.Wirama

Relational to XML transformation with XQuery By : Kasim Wirama, MCDBA, MCITP XQuery could not only do XML manipulation from XML data but also it can convert relational (traditional column) to XML result. 2 XQuery functions implements the purpose, i.e...
Filed under:
0
Comments

Conditional Expression in SQL Server XQuery by Kasim.Wirama

Conditional Expression in SQL Server XQuery By : Kasim Wirama, MCDBA, MCITP XQuery has conditional construction like any other programming languages (C#, VB, etc). Let’s read through remaining of this article and see how XQuery conditional expression...
Filed under:
2
Comments

Node Comparison in SQL Server XQuery by Kasim.Wirama

Node Comparison in SQL Server XQuery By : Kasim Wirama, MCDBA, MCITP I am interesting with various capability of SQL Server XQuery. This article is applicable to SQL Server 2005 onwards. I would like to show you various operations regarding to node comparison...
Filed under:
2
Comments

Is Database Administrator Required? by Kasim.Wirama

Is Database Administrator Required? What Makes a DBA is Really DBA Indeed? By : Kasim Wirama, MCDBA, MCITP In hubbub on .NET technology such as ASP.NET, silverlight, WCF, WWF, WPF, etc, still they interact with database if type of application is data...
Filed under:
1
Comments

I am MCITP for SQL Server 2008 Now by Kasim.Wirama

I am MCITP for SQL Server 2008 Now by : Kasim Wirama, MCDBA, MCITP DB Admin 2008, MCITP BI Dev 2008 If you notice several articles I posted recently, I put my title MCTS because I haven't take exam for MCITP for Database Admin. This afternoon, I pass...
Filed under:
0
Comments

XQuery Date and Time Implementation by Kasim.Wirama

XQuery Date and Time Implementation By : Kasim Wirama, MCDBA, MCTS, MCITP XQuery regarding to date and time format has specific requirement. It applies to xs:date, xs:time and xs:dateTime. It uses standard defined by ISO 8061. The format will be input...
Filed under:
1
Comments

XQuery Comparison by Kasim.Wirama

XQuery Comparison By : Kasim Wirama, MCDBA, MCTS, MCITP Let’s examine how XQuery differentiates comparison behaviour from SQL Server 2005. There are 2 types of comparion, i.e.: value comparison operator and general comparison operator. Value comparison...
Filed under:
1
Comments

Comments in SQL Server XQuery by Kasim.Wirama

Comments in SQL Server XQuery By : Kasim Wirama, MCDBA, MCTS, MCITP I would like to go further anything about XQuery implementation in SQL Server 2005/2008. This topic is about put comments in XQuery. Remember that everything inside string parameter in...
Filed under:
Copyright © INDC, 2006. All rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems