BASIC SELECT SQL SERVER QUERY.

BASIC SQL SERVER QUERY.
=========================================================

SELECT * FROM MasterControl

FOR ACCESS ALL RECORD FROM DATABASE

SELECT CODE,CONTTYPE,MANDATORY FROM MasterControl

FOR ACCESS SPECIFIC COLUMAN FROM ANY TABLE


SELECT CODE AS CODE,DATATYPE AS "DATA TYPE" FIELDNAME AS FIELD NAME FROM MASTERCONTROL

THIS QUERY USE FOR TABLE ALISING

SELECT  TOP 3 *  FROM MASTERCONTROL

THIS QUERY USE FOR ACCESS TOP 3 ROW FROM ANY TABLE.

SELECT DISTINCT MANDATORY FROM MASTERCONTROL

THIS QUERY USE FOR ACCES DIFFERENT RECORD FROM ANY TABLE

SELECT *,* FROM MASTERCONTROL

THIS QUERY IS USE FOR PRINT THE RECORD DOUBLE TIME.

SELECT CODE+' '+CONTTYPE AS FULLNAME FROM MASTERCONTROL

THIS QUERY IS USE FOR COMBINE TOW COLUMAN IN A SINGLE COLUMAN.

SELECT COUNT (*)

THIS QUERY WILL RETURN 1

SELECT Code, ' is ' ,CONTTYPE FROM MASTERCONTROL

THIS QUERY USE FOR ADDING AN EXTRA  COLUMAN IN RESULT TIME DYNAMICALLY
===========================================================================

Interesting HTML5 drag-n-drop webcast on Zeollar.com

http://zeollar.cloudapp.net/Session/256

Zeollar - HTML 5 Drag/Drop API

zeollar.cloudapp.net

An initiative that gets you latest technical content on a daily basis in different channels. Think of it like a personal television that switches on every day at a specified hour allowing you to switch channels and view the channel of your interest.

MySQL Performance Tuning: Top 10 Tips

www.slideshare.net
MySQL Performance Tuning: Top 10 Tips intended for PHP, Ruby and Java developers on performance tuning and optimization of MySQL. We will cover the deadly mista

‎5 Ways to Make Ajax Calls with jQuery

http://net.tutsplus.com/tutorials/javascript-ajax/5-ways-to-make-ajax-calls-with-jquery/

Design Patterns in software development.

http://sourcemaking.com/design_patterns

Design Patterns

sourcemaking.com

In software engineering, a design pattern is a general repeatable solution to a commonly occurring problem in software design. A design pattern isn't a finished design that can be transformed directly into code. It is a description or template for how to solve a problem that can be used in many diff...

MySQL Data Types: Quick Reference Table

http://kimbriggs.com/computers/computer-notes/mysql-notes/mysql-data-types-50.file

The latest MySQL documentation is at the MySQL Web Site, but I highly recommend getting the book "MySQL" by Paul DuBois for a very readable and thorough book on the subject. There is a sample database that you can download to follow along with the examples in the book. Good Stuff. These notes are ...

PHP CODE WEBSITE

WWW.codestalk.com

Adaptive CSS grid system

http://lessframework.com/