Currently browsing category

SQL Server

SQL Pivoting using Case Statement

Using Aggregated CASE Statement I previously illustrated how to using PIVOT table in SQL Server. Today we will cover how to accomplish …

SQL Server Pivot Table Example

What is a Pivot Table? A pivot table can aggregate and rotate data from rows to columns. You can also sort, count …

Java DBC

JDBC Tutorials

The JDBC API defines a set of interfaces and classes that all major database providers adhere to in order allow Java developers …

Java DBC

JDBC Statement – Batch Example

A JDBC statement object is used to send SQL command(s) to your relational database management system (RDBMS). It is associated with an …