Hi programmers , welcome to another Microsoft SQL server post. this article i’ll write different query to create table and insert records in SQL server. The Create statement is used to create tables and insert statement is used to inserting data into database table. let’s see the queries. 1.Creating basic tables without using any constraints. […]
Hi programmers , welcome to new post of java programming. this post i’ll write various ways to perform product of digits using java language. Example of product of digits means digit multiplication of given number.234 is solved as 2 * 3 * 4 = 24.we can do product of digits of a number using while […]
Hi programmers , welcome to new post of java programming. this post i’ll write various ways to perform sum of digits using java language. Example of sum of digits means digit sum of given number.234 is solved as 2 + 3 + 4 = 9.we can do Sum of digits of a number using while […]
Hi Programmers, welcome to new post Microsoft SQL Server 2019 version in Windows operating system.First we need to download SQL server 2019 . For installation , let’s follow the following steps.Step1. click setup file of SQL server 2019 –>installation –> click New SQL server stand-alone installation. see below image. Step2: Speify types of edition(Developer) –> […]
Hi Programmers, welcome to new post Microsoft SQL Server Management Studio 18 version in Windows operating system.First we need to download SQL server 2019 and ssms 18.8(any latest version). For installation , let’s follow the following steps. Step1.click setup file of SQL server 2019 –>installation –> click New SQL server stand-alone installation. see below image. […]
Hi Programmers,welcome to new article of ozanecare. this article i’ll write the queries for subquery in Microsoft SQL Server. SUB-QUERIES : If we write select statement in where Clause that can be called it as sub queries or inner queries.Four Types of SUB-QUERIES.1.Single ROW SUB-QUERIES2.Multi ROW SUB-QUERIES3.Multiple Column SUB-QUERIES4.Correlated SUB-QUERIES , Let’s see the queries. […]
Hi Programmers,welcome to new article of ozanecare. this article i’ll write the queries to find out Salary less Than Average Salary in Microsoft SQL Server. let’s see the queries. Directly Test Below Queries into Editor. Happy Coding…Thanks.
Hi Programmers,welcome to new article of ozanecare. this article i’ll write the queries to find out Salary Greater Than Average Salary in Microsoft SQL Server. let’s see the queries. Directly Test below queries into Editor. Happy Coding…Thanks.
Hi Programmers,welcome to new article of ozanecare. this article i’ll write the queries for correlated subquery using Microsoft sql server. The correlated subquery is a sub-query that uses values from the outer query. In this case the inner query has to be executed for every row of outer query andsubquery depends on the outer query […]
Hi Programmers, welcome to new article of c#.net. this article i’ll write the program to Multiply Two Numbers without using Multiplication Operator in C# console application. To Achieve the output we should use Logical XOR operator , Shift operator and Conditional AND operator. Let’s see the codes. Directly Test Below codes into Editor. Happy Coding…Thanks.