category
Create table in pgAdmin 4 with autoincrement column
Open pgAdmin tool. Expand nodes in your database and go to the Tables node. Right click the Table node and choose Create-> ... ing the property icon.
And to watch result, right click the name of table and choose View Data->View All Rows.
It is data:
How install JDK Java 9 on Windows?
First step is downloading installation file. Go to Oracle website.In the Download tab on website click the JDK DOWNLOAD butt ... g these names set paths.
Test Java. Open Command Line window and write in it:java -version
You see information looks like it:
How use final modifier for variable in Java 9?
In this article we dive into Java 9 and final modifier . We create in Eclipse with Java 9 project:
and create two classes:
L ... anName = "Gary" ;
String m = tf.getManName();
String w = tf.getWOMAN_NAME();
System.out.println(m+' '+w);
}
}
Result:
CROSS JOIN in T-SQL in SQL Server 2012
The type of SQL joins are: cross join, inner join and outer join.
What is this cross join?
Begin with prepare two tables wit ... e. In every our three tables are three records. So for two tables 3×3 is 9, and for three tables it will be 3x3x3 = 9×3 = 27.
Using UNICODE function or NCHAR function in SQL Server 2012
The T-SQL provides UNICODE function and NCHAR function.
First function get one argument(string expression) as nchar or nvarc ...
NCHAR(261) as [NCHAR(261)] ;
Result:
You may see the same chars, that was be displayed in first and second example.
How add Tomcat 9 server to the Spring Tool Suite?
If you install Tomcat 9, you can add them to the Eclipse IDE or Spring Tool Suite IDE. Installation process I describe step ... ocalhost:8280 or similar url according to yours settings.
To stop server right click the Tomcat 9.0 node and choose Stop.
Using ASCII function or CHAR function in SQL Server 2012
The T-SQL provides ASCII function and CHAR function.
First function get one argument(string expression) as char or varchar d ...
CHAR(185) as [CHAR(185)] ;
Result:
You may see the same chars, that was be displayed in first and second example.
How display names of part date in your language?
Sometimes You display name of part of date example: name of day, name of day of week, month.
I show You how change language ... l Chinese';
SELECT DATENAME( weekday, SYSDATETIME() ) as [day in Traditional Chinese]
, DATEPART( weekday, SYSDATETIME() ) ;
Collation of database and names of tables in SQL Server 2012 in diffrent statement
This post show how work creating and inserting, selecting data from tables with the same name of table but with diffrent size ... data using T name of table:
select id from T;
So only creating table name with lower or upper letter is treat as the same.
Concatenation strings get from columns of table in SQL Server 2012
How join strings comming from columns of table as one result string?
It is several ways for it.
Begin with create database w ... b
COLLATE Polish_CS_AS;
USE mydb;
GO
SELECT CONCAT( name1, ' ' , name2) as name
FROM mydb.dbo.people ;
And it is result:
How convert numeric datatype to string by STR function?
How convert numeric datatype to string by STR function?
For convert numeric datatype to string T-SQL provides STR function.
... o is added as fifth char. Befor string is added spaces – 3 chars.
SELECT '='+STR(12.8734223344566,20,13)+'=' as stringdata ;
Substring functions: LEFT and RIGHT in SQL Server 2012
Sometimes instead of use substring function You may use LEFT or RIGHT function.
In which situation using these functions?
If ... l string will be return.
SELECT LEFT('abracadabraS',100) as mysubstring;
SELECT RIGHT('abracadabraS',100) as mysubstring;
How import data into SQLite from CSV
SQLite delivers mechanism to import data from another source. One of this source is CSV file.
For import data You launch sql ... le ) and after name of file – name of table for data.
The using SELECT query You may see your data in region table in SQLite.
Primary key and autoincrement in SQLite
How create primary key with autoincrement column in SQLite ? I describe it step by step in this topic.
Launch SQLite3.exe ap ... nt don’t be work. Belove is my test1.db database:
So if You create objects in SQLite the best is use main datatype of SQLite.
Substring function in SQL Server 2012
T-SQL provides functions which operate on strings. One of this functions is SUBSTRING. This function returns new substring, g ... dabra' as stringname,
SUBSTRING('abracadabra',0,0) as substringname ;
The function don’t returned char from string.
Create objects in SQL Server 2012 with appropriate collation
In this topic I show You how create in SQL Server object with any collation or change collation in existing object.
First ch ... llation inherit from old database collation or setted for this objects before this operation changing collation for database.
JDBC connection to SQLite in Java code in Netbeans
This topic describes how write Java code of connection to SQLite Database in Netbeans.
First step is create in Netbeans simp ... aries node in Projects window You see driver for SQLite.
If You run this application and all will be OK, the result appear:
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.
In download ... ould like to connect another time, write only name of existing database, in windows command line it will be:
sqlite3 new.db
How run Oracle VM VirtualBox with Oracle Enterprise 12c database and start work
If You would like to start your work with Oracle database my proposition is Oracle VM VirtualBox. This virtual machine contai ... appear. If You want to save Your work click the Yes button.
Click the Power Off button.
Your Oracle VM VirtualBox was closed.
How create table in pgAdmin tool for PostgreSQL 9.6?
In this topic I show how in pgAdmin create simple table.
Begin with open pgAdmin. Expand on the left Database node with your ... other column in table.
Click the Save button. You can see in your database department table with two fields: id and name.