Fungsi row_number() adalah untuk mengembalikan sequential number untuk setiap record. Contoh penggunaan row_number() untuk keperluan paging data : Terdapat sebuah table CustTable yang menampung data customer yang terdiri dari 2 field yaitu, CustID dan CustName. Dan kasus yang akan di tampilkan adalah...

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: to return content of Specifications element...

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. Let’s see by example those functions below...

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 to double data type. There are 2 data type...

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. sql:column and sql:variable. I use table Person.Person...

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 couldn’t be compared to programming languages. Conditional...

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 by XQuery. XML itself contains hierarchical...

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 related application. Though it is not related to front...

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 exam for my MCITP in Database Administrator for...

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 parameter for XQuery conversion (xs:date, xs:time...