SQL SERVER 2005 FUNCTIONS

http://www.sql-server-helper.com/tips/date-formats.aspxSELECT  *  FROM SALARY_FITMENT_CODE ORDER BY AUTO_CODESELECT MODE FROM SALARY_FITMENT_CODE GROUP BY MODESELECT COUNT(QUANTITY) AS QTY, FLIGHTCOMPANYNAME FROMAIR_TICKET_BOOKING_MASTER WHERE STATUS = 'DONE' GROUP BYFLIGHTCOMPANYNAMESELECT COUNT(QUANTITY) AS QTY, FLIGHTCOMPANYNAME FROMAIR_TICKET_BOOKING_MASTER WHERE STATUS = 'DONE' GROUP BYFLIGHTCOMPANYNAME HAVING COUNT(QUANTITY)>1SELECT ROW_NUMBER() OVER(ORDER BY code), * FROM SALARY_FITMENT_CODESELECT ROW_NUMBER() OVER(PARTITION BY mode order by Auto_code),*FROM TABLESELECT UPPER('string...

Read More

How to Make Symbol with Keyboard

...

Read More

Anna University MCA 5th Semester Subjects List 2013

ANNA UNIVERSITY, CHENNAI MCA V SEMESTER Main and Elective Papers List   Totally 5 Papers in this Semester2 Main Papers + 3 Elective Papers= 5 Papers.  Main Papers: MC9251 Middleware TechnologiesMC9252 Software Project ManagementPRACTICAL:MC9254 Middleware Technology Lab MC9255 Software Development LabElective Papers: (Only 3 Papers given list) Subject Code     SubjectsMC9276         Advanced DatabasesMC9277        ...

Read More

Computer Architecture Two mark Questions

PART A 1.Define Computer Architecture Computer Architecture Is Defined As The Functional Operation Of The Individual H/W Unit In A Computer System And The Flow Of Information Among The Control Of Those Units 2.Define Computer H/W   Computer H/W Is The Electronic Circuit And Electro Mechanical Equipment That Constitutes The Computer 3. What Is Meant By Cache Memory ? A Memory That Is Smaller And Faster Than Main Memory And That Is Interposed Between The Cpu And Main Memory. The Cache Acts As A Buffer For Recently Used Memory Location 4.what...

Read More