Developer's Blog

SQL Query Tutorial - Searching and Extracting Text

2013-06-29T13:45:00.002-07:00

This Post describes how to write SQL query to find out substring from text column and extract substring. I create a dummy table for this tutorial, as you can see: Now, lets suppose a scenario if anyone want to extract just city or country name from above table, then how query should be design. There are many SQL functions applied on string. I used string functions for designing this query

Create Editable HTML table using JavasSript

2013-05-13T00:29:00.000-07:00

Some days before i was surfing different sites and groups. There i saw post related to editable HTML table. I write out this tutorial for beginners who want to learn basic things about HTML and JavaScript. Firstly, i create a HTML table like this: Lets Check working of above HTML table. At that stage, all fields in html table are readonly, means one can only read and view it

SQL Query Tutorial part 1

2013-02-18T02:34:00.000-08:00

This post is all about SQL queries. For beginners and students, it will be helpful. 1- How to select all records/columns from table? For above statement, just open query editior and write query like: SELECT * FROM Customers; In this query, SELECT and FROM are SQL keywords. These are reserved words and have special meaning. SELECT keyword used for selecting columns from table(s). As

Artificial Intelligence - A wider approach

2013-02-13T21:55:00.000-08:00