category
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.
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.
How install Zend Framework 1.12.3 in Xampp server 1.8.3?
In my last post I write about xampp installation. Here You try install Zend Framework 1.12.3. So go to http://framework.zend ... ibrary; C:\xampp\php\Zend1\bin;
Click OK in all open windows.
In another posts I configure and test xampp and Zend Framework.
How install DBDesigner on Windows OS?
Go to http://fabforce.eu/dbdesigner4/ download open source tool for modelling and design databases. Download DBDesigner4.0. ... n to start installation process.
Click the Finish button to end this process.
It is how lokks like the icon this application:
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;
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.
Maven Project in Netbeans 8 with JPA 2, Hibernate 5 and PostgreSQL 9.6 database
This work begin with connect PostgreSQL database in Netbeans. I show how it do in How set connection to PostgreSQL 9.6 datab ... result in data view in database.
Right click the department table and choose View Data.
It is all record in department table.