doraprojects.net

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.

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.  

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.

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() ) ;

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.

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? 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 ;

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;

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.

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.

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.

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.

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:

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 fit table  in frame in desktop Java application and sort data in it? I describe in this post step by step how do it. In ... ter clicked the Name column second time:You may either owing to call this method, drag and drop columns changing its places:

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.

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.  

First You must downloading driver of SQL Server ( sqljdbc4.jar ). Copy it into lib directory in GlassFish instalation place. ... item SQLServer2012 and click Ping button. If it’s all right you see information about success: Restart GlassFish server.    

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.

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.