Earning Websites

http://wwwclick.in
http://wwwclickindia.com
http://wwwadeex.com
http://wwwchennaiclassic.com
http://wwwclassifieds.suleka.com
http://www.efm.co.in
http://www.mginger.com
http://11onlinesurveys.blogspot.com/
http://www.bpojobsathome.com
http://www.24workfromhome.info/
http://business-entrepreneur.50webs.com/
http://www.adsfreeads.com
http://www.careerjet.co.in/conversion-jobs.html
http://www.dataconversionjobs.com
http://www.citehr.com/111657-data-conversion-jobs.html
http://www.success-all.com/wealth01.php
www.olx.in
http://www.perfspot.com/invite/invite.asp
http://www.m2617.sunbizteam.com/index.html
www.kndsilver.com
http://www.livserv.com/referrer.html
http://jobs.prlog.org/page5.html
http://dbconvert.com/conversion.php
http://dhankamao.com/
http://www.banks.com/index.php
http://business-entrepreneur.50webs.com
http://www.surveyking.com/
http://hnj.co.in//index.php?option=com_wrapper&Itemid=3
http://ads.adsforindians.com/AdNet/Ads.asp
www.hnj.co.in/adv/ad_rotator.php&#
http://www.blogger.com/post-edit.g
http://www.adsforindians.com/ads/index.asp

SQL Queries

SQL


Introduction:

SQL is a standard language for accessing and manipulating databases.

What is SQL?• SQL stands for Structured Query Language
• SQL lets you access and manipulate databases
• SQL is an ANSI (American National Standards Institute) standard

What Can SQL do?• SQL can execute queries against a database
• SQL can retrieve data from a database
• SQL can insert records in a database
• SQL can update records in a database
• SQL can delete records from a database
• SQL can create new databases
• SQL can create new tables in a database
• SQL can create stored procedures in a database
• SQL can create views in a database
• SQL can set permissions on tables, procedures, and views

SQL DML and DDL
SQL can be divided into two parts: The Data Manipulation Language (DML) and the Data Definition Language (DDL).
The query and update commands form the DML part of SQL:
• SELECT - extracts data from a database
• UPDATE - updates data in a database
• DELETE - deletes data from a database
• INSERT INTO - inserts new data into a database
The DDL part of SQL permits database tables to be created or deleted. It also define indexes (keys), specify links between tables, and impose constraints between tables. The most important DDL statements in SQL are:
• CREATE DATABASE - creates a new database
• ALTER DATABASE - modifies a database
• CREATE TABLE - creates a new table
• ALTER TABLE - modifies a table
• DROP TABLE - deletes a table
• CREATE INDEX - creates an index (search key)
• DROP INDEX - deletes an index

Basic SQL Queries:

//Creating a New Database

Create database mysampledb

Use mysampledb

//Creating New Table

A database most often contains one or more tables. Each table is identified by a name (e.g. "Customers" or "Orders"). Tables contain records (rows) with data.
Create table customers
(
C_Id int NOT NULL primary key,
LastName varchar(255) NOT NULL,
First Name varchar(255),
Address varchar(255),
City varchar(255)
)


//Insert Query

insert into customers values(1,'Aravind','kumer','Anna Nagar 12','Chennai')

insert into customers values(2,'Sundar','Rajan','Villivakkam 13','Chennai')

insert into customers values(3,'Hari','Ram','Perungudi 7','Chennai')

//select Query

select *from customers

select C_Id from customers

select LastName ,FirstName from customers

select Address from customers where C_Id=2

select *from customers where City='chennai'

//update query

update customers set City='chinnur' where C_Id=1


//Alter Column Name
alter table customers Address to Addr varchar(255)

sp_rename 'customers.Address' ,Addr

//Alter Table

//Rename table

sp_rename 'customers details' ,'customersdetails '

//Rename Column

sp_rename 'customers.Address' ,Addr

select *from customersdetails

//Add &drop Column

alter table customersdetails add dob datetime

