Tuesday, November 15, 2011

How TO Use SVN FOR Team Work.

How TO Use SVN FOR Team Work.
please visit this link.
http://www.youtube.com/watch?v=4yola1Q9KEQ

Sunday, November 13, 2011

PHP Open Source Projects.

These are following website from where you can downlode PHP Project.or there Source Code.
www.hotscripts.com
http://www.opensourcescripts.com/
 http://www.killerphp.com/articles/killer-php-projects/

Thursday, September 15, 2011

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

Tuesday, September 13, 2011

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


http://zeollar.cloudapp.net/Session/256
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