category
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:
Sorted data in tables in SQL Server using COLLATE clause
The COLLATE is a clause apply to the database, column or string expression, set collation for data.
The COLLATE clause inher ... RDER BY name COLLATE Polish_CI_AI
BIN :
SELECT[id],[name]
FROM [BazaTest].[dbo].[person]
ORDER BY name COLLATE Polish_BIN
Create database model in DBDesigner
After install DBDesigner( I describe this process in my last post) You may run this application.
You see window as below:Clo ... lation and choose from menu Edit Object.
You see Relation Editor window.
In Relation Editor change data.
Click the OK button.
UNIQUE clause and NULL in SQL Server 2012
In this topic You find out how work UNIQUE constraint for column with or without NOT NULL constraint.
Begin with creating i ... one NULL value. If You would like to constraints this field for NOT NULL, You may add NOT NULL to column with UNIQUE clause.
The CASE expression in SELECT statement in SQL Server 2012
The CASE expression is used in SELECT, UPDATE, DELETE statement
and in WHERE, IN, ORDER BY and HAVING clause.
The CASE expres ... ]
WHERE [Title] is NOT NULL
AND [LastName] LIKE 'Va%';
The next post will be about use CASE expression in other statements.
The LEAD and LAG functions in SQL Server 2012
The LEAD function provides value from the next row in result of query.
The LAG function provides value from the previous row ... BY p.name ORDER BY s.value) as prev,
p.name, s.year, s.value
FROM person p
JOIN salary s on s.id_person_fk = p.id ;
TOP clause in T-SQL
Using TOP in T-SQL select given number of rows. It limits the rows returned in a query result set.
Let begin with TOP clause ... be use only in SELECT statement and with ORDER BY clause. The TOP is used in SELECT, INSERT, UPDATE, DELETE, MERGE statement.
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:
Installation, configuration and testing Java 7
Java is my favorite language. Why? Because it is universal, objective, multithreaded, portable programming language, which w ... n
You see information looks like it:
On www.oracle.com website in Documentation tab You find either documentation for Java.
UNIQUE clause and NULL in SQL Server 2012
In this topic You find out how work UNIQUE constraint for column with or without NOT NULL constraint.
Begin with creating i ... one NULL value. If You would like to constraints this field for NOT NULL, You may add NOT NULL to column with UNIQUE clause.
The simple way to install LESS preprocessor through node.js and compile LESS file to CSS file
Lately I started my adventure with LESS. It is first post about the LESS for you. If you don’t know what is the LESS, I expla ... again LESS compiler.
The style.css was changed. Look at its content.
After run HTML file you see website like that below.
Installation and configuration EGit in Eclipse or Spring Tool Suite
How to install GIT I describe in my post “How install GIT on Windows 7?”.
After installation of GIT, on my computer files ar ... write name and in Value value for it.
In the same way add email with value.
Click the Apply and Close button to save settigs.
In Zend Framework 1.12 Application error: No adapter found for Application Model DbTable
I met last time situation in that I run my application with error: No adapter found for Application_Model_DbTable. What’s wr ... tion.ini file and paste it before [staging : production] section:
Running application You see list of animals from database.
Configuration and testing Xampp and Zend Framework
First You test xampp server. Open Xampp Control Panel.
Click Start button places on the right from Apache label. The same Y ... end very well: Apache is working, PHP is working and MySQL have root user with password, Zend Framework is working, too.
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:
Simple JSTL application in Netbeans 8
Let’s start create new project in Netbeans IDE. Choose from menu File->New Project.
In New Project window select on the l ... .jsp file:
JSTL
JSTL page
Then you may run your application.
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.
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.
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.
First project in JSF in Netbeans
In Netbeans you may create in simple way your Java Server Faces project.
First create project. Choose form menu File->New ... displays by browser:
If you find out to write simple JavaServer Faces application in Netbeans IDE is very simple and easy.