doraprojects.net

In this post You will be continue your adventure with CASE expression in SQL Server 2012. The CASE expression in ORDER BY cla ... Va%' ORDER BY CASE Title WHEN 'Ms.' THEN FirstName END, CASE WHEN Title!='Ms.' THEN LastName END DESC

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:

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

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 ;

It is two situation in SQL Server 2012 when You may or don’t use alias of column in ORDER BY  clause . First example  presen ... HEN FirstName ELSE LastName END So in CASE expression even using in ORDER BY clause, You may not use alias of column.

In this post You will be continue your adventure with CASE expression in SQL Server 2012. The CASE expression in ORDER BY cla ... Va%' ORDER BY CASE Title WHEN 'Ms.' THEN FirstName END, CASE WHEN Title!='Ms.' THEN LastName END DESC

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.  

First step is downloading installation file. Go to Oracle website.In the Download tab on website click the JDK DOWNLOAD butt ... g these names set paths. Test Java. Open Command Line window and write in it:java -version You see information looks like it:

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.  

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.  

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 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.

In this article we dive into Java 9 and final modifier . We create in Eclipse with Java 9 project: and create two classes: L ... anName = "Gary" ; String m = tf.getManName(); String w = tf.getWOMAN_NAME(); System.out.println(m+' '+w); } } Result:

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

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.

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.

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.

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.  

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: