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
===========================================================================