Databases
How install Reporting Services for SQL Server 2017 Developer edition?
If you would like to install Reporting Services, first you have to install SQL Server. I have installation of SQL Server 20 ... server button. It allow you configure Reporting Services.
I describe how configure Reporting Services in the next my post.
Tutorial Data Modeling in SQL Power Architect – part. 1 Installation of software
For creating logical or phisical data models is used special software. One is SQL Power Architect, delivered also as Communit ... are:
Run file architect, and you will see Welcome window, you can close it:
For users prefer video, watch it on YouTube:
Oracle XE 11g
If you have already installed Oracle XE, the good way to connect to a database will be SQL Developer tool. In this article I ... abase.
If you would like to disconnect this connection, you do it through context menu selecting Disconnect item from menu.
Create the Data Source in the Report Builder
Let’s start to run Report Builder in Start on Windows OS.
You see Report Builder window. Close Getting Started window,
Rig ... Connection Result window and then in main window.
On the left side in the Report Builder window you see your Data Source.
How install Report Builder 3 for Reporting Services?
In this article I will explain you how install Report Builder 3 for Reporting Services.
First step is download installation ... r 2017?
Click the Next button.
Click the Install button.
After installation process, you see Report Builder window as below.
How work with Oracle Express XE 11g after installation on Windows
The last topic disscus how install Oracle XE 11g. Today I expalin you how work with it. After installation, you have on the ... for Java, for instance: C:\Program Files\Java\jdk1.8.0_102
After first run SQL Developer:
The application is ready to work.
SQL*Plus for Oracle
SQL*Plus may display data from tables of database in default language set in system OS. So sometimes you can see in your lang ... E8PC858
861
IS8PC861
862
IW8PC1507
865
N8PC865
866
RU8PC866
You fin all information about it on Oracle website.
Maven Project in Netbeans 8 with JPA 2.1, Hibernate 5 and SQL Server 2012 database
This work begin with connect SQL Server 2012 database in Netbeans. I show how it do in Add connection in Netbeans 8 to the S ... Tables node in database:
After run application:If you view data set, you see data in table which you insert into main class:
Use SQL*Plus tool to connect to a database in Oracle 11g XE
It is not news that the SQL Developer tool is a visual, graphical tool to connect to a database in Oracle. About SQL Develope ... abase.Documentation about SQL*Plus you find under this link:https://docs.oracle.com/cd/B14117_01/server.101/b12170/qstart.htm
Insert data into the existing table of PostgreSQL 9 with Hibernate 5, JPA in Maven Project in Netbeans 8
You have table people created in mydb in PostgreSQL(id as serial and primary key and name columns). We create it in post:Cre ... = GenerationType.IDENTITY)
private Long id;
private String name;
...
And run application and get data from database:
How install Oracle Express(XE) 11g on Windows 64-bit?
The first step is go to website:
Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
And down ... process installation start.
Click the Finish button.
On the Desktop you see this icon:
In the Start->Programs you see:
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.
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:
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.
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 ;