alter table customersdetails drop column dob

//Distinct

select distinct City from customersdetails

//AND & OR Operators

select Addr from customersdetails where LastName='Hari' and FirstName='Ram'

select Addr ,City from customersdetails where C_Id=4 or LastName='Sundar'

//Order By

select *from customersdetails order by City

IT Companies list in Chennai

Here is the list of IT Companies In Chennai

1. 2M Software Associates
2. A A A Software Solutions P Ltd
3. A T S Software
4. A V Systems
5. Aavanor Systems P Ltd
6. ABSTech Logiks P Ltd
7. Accel Frontline Ltd
8. Acsys Software (India) P Ltd
9. AcuDat Solutions
10. AddVal Technology (India) P Ltd
11. Adhvaya Technologies
12. Adiva Systems P Ltd
13. Adrenalin eSystems Ltd
14. Adroit Software Solutions (Chennai) P Ltd
15. Advanced Information Services P Ltd
16. Advansoft International
17. AdventNet Development Centre (India) P Ltd
18. Aegis IT Solutions (India) P Ltd
19. Agaram Instruments P Ltd
20. Agriya Infoway P Ltd
21. Aiswaryam Computers
22. Aithent Technologies
23. Akmin Technologies
24. Albatross Solutions P Ltd
25. Alcatel Development Centre
26. Alfie Software P Ltd
27. Altech Star Solutions P Ltd
28. Altosys Software Technologies Ltd
29. Altra Designs & Software P Ltd
30. AmerAsia Soft
31. American Megatrends (India) P Ltd
32. Amsoft Solutions P Ltd
33. Amtex Enterprises Inc.
34. Amtex Systems
35. Angel iWay
36. Aniga Technologies
37. Anjana Soft
38. Apps Infotec P Ltd
39. Archimedes Tech Law P Ltd
40. Arimaan Global Consulting
41. Arrowpoint Technologies P Ltd
42. Arshans eSolutions
43. Ascend Softwares
44. Asia Technologies Ltd
45. Aspire Systems (India) P Ltd
46. Astergate Solutions
47. Astra Infotech P Ltd
48. Astrid Software
49. At Road Software (India) P Ltd
50. Atelier Soft P Ltd
51. Atrova
52. Aurama Solution P Ltd
53. Avantage Solutions Ltd
54. Axe Networks P Ltd
55. Axon Engineering Ltd
56. Axsellit Technologies P Ltd
57. B-Accuracy
58. Bahwan Cybertek P Ltd
59. Bally Technologies
60. BarCamp Chennai
61. Barry-Wehmiller International Resources
62. Benchmark Softec Ltd
63. Bharathi Business Solutions
64. BharatPlanet Consulting Ltd
65. BILVAC Technomanagement P Ltd
66. Birlasoft Inc.
67. Blaise Information Systems
68. Blitz Technology Solutions
69. BloomSoft
70. Blue Lotus Technologies P Ltd
71. Blue River Technologies (India)
72. Blueshift
73. Boltzmann Consulting (India) P Ltd
74. Bonsys Technology Solution
75. Bosco InfoTech P Ltd
76. Botree Software International Ltd
77. Brij Datalink P Ltd
78. Broadgate Technical Services (India) P Ltd
79. Brukrs Technologies
80. BullsB.com
81. Byte to Bit Technologies
82. C A C Software Consultancy P Ltd
83. C E I (India) P Ltd
84. C G Maersk Information Technologies P Ltd
85. C S S Corporation
86. C S Software Solutions P Ltd
87. Cache Next Generation (India) P Ltd
88. CADD Centre Software Solutions P Ltd
89. CADS Software (India) P Ltd
90. California Software Company Ltd
91. CashEdge
92. CD Tech
93. CellarStone (India) P Ltd
94. Cepios Software Solutions (India) P Ltd
95. Certus Software P Ltd
96. Chain-Sys (India) P Ltd
97. Changepond Technologies
98. Cherrytec Solutions Ltd
99. Chrisranjana Software Solutions P Ltd
100. Cogent Innovations P Ltd
101. Cognizant Technology Solutions
102. CollabNet
103. Collaboratz Technologies P Ltd
104. Compsoft Technology Solutions Group Inc.
105. Compucrafters (India) P Ltd
106. Computer Associates (India) P Ltd
107. Computers International
108. Conceptworld Corporation
109. Concord IT Services P Ltd
110. Confluence Systems
111. Congruent Info Tech P Ltd
112. Congruent Solutions P Ltd
113. Consolidated Cybernetics Co. P Ltd
114. Convex Systems
115. CoralGrid
116. Cordiant Technologies P Ltd
117. Core Solutions118. Cosmosoft Technologies Ltd
119. Cosoft (India) Ltd
120. Cosyne Enterprises, Inc.
121. Covansys (India) P Ltd
122. Creature Soft Lab
123. Crescent Technosoft
124. Crux Technologies P Ltd
125. Crysmatic P Ltd
126. Crystal Consultancy Services P Ltd
127. Crystal Software Corporation
128. CTECH RC Design (India) P Ltd
129. Cubic Systems
130. Curans IT (India) P Ltd
131. Cygnet Software
132. Darwin Technologies P Ltd
133. DCom Solutions
134. Design Desk (India) P Ltd
135. d-Espat P Ltd
136. DESSS P Ltd
137. Dexterity Business Analysts P Ltd
138. Dhyan Infotech P Ltd
139. DigiBlitz Technologies P Ltd
140. Digital Illusion P Ltd
141. Dowell Technologies P Ltd
142. Drivestream (India) P Ltd
143. Drona Software Systems P Ltd
144. Dynamic Software Solutions
145. E G B Systems & Solutions
146. E Solutions
147. E Tel Systems P Ltd
148. E*Pro
149. EasyTools.com
150. Eco Tech Software P Ltd
151. e-con Systems
152. Edify Technologies (India) P Ltd
153. Edutech India
154. Edwards Technology & Solutions
155. eG Innovations P Ltd
156. eINspire Software Solutions
157. Ellaar Infotek Solutions P Ltd
158. EL-Link Technologies P Ltd
159. Elorasoft (India) P Ltd
160. Embera Technologies P Ltd
161. Emergys Software P Ltd
162. Emerio Technologies P Ltd
163. eNSX Softech P Ltd
164. EntComm Asia
165. Envision Information Systems & Technologies P Ltd
166. Eonour Technologies
167. eOracleZone Inc.
168. ePairs Software Solutions P Ltd
169. EpiSource P Ltd
170. Epitome Solutions (India) P Ltd
171. EPractize Labs Software P Ltd
172. eSkill Technologies
173. eSolve Technologies P Ltd
174. Esquire Systems
175. Essential Software Services
176. Eutech Cybernetics (India) P Ltd
177. Ewak Creative Compusoft Ltd
178. Exim Alert Infotech
179. EzTech Group
180. Faizsoft Solutions
181. Falcon Info Tech
182. FHAPL Technologies
183. Fifth Generation Technologies (India) P Ltd
184. Firstware Software Solutions
185. Fixity Technologies P Ltd
186. FourteWest Technologies P Ltd
187. Fuchsia Software Technologies P Ltd
188. Future Focus Infotech P Ltd
189. Future Software Ltd
190. FXA Software Technology P Ltd
191. G K S A R Groups Computer Division
192. G N S Power System
193. Galaxy Solutions
194. Gantec Solutions P Ltd
195. GAVS Information Services P Ltd
196. GeekLogix Solutions P Ltd
197. Gem Software Solutions Ltd
198. Gensoft Infotech P Ltd
199. Geofiny Technologies (India) P Ltd
200. GeoInSysSoft
201. Gislen Software P Ltd
202. Global Automation P Ltd
203. Global Business Technology Services P Ltd
204. Global Techno Solutions
205. Global-Soft
206. GoFrugal Technologies P Ltd
207. Gokul Software Services
208. Grian Technologies P Ltd
209. Guindy Tech P Ltd
210. H M A STARware Ltd
211. H T C Global Services (India) P Ltd
212. Hedron Systems P Ltd
213. Helios & Matheson Information Technology Ltd
214. Helios Info Systems
215. Hexaware Technologies
216. Highbrew Technologies
217. I B N Software
218. I C Infotech
219. I C S Computing (India) P Ltd
220. I M O G221. I R S Soft
222. I S G NovaSoft Technologies Ltd
223. I T G Solutions Ltd
224. i5 Technologies P Ltd
225. Ibhar Technologies P Ltd
226. iBorderless (India) P Ltd
227. Icomm Technologies P Ltd
228. Igenik Infoway Technologies
229. iInterchange Systems P Ltd
230. iLink Systems
231. iMarque Solutions P Ltd
232. iNautix Technologies (India) P Ltd
233. India Comnet International
234. Indicom Software & Services
235. Indus Asuka Software P Ltd
236. Infinite Strategies
237. Info Corporate (India) P Ltd
238. Infokall
239. Infonet Consultancy Services P Ltd
240. Information Dynamics (India) P Ltd
241. Informix Technologies P Ltd
242. Insoft Systems
243. Insoft.com P Ltd
244. Integrated Hitech Ltd
245. Integrated SoftTech Solutions P Ltd
246. Integrated SoftTech Solutions P Ltd
247. Integrated Strategic Information Systems P Ltd
248. IntelliBitz Technologies
249. Intellisys Technology P Ltd
250. Interim Technologies P Ltd
251. Intuitive Objects Software P Ltd
252. Iris Softek
253. iSoft
254. iSolve Technologies P Ltd
255. IT & e Ltd
256. IT Bright P Ltd
257. IT Fission Technologies
258. Itek Infomatic
259. Ivesia Solutions
260. Ivetel Technologies P Ltd
261. IVTL Infoview Technologies P Ltd
262. J & B Software (India) P Ltd
263. J K Soft
264. J K V Software Solutions
265. Jai E Technologies
266. Jasmin Infotech P Ltd
267. Javaji System Solutions Ltd
268. Jayamaruthi Software Systems P Ltd
269. Jeevan Technologies
270. K R V Systems Software
271. K S A B Software
272. K7 Computing P Ltd
273. Kaar Technologies (India) P Ltd
274. Kaashyap Technologies Ltd
275. Kaavian Systems P Ltd
276. Kallos Systems
277. Kanbay International, Inc.
278. KavNiya Technology Solutions
279. KB-Vis Technologies
280. KDPS Infotecture Inc.
281. Key Power International
282. KHEC Technologies (India) P Ltd
283. Khera Consultants
284. Kinship Technologies P Ltd
285. Kom7 Technologies
286. Kudumi Soft P Ltd
287. Kumaran Systems P Ltd
288. Kwick Soft Solutions P Ltd
289. Lambent Softsystems P Ltd
290. Lancesoft (India) P Ltd
291. Land Marvel Information Technology
292. Laser Soft Infosystems Ltd
293. Lastech
294. Lattice Bridge Infotech P Ltd
295. Lawrence & Associates (India) P Ltd
296. L-Cube Innovative Solutions P Ltd
297. Leading Software Technologies
298. Legacy Software Services Ltd
299. Lexicon Soft Solutions
300. Lister Technologies P Ltd
301. Locus Technologies P Ltd
302. Logic Soft P Ltd
303. Lucid Software Ltd
304. Luit Infotech P Ltd
305. M K Technology
306. M V R Technologies
307. Maarga Systems
308. Maa-Yoke Technology
309. Man Machine Systems
310. Manchyspo Technologies
311. Maples E S M Technologies P Ltd
312. Maruti Computers P Ltd
313. Marvas Info Solution
314. Mascon Global Ltd
315. Maven Consultancy
316. M-Bed Technologies (Bharat) P Ltd
317. Megasoft Ltd
318. Mexcess Solutions P Ltd
319. Micromen Systems & Software P Ltd
320. Minmax Infosystems P Ltd
321. miOOt Technologies
322. Modern Century Soft
323. mPower Software Services
324. M-Squared Software & Services
325. Multivision Inc.
326. N M S Works Software Ltd
327. N T Soft
328. Naethra Technologies P Ltd
329. Nalli SoftSolutions
330. Nature Technology Systems P Ltd
331. NatureSoft P Ltd
332. Nat-V Soft Tech
333. Navacle
334. Nemera International Co. Ltd
335. Neptune Microsystems
336. Newgen Solutions
337. Nigasoft Infotech P Ltd
338. Ninestars Information Technologies Ltd
339. Nipsys Technologies P Ltd
340. Niteo Partners
341. Noetic Solutions P Ltd
342. NonVerba Ltd
343. NRich Software P Ltd
344. N-Tier Business Solutions P Ltd
345. Numeric Technologies P Ltd
346. O B S I Technologies P Ltd
347. Objects Worldwide (India) P Ltd
348. Odyssey Technologies Ltd
349. Omnex Systems
350. OneClickHR P Ltd
351. Onspec Technology Solutions P Ltd
352. OrangeScape Technologies Ltd
353. P B S C Spectacular Solutions Ltd
354. P M C Soft Ltd
355. Palpap Ichinichi Software International Ltd
356. Pantech Solutions
357. Pathfinder Software Solutions P Ltd
358. Pegasus Infosoft
359. Pentagon Global Solutions Ltd
360. PerfSystems (India) P Ltd
361. Peri Software Solutions P Ltd
362. Photon InfoTech P Ltd
363. Pinnacle Netvision P Ltd
364. Pinnacle Software System P Ltd
365. Planvisage Software Solutions P Ltd
366. Polaris Software Lab Ltd
367. Precious Microtech P Ltd
368. Precision Techconet
369. Prelude Solution Providers P Ltd
370. Prodapt Solutions
371. ProdEx Technologies
372. ProdexNet Inc.
373. Prognet Technologies P Ltd
374. Proitek IT Solutions
375. Prompt Software P Ltd
376. Protechsoft
377. Prumatech Services P Ltd
378. Qatalys Software Technologies
379. Quintegra Solutions Ltd
380. Rajasri Systems P Ltd
381. Raksha Technologies P Ltd
382. Ram Knowledge Systems P Ltd
383. Ramco Systems Ltd
384. Raysoft Technologies
385. RedBlackTree Technologies P Ltd
386. Redim Software Technologies P Ltd
387. Redington (India) Ltd
388. Relay Software Services P Ltd
389. ReliasolutionsSoft P Ltd
390. Resurgent Software Technologies
391. RevaSoft P Ltd
392. Rising Solutions P Ltd
393. S C R Soft Technologies P Ltd
394. S G T (India) P Ltd
395. S R A Systems Ltd
396. S R M Technologies P Ltd
397. S R V Consultants
398. S S I Ltd
399. S T Cyber Technologies (India) P Lid
400. Saiber Soft Systems P Ltd
401. Saksoft Ltd
402. Sansoft Technologies
403. Santec Solutions P Ltd
404. Savant Technologies P Ltd
405. Savvysoft Technologies
406. Scape Velocity
407. Scorpio Technologies
408. Seal Consulting Inc
409. Senses Technologies
410. Servion Global Solutions Ltd
411. Seventhsense Technologies P Ltd
412. Shakti Infosolutions P Ltd
413. Sherlock Infotech P Ltd
414. Sholingur Textiles Ltd - Software Division
415. Signatures India Associates
416. SimpBiz Software Solutions P Ltd
417. Simply-Logic Technologies
418. SIPTech Solutions Ltd
419. Sirsai Multi Sourcing P Ltd
420. Smart Infotech Solutions (India) P Ltd
421. SmartWares
422. Sofgen (India) P Ltd
423. Sofist India
424. Soft_Solutions4U
425. Softech Infinium Solutions Ltd
426. SoftTeam Solutions P Ltd
427. Softura P Ltd
428. SolutionNET
429. Songbird Technologies
430. Space Computer & Systems Ltd
431. SpectraSoft Technologies Ltd
432. Speech & Software Technologies (India) P Ltd
433. Sree Balaji Software & Consulting Services
434. Srushti Technology Solutions P Ltd
435. Sryas Inc.
436. Stark Infotech
437. Steepleware Solutions P Ltd
438. Step Ahead Software Solutions P Ltd
439. STEX Software P Ltd
440. Strategic IT Solutions Corp
441. Subhashree Software Solutions P Ltd
442. Sukraa Software Solution P Ltd
443. Sukraa Technologies
444. Sumeru Soft P Ltd
445. SummitWorks Technologies P Ltd
446. Sundaram Infotech Solutions
447. Swatee Systems P Ltd
448. Swide Solutions P Ltd
449. SwisSQL450. Synchrologic Systems P Ltd
451. Synergy Log-In Systems Ltd
452. Systech Solutions P Ltd
453. Systems Technology Group (India) P Ltd
454. Sysveda Information Technology P Ltd
455. Sysvine Technologies P Ltd
456. T A D Consultancy
457. T B S
458. T V S Infotech Ltd
459. Tachyon Technologies P Ltd
460. Take Solutions Ltd
461. Tara Infotech
462. Technova Solution
463. Teledata Informatics Ltd
464. Telesis Global Solutions Ltd
465. Temenos (India) P Ltd
466. Tenmiles Corporation
467. Tent Software P Ltd
468. Tenth Planet Technologies P Ltd
469. Thesys Technologies P Ltd
470. Thirdwave Computers Consultancy
471. Transcend Technology Orbit
472. Transworld Information Systems
473. Trends Infonet Solution P Ltd
474. Triad Software P Ltd
475. Trident Solutions
476. Triens Software Solutions P Ltd
477. Trimentus Technologies P Ltd
478. Ubique Marketing P Ltd
479. Ultramatics (India) P Ltd
480. Unique Software Systems (India)
481. Universal Elements
482. V I T Consultancy P Ltd
483. Value Software Technologies Ltd
484. ValueSource Technologies P Ltd
485. Vanavil Software
486. VBizAp Soft Solutions P Ltd
487. VED Software Services P Ltd
488. Veeras Infotek P Ltd
489. Vembu Technologies P Ltd
490. Venkki Technology P Ltd
491. Ventech Solutions (India) P Ltd
492. Veritech (India) P Ltd
493. Verizon Data Services India
494. Vernalis Systems P Ltd
495. Vertex Systems Ltd
496. Vertical Technologies
497. Viamentis Technologies P Ltd
498. Vishwak Solutions P Ltd
499. Vistasoft (India) P Ltd
500. Viswambara Software Systems P Ltd
501. Vizual Business Tools P Ltd
502. Voice Snap Software Ltd
503. Vox & Waves Solutions P Ltd
504. VTiger
505. Vyapin Software Systems P Ltd
506. Wayne-Burt Technologies
507. Websoft Systems, Inc
508. Wesgrow Software
509. Westernacher (India) P Ltd
510. WinFashion
511. Winlogix
512. Winsar Infosoft P Ltd5
13. Wisdom Software Solutions
514. Wisual IT
515. Xansa5
16. Xtenza Solutions P Ltd
517. Yalamanchili Consultancy Services P Ltd
518. Yantro P Ltd
519. Yennes Infotec P Ltd
520. yKAP
521. Zanok Technologies P Ltd
522. Zeetaa Business Solutions P Ltd
523. ZEiSys Technologies P Ltd
524. Zelos Technologies (India) P Ltd
525. ZILLIONe Systems South India P Ltd
526. Zoniac India
527. Zylog Systems LtdImports System.Data.SqlClient