Convert Image to PDF

Thanks My Reader for 50K TARGET

Thanks a lot.....

for reading my blog....

getting me reach to this target of 50K.

BJP Presented By : Yaar No Technology

Congratulations to all BJPians

Q2. Consider the following code snippet:

int number = 14;

if (number >= 10;

{      

    if (number  == 10)         

                jLabel1.setText("first string");      

    else               

               jLabel1.setText("second string");    

                 jLabel2.setText("third string");

}

What will be the output of the following code snippet:

Q1. Identify the error(s) in the following code fragment

switch(ch)
{
    case 'a':
    case 'A':
    case 'e':
    case 'E':
    case 'i':
    case 'i':
    break;
 
    default :  ch = 'N';
    break;
}

Comment your answers fast......

Give me your answers.....

In the above code fragment errors are:

i)  The variable ch is uninitialised.

ii) The switch statements two case constants are

     identical : case 'i' and case 'i'.

     The case constant must have different value.

SQL - INSERT INTO SELECT Examples

Copy only a few columns from "Suppliers" into "Customers":

Example

INSERT INTO Customers (CustomerName, Country)
SELECT SupplierName, Country FROM Suppliers;

Try it Yourself »

Copy only the German suppliers into "Customers":

Example

INSERT INTO Customers (CustomerName, Country)
SELECT SupplierName, Country FROM Suppliers
WHERE Country='India';

Try it Yourself »

SQL - INSERT INTO SELECT Syntax

We can copy all columns from one table to another, existing table:

INSERT INTO table2
SELECT * FROM table1;

Or we can copy only the columns we want to into another, existing table:

INSERT INTO table2
(column_name(s))
SELECT column_name(s)
FROM table1;

SQL - SELECT INTO Examples

Create a backup copy of Customers:

SELECT *
INTO CustomersBackup2017
FROM Customers;

Use the IN clause to copy the table into another database:

SELECT *
INTO CustomersBackup2017 IN 'Backup.mdb'
FROM Customers;

Copy only a few columns into the new table:

SELECT CustomerName, ContactName
INTO CustomersBackup2017
FROM Customers;

Copy only the German customers into the new table:

SELECT *
INTO CustomersBackup2017
FROM Customers
WHERE Country='India';

Copy data from more than one table into the new table:

SELECT Customers.CustomerName, Orders.OrderID
INTO CustomersOrderBackup2017
FROM Customers
LEFT JOIN Orders
ON Customers.CustomerID=Orders.CustomerID;

Tip: The SELECT INTO statement can also be used to create a new, empty table using the schema of another. Just add a WHERE clause that causes the query to return no data:

SELECT *
INTO newtable
FROM table1
WHERE 1=0;

SQL - SELECT INTO Syntax

We can copy all columns into the new table:

SELECT *
INTO newtable [IN externaldb]
FROM table1;

Or we can copy only the columns we want into the new table:

SELECT column_name(s)
INTO newtable [IN externaldb]
FROM table1;

The new table will be created with the column-names and types as defined in the SELECT statement. You can apply new names using the AS clause.

Creating Simple HTML Webpage

HTML Tutorial

For more videos...

Visit: https://www.youtube.com/channel/UCGIbi8a1tySX5hl5Ts4-fAA

Don't Forget 2  Subscribe 

Top 112 Full HD Wallpapers of the World

This video is full of Awesomeness.

For more videos...

Visit: https://www.youtube.com/channel/UCGIbi8a1tySX5hl5Ts4-fAA

Don't Forget 2  Subscribe