The CASE expression is used in SELECT, UPDATE, DELETE statement
and in WHERE, IN, ORDER BY and HAVING clause.
Continue reading
The CASE expression in SELECT statement in SQL Server 2012 – part 1
Leave a reply
Using alias of column in SQL query of SQL Server 2012
The SQL query in SQL Server may have alias of column. Using this alias out of name of column in query is possible only in ORDER BY clause. In this post I show You why?
The DISTINCT clause in agregate functions in T-SQL
The DISTINCT clause is used to return only distinct (different) values.
It is use often with SELECT statement. But it is not only one using this clause. You may use it either in agregate functions.
Creating new login in SQL Server througth T-SQL script
In my last post I show You how create login in server, in this I present how do it througth T-SQL query.
Creating administrator login for SQL Server 2012
In this topic step by step I show You how create system administrator login through SQL Server Management Studio.
UNIQUE clause and NULL in SQL Server 2012
In this topic You find out how work UNIQUE constraint for column with or without NOT NULL constraint.
How install R software on Windows OS?
R is a free software for statistical computing and graphics for UNIX, Windows and MacOS. Installation R software is very simple.
The OFFSET-FETCH filter in T-SQL
The OFFSET-FETCH clause is filter using to choose sorted limited data from result set. It is similar to TOP clause, but with extra possibilities. It allow You to specify how many records want skip and how many records return.
Desktop Java 8 – part 5– How in the simple way to colour JTable component in frame?
Another topic about Java desktop application. In it You find answer how make colour table component in Java JFrame.
Desktop Java 8 – part 4 – print table from window of application
In last 2 parts of this tutorial I described how create table in Java. In this section You find out about print this table.
TOP clause in T-SQL
Using TOP in T-SQL select given number of rows. It limits the rows returned in a query result set.
Desktop Java 8 – part 3- how fit table and sort its data in JFrame ?
How fit table in frame in desktop Java application and sort data in it? I describe in this post step by step how do it.
Desktop Java 8 – part 2- simple JTable component in JFrame
The simpliest table with data and column names is very easy to implement as desktop apllication.
Desktop Java 8 – part 1- creating simple window application
This topic describes how create simple window in Java for desktop application.
The LEAD and LAG functions in SQL Server 2012
Decimal, hexadecimal and octal numbers in C++
This topic shows how declare and display variables in C++ with diffrent numerical systems.
Using ROW_NUMBER() function of Transact-SQL
ROW_NUMBER() in Transact-SQL returns sequential number of row in set of data from database, it returns bigint datatype as number.
What is faster in inserting data into database : PreparedStatement using batch or standard PreparedStatement in Java application?
What is better to use PreparedStatement with batch or without batch. I test both ways to connect by JDBC to database and get data from one table and insert into other.
How create in SQL Server empty table based on existing table filled data ?
In this topic I show You how create table of the same structure as table in your database but empty.
What is faster in getting data from database: Statement or PreparedStatement in Java application ?
What is better to use Statement or PreparedStatement. I test both objects to connect by JDBC to database and get data.
How use uniqueidentifier datatype in SQL Server ?
This post describe what is uniqueidentifier and how use it?
How check size of table in SQL Server ?
It is topic about way to check information about size of object, example table or database, and another information in SQL Server.
Default mapping datatypes from SQL Server to JDBC types and Java objects and ResultSet methods
In this post I show list of datatypes SQL Server and its equivalent datatypes in JDBC and Java objects with methods of ResultSet object.
How get size of number datatypes in Java?
JDBC connection to SQLite in Java code in Netbeans
This topic describes how write Java code of connection to SQLite Database in Netbeans.
Add connection in Netbeans to SQLite database
This topic describes how add connection to SQLite database in Netbeans.
How add SQLite JDBC driver to Netbeans?
In this topic I describe how add SQLite JDBC driver to Netbeans.
How import data into SQLite from CSV
SQLite delivers mechanism to import data from another source. One of this source is CSV file.
Primary key and autoincrement in SQLite
How create primary key with autoincrement column in SQLite ? I describe it step by step in this topic.
How generate SQL script in SQL Server Management Studio to create database from SQL Server?
In SQL Server Management Studio is opportunity to generate script with SQL query creating all objects from any database.
Export data from SQL Server to CSV file.
In this topic I describe You how export data from SQL Server to text file or CSV.
How attach or detach database in SQL Server Management Studio?
Sometime we don’t want to show database in Databases node in SQL Server Management Studio, because we needn’t to change something in it. But main reason is move database from one to another server.
How add sample AdventureWorks2012 database for SQL Server 2012?
Go the http://msftdbprodsamples.codeplex.com/ website and click on icon with SQL Server 2012 DW.
How install and create database in SQLIite?
Installation begin from download zip file. So go to website: https://www.sqlite.org/ and click Download in menu.
How to install Android Studio ?
The first step is install JDK for Java and SDK Android. In last post I describe SDK Andrid installation.
How to install SDK Android on Windows 7 ?
It is first part about creating Android applications. In this post step by step is decribe how install SDK Android.
How obtain keys and values from UIManager for Windows and Java 8?
Sometimes You need change some values in UI in Your Swing application. Where from get these messages?
Continue reading
SQL Server – GO command
GO is the command SQL Server, that inform server to send all T-SQL statements before GO to an instance SQL Server as one batch.
How get date and time parts in SQL Server 2012?
For get date and time parts in SQL Server 2012 are functions. Step by step I describe several of them.
How get current date and time from SQL Server ?
In this post I describe T-SQL functions get current date and time.
How check size of integer datatypes in C++?
How much bytes have integer datatype n C++? For diffrent platform it may be differ number.
Date and time datatypes in SQL Server 2012
SQL Server 2012 provides following date and time datatypes:
date, time, datetime, datetime2, datetimeoffset, smalldatetime.
IDENTITY – autoincrement of column in SQL Server
In SQL Server autoincrement of column You may achieve by IDENTITY. Frequently it is column with primary key.
How get information about local server in SQL Server 2012?
Sometimes we must get information about our server. How to do it? I write about it in this post.
Steps for install Enterprise SQL Server 2012
In this post I show how install Enterprise SQL Server 2012.
How define PRIMARY KEY on column in the table? – SQL Server 2012
Almost all tables in databases have column with primary key. This column often has int datatype.
How add new column to the table in SQL Server Management?
Sometimes You would like to add column after created table. But this action may be blocked.
How resolve problem with don’t copy database files from server to paste them in the another folder
Recently I meet problem with copy database files from data folder in sql server and paste them in another folder in my PC.
