SQL QUERY TO FIND NOT CONTAINS VALUES

SQL QUERY - NOT CONTAINS VALUES FROM TWO TABLES  AND SAME COLUMNS

DESCRIPTION:

             In my example I have used Toad SQL Server 2008 as a query analyser.

Objective:
            To obtain the not contains value of a two tables with same column name., if table A has a column city and table B has a column city, in this scenario we need to get the cities of table A which not contains in table B.

Table "A" contains

Table "B" contains

Now I need to get the cities from table "A" which not contains in table "B"

The query is,

and we get the result as shown in below,

Thank you!

autocomplete textbox using jquery

AUTOCOMPLETE TEXTBOX USING JQUERY

DESCRIPTION:

         THE TEXT BOX WITH AUTO SUGGESTION OR AUTO COMPLETE TEXT BOX CAN BE DONE WITH THE USE OF JQUERY 1.9.1 JS AND JQUERY UI 1.10.4.

STEP 1: CREATE A TEXT BOX WITH SOME NAME ANY ID.

STEP 2: NOW ON THE HEADER SECTION ADD THE FOLLOWING CODE

STEP 3:  AFTER ADDING THE STYLE AND SCRIPT ON THE HEADER SECTION ADD THE FOLLOWING SCRIPT IN BODY OR HEAD OF THE HTML, WITH THE NO. OF INPUTS FOR THE AUTO SUGGESTION TEXTBOX.

STEP 4:

ADD THE UI CLASS AS SHOWN BELO IN THE TEXTBOX TAG

NOW YOU HAVE DONE NOW TYPE AND SEE THE INPUT, FOLLOWING SHOWS THE RESULT OF MY EXAMPLE.