Databases
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.
How add driver and connect to Firebird server in Netbeans 8
First download jdbc driver for firebird database. Got to http://www.firebirdsql.org/en/jdbc-driver/ website and click on Jay ... select Disconnect if you don’t work on this database.
On the list of connection icon of firebird connection will be broken.
Select data from Firebird by means of JSTL in Netbeans 8
In last post I describe how create website in JSTL. In this post we select data from database and display them into table.
O ... name of table and column for yours.
Check if you have connected to the database in Services window.
Run your application.
How add SQL Server 2012 driver to Netbeans 8?
Go to Services window in Netbeans. List Drivers node. If on the list it isn’t SQL JDBC driver you must download it.
Go to h ... on. In Name field write Microsoft SQL Server 2012 and click the OK button.
On the list of drivers you see SQL Server driver.
How install on windows PostgreSQL 9.6 with pgAdmin tool?
Below you can follow step by step installation process of PostgreSQL with pgAdmin tool.
First you go to the https://www.post ... like to create new dataabse.
In Database field write name of database. The diagram below show you nodes this new database.
Add connection in Netbeans 8 to the SQL Server 2012 database.
If you have added driver for SQL Server 2012, You may set connection to test database. So go to Services window and right cl ... y public and sysadmin:
In User Mapping tab for test database it is choose only db_owner and public role.
It is Status tab:
How install SQL Server 2012 Express with Advanced Services on Windows 7?
I write step by step how install on Windows 7 Sql server 2012 Express. I download SQLEXPRADV_x86_ENU.exe file for my 32 bit ... In next window you may close it.
In Start->All programms in Windows 7 You see tree of your SQL Server 2012 installation.
How create database and switch database in SQL Shell of PostgreSQL 9.6?
In last post I show how install and create first database of PostgreSQL in pgAdmin. In this section I show how connect to Pos ... can write command:\c or \connect with name of new database. Look at screen below.
Click the Enter.
You are in new database.
How set connection to PostgreSQL 9.6 database in Netbeans 8?
In Services tab right click the PostgreSQL node and choose Connect Using.
You see New Connection Wizard.
Change name of data ... shed.
Expand this node.
You see tables in mydb database.
To close connection, right click on this node and choose Disconnect.
Configuration SQL Server 2012 for Netbeans
SQL Server 2012 has SQL Server Configuration Manager tool. Choose from OS Start-> All programms->Microsoft SQL Server ... d choose Properties(Właściwości).
In Protocol tab you must set Default Port as 1433 and Enabled as Yes.
Click the OK button.
Partial view in Netbeans 7.4 application project in Zend 1.12
In this post I describe how create application project using partial view. Partial view is view to which link several anot ... l animals selected from animal table from database.
And if You click on second link, You see groups with list of its animals.
Database application in Zend Framework 1.12.3 in Netbeans 7.4 get data from several relational tables.
Let’s beginn Your work from create database magazine. In it create 3 tables: article,news, author.Author table contains colu ... ton.Choose Zend PHP Web Framework from list of frameworks and click on Finish button.You see Zend project in tree structure.