Tag: guide

SQL Server 2014 Tutorial – SQL Server Management Studio

Problem Statement You need to manage your Microsoft SQL Server environment using SSMS (SQL Server Management Studio). Solution Microsoft SQL Server Management Studio (SSMS) lets the administrators to perform the following Configure SQL Server components. Create Database, tables, stored procedures and views. Manage data inside the database. and more… Follow the below steps to manage your SQL Server environment in Microsoft SQL Server Management Studio…

Building a ASP.NET Web API in Visual Studio 2015

This blog post will explain on how to create a Simple ASP.NET Web API using Microsoft Visual Studio 2015 and return an expose a List (Eg: List<Students>) over HTTP. This includes creating action methods and using them for get all students and get a particular student by id. How to create a Web API in Visual Studio 2015 and return a List over HTTP? Follow…

Java – How to Read Integers from the Console for calculation ?

Problem Statement You need to read integers from the console window and use it for calculation within your java program. Solution If you want to know how to read integer value from a console and use it for calculation , you can use the Scanner class as shown below. The output of the above program is Please enter the first number for abundantcode 10 Please…

Java – How to create BigDecimal from string value ?

Problem Statement You want to create a BigDecimal value from a string type in Java. Solution Use the BigDecimal class and pass the string value in the constructor to create the BigDecimal value as shown below. The output of the above program is Abundantcode.com Java Tutorials 198654586.297292792

Java – How to convert String to Double in Java ?

Problem Statement You want to convert a string value to double in Java. Solution You can use one of the three approaches to convert a string to double in Java. 1. Assigning the string to the constructor of the Double class 2. Using Double.valueOf 3. Using Double.parseDouble The output of the above program is Abundantcode.com Java Tutorials 76.2 String to double using valueOf 76.2 string…

Java – How to read a valid Integer number from Console ?

Problem Statement You need to read a valid integer number from the Console in your java program. If the number is invalid , show appropriate message. Solution To read a valid integer from a console program , you can use the Scanner class and pass the System.in as the parameter to its constructor. The scanner class exposes a method called nextInt() which can be used…

Java – How to convert Long to other primitive numeric data types ?

Problem Statement You need convert a long value to other numeric data types in java. Solution Use the Long wrapper class which exposes methods like byteValue , shortValue , intValue etc. Below is a sample code snipper demonstrating the usage of the same. The output for the above program is Abundantcode.com Java Tutorials 76 76 76.0

Java How to – Compile and run Java program in Command-line

Problem Statement You need to compile and run your java program in command-line. Solution You can use the command-line tools available with Java Development Kit (JDK). The “javac” command tool can be used to compile the java program. The “java” command can be used to run the java program. Let’s build out first program and use the command line to run. 1. Download and install…

Java – How to convert a double value to string ?

Problem Statement You need to convert a double value to string in your java program. Solution Use the toString() method defined in the Double class to convert a double value to string in java. The output of the above program is Abundantcode.com Java Tutorials 25.0

SQL Server 2014 Tutorial – Display System Databases in Object Explorer.

Problem Statement You need to view the System Databases in Object Explorer. Solution By default , there are few System databases that gets created when you install SQL Server. Some of these databases are master – This is the primary system database which is needed for the SQL Server to start and work fine. It contains the information about databases , logins , configurations etc….

Java – How to Negate a BigDecimal in Java ?

Problem Statement You need to negate the value of the BigDecimal datatype in your java program. Solution Use the negate method defined in the BigDecimal class as shown below. The output of the above program is Abundantcode.com Java Tutorials -10102

Java – How to accept input from Keyboard ?

Problem Statement You need to accpet user input from the keyboard from your java program and display it in the command line. Solution Use the BufferedReader and InputStreamReader defined in the java.io package to read the input data from keyboard and store it in a variable. The output of the above program is Enter data This is a test message from abundantcode.com This is a…

Java – How to setup a Development Environment ?

Problem Statement You need to install java and start developing your first program. Additionally , you also need to download , install and use an IDE (Integrated Development Environment) for development. Solution You need to install Java Development Kit (JDK) 8 which provides the necessary compiler to compile and run your Java programs. Additionally , you can install any one of the following IDE’s by…

SQL Server 2014 Tutorial – Install SQL Server 2014 on Windows 10 machine

Problem Statement You need to install SQL Server 2014 Express edition on Windows 10 machine. Solution There are several ways in which you can install SQL Server. These includes options via command prompt, unattended, server core etc. In this tutorial, we will explore the simplest method using the SQL Server 2014 Setup wizard. Follow the below steps to install SQL Server 2014 1. Download SQL…

SQL Server 2014 Tutorial – List all the databases in SQL Server using Query

Problem Statement You need to list all the databases that are present in the current SQL Server instance. Solution The list of all the databases from the SQL Server instance can be obtained from the sys.databases object as shown below. 1. Open SQL Management Studio and connect to the SQL Server instance with your login details. 2. Click the “New Query” button and enter the…

SQL Server 2014 Tutorial – Manage SQL Server services

Problem Statement You need to manage the SQL Server services that are installed on your server machine. Solution Use SQL Server Configuration Manager tool to manage the SQL Server services on your machine. Following are some of the actions that you can perform using the SQL Server Configuration Manager – Start , Stop , Pause , Restart a SQL Server Service – Modify or configure…