The SQL UPDATE Statement
The UPDATE statement is used to update existing records in a table.
SQL UPDATE Syntax
UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;
Saturday, 16 January 2016
SQL UPDATE STATEMENT
insert into in SQL
The SQL INSERT INTO Statement
The INSERT INTO statement is used to insert new records in a table.
SQL INSERT INTO Syntax
It is possible to write the INSERT INTO statement in two forms.
The first form does not specify the column names where the data will be inserted, only their values:
INSERT INTO table_name
VALUES (value1,value2,value3,...);
The second form specifies both the column names and the values to be inserted:
INSERT INTO table_name (column1,column2,column3,...)
VALUES (value1,value2,value3,...);
IMPORTANT SQL COMMANDS
Some of The Most Important SQL Commands
- 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
- 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
ABOUT SQL
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 is a Standard - BUT....
Although SQL is an ANSI (American National Standards Institute) standard, there are different versions of the SQL language.
However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.
Using SQL in Your Web Site
To build a web site that shows data from a database, you will need:
- An RDBMS database program (i.e. MS Access, SQL Server, MySQL)
- To use a server-side scripting language, like PHP or ASP
- To use SQL to get the data you want
- To use HTML / CSS
RDBMS
RDBMS stands for Relational Database Management System.
RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.
The data in RDBMS is stored in database objects called tables.
A table is a collection of related data entries and it consists of columns and rows.
ALTER DB QUARRIES
The ALTER TABLE Statement
The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.
SQL ALTER TABLE Syntax
To add a column in a table, use the following syntax:
ALTER TABLE table_name
ADD column_name datatype
To delete a column in a table, use the following syntax (notice that some database systems don't allow deleting a column):
ALTER TABLE table_name
DROP COLUMN column_name
To change the data type of a column in a table, use the following syntax:
SQL Server / MS Access:
ALTER TABLE table_name
ALTER COLUMN column_name datatype
My SQL / Oracle (prior version 10G):
ALTER TABLE table_name
MODIFY COLUMN column_name datatype
Oracle 10G and later:
ALTER TABLE table_name
MODIFY column_name datatype
Common Use of Function Key (F1 to F12)in Window
Common Use of Function Key (F1 to F12)in Window
You might be Using Windows since long time but i am sure majority of you guys don’t know all the features and Uses of F1-F12 keys on your keyboard. We all know Common shortcuts like CTRL+C to Copy and CTRL+V to Paste, But you might not know what F1, F2,F3…….F12 keys actually do and where and when to use them.
In this article we will see Common features and Uses of F1-F12 keys , and also how these keys can be used with the Combination of CTRL and ALT keys.
USES OF F1 KEY:
- F1 key almost everywhere is used for “Help”. if you are using windows OS and want help anywhere then press F1 key, this will open up help window for you.
- Sometimes F1 key is used to enter the BIOS (press F1 when your computer is about to boot).
- Combination of Win + F1 keys will open the “Help and Support» Microsoft Windows.
USES OF F2 KEY:
- Rapidly rename the chosen file or folder. Works in all adaptations of Windows.
- Alt + Ctrl + F2 – Opens the Document as a Microsoft Word.
- Ctrl + F2 – Opens the Preview window in Microsoft Word.
- Frequently to enter the BIOS.
USES OF F3 KEY:
- In the MS-DOS charge line or in Windows, press F3 to rehash the last summon.
- Win + F3 – Advanced Search window opens in Microsoft Outlook.
- Shift + F3 – Changes the content in Microsoft Word, from upper to lower case or capital letters at the start of each one expression.
- In the event that I am not mixed up it is the F3 key which will cause the Application«Control» computers Apple, running Mac OS X.
USES OF F4 KEY:
- This opens the location bar, in the event that you press F4 in Windows Explorer and Internet Explorer.
- Rehash the last activity (MS Word )
- Ctrl + F4 – Closes the window open in the present window, for example, a tab in the program
- Alt + F4 – Closes the system window in Windows.
USES OF F5 KEY:
- Refreshes the present page (works in all advanced programs), and additionally redesign the desktop or open organizers in Windows.
- Running a slide demonstrate in Powerpoint.
USES OF F6 KEY:
- Move the cursor in the location bar (additionally works in numerous advanced programs).
- Ctrl + Shift + F6 – opens Document in Microsoft Word
USE OF F7 KEY:
- Mostly used for spelling and grammar in a document programs Microsoft (Word, Outlook, etc.)
USE OF F8 KEY:
- Pressing F8 key while your PC is about to boot will result into booting your PC in Safe mode.
USE OF F9 KEY:
- The F9 key does not have any functionality in Windows. It may, however be used in some individual programs. To find out if it is available in the program you are using, bring up the program’s help screen and type in the words function key.
USES OF F10 KEY:
- Activates “Menu” in the open organizer window.
- Shift + F10 – works same as the right mouse click.
- Pressing F10 while your system is booting will show you BIOS Information.
- F10 is used to enter the hidden recovery partition on computers Sony.
USE OF F11 KEY:
- F11 Key will take you to Full screen mode and it can be used and work in any Browser.
USES OF F12 KEY:
- Opens the “Save As” in Microsoft Word.
- Shift + F12 – Saves a document in Microsoft Word.
- Ctrl + Shift + F12 – Prints a document in Microsoft Word.
- F12 key will open up Inspect element box in any Browser.
Fn + F1 or F2 or …. F12 keys will normally do the task that is Printed on the respective keys, This is basically for Laptop Users.
With this it Concludes my list of uses of F1-F12 keys in windows, if you know any more uses then please add to this article by Commenting Below.
Thursday, 14 January 2016
Constitution of an Empowered Committee of Secretaries to process the recommendations of the 7th Central Pay Commission
Press Information Bureau
Government of India
Cabinet13-January-2016 16:37 IST
Government of India
Cabinet13-January-2016 16:37 IST
Constitution of an Empowered Committee of Secretaries to process the recommendations of the 7th Central Pay Commission
The Union Cabinet, chaired by the Prime Minister Shri Narendra Modi, has given its approval for setting up an Empowered Committee of Secretaries under the Chairmanship of Cabinet Secretary, in order to process the recommendations of 7th Central Pay Commission (CPC) in an overall perspective.The Empowered Committee of Secretaries will function as a Screening Committee to process the recommendations with regard to all relevant factors of the 7th CPC in an expeditious detailed and holistic fashion.
Thursday, 31 December 2015
Tuesday, 29 December 2015
Inaguratation of CBS rollout at Kantilo sub post office under Nayagarh H.O.The first CBS sub post office of Nayagarh District, by I.P Nayagarh(east) and Sisir Sahoo(SPM Kantilo S.O). Special Thanks To:...................... 1:-Bibhuprasad Mishra2:-Kabiraj Nayak3:-Sambit Mishraand Sri Surekh Reghunanthen(SSPOS PURI) AND The Support team for their timely co-operation to make it a grand success
Wednesday, 23 December 2015
Government says goodbye to clerk era, changes designation for its staff
By PTI | 22 Dec, 2015, 03.37PM IST
NEW DELHI: Designations like Lower Division Clerk (LDC) and Upper Division Clerk (UDC) in central government's employee hierarchy have been replaced with new nomenclature.
The posts of UDC and LDC under Central Secretariat Clerical Service (CSCS) have been rechristened as Senior Secretariat Assistant and Junior Secretariat Assistant, respectively, an order issued by the Department of Personnel and Training (DoPT) said.
Besides, the post of Assistant under Central Secretariat Service (CSS) has been renamed as Assistant Section Officer, it said.
Both the CSCS and CSS form the backbone of administrative work in the central government.
The total sanctioned strength of CSS and CSCS is 11,467 and 5,933 respectively.
Earlier in March, the DoPT had decided to replace the 'class' categorisation for specifying the seniority of its employees with new alphabetical groupings.
The posts under the central government will be denoted as groups A, B, C and D instead of classes I, II, III and IV in the service rules, it had said.
The Class-III (Group C) employees had expressed concern that they were taunted as 'third-class' employees due to the categorisation.
The Class-I classification is for gazetted officers while Class-II refers to mainly the non-gazetted officers, though there are some gazetted officers in this category too.
Class-III comprises clerical staff and Class-IV (which is now subsumed in Class III or Group C) includes peons and helps or multi-tasking staff in the government hierarchy.
The posts of UDC and LDC under Central Secretariat Clerical Service (CSCS) have been rechristened as Senior Secretariat Assistant and Junior Secretariat Assistant, respectively, an order issued by the Department of Personnel and Training (DoPT) said.
Besides, the post of Assistant under Central Secretariat Service (CSS) has been renamed as Assistant Section Officer, it said.
Both the CSCS and CSS form the backbone of administrative work in the central government.
The total sanctioned strength of CSS and CSCS is 11,467 and 5,933 respectively.
Earlier in March, the DoPT had decided to replace the 'class' categorisation for specifying the seniority of its employees with new alphabetical groupings.
The posts under the central government will be denoted as groups A, B, C and D instead of classes I, II, III and IV in the service rules, it had said.
The Class-III (Group C) employees had expressed concern that they were taunted as 'third-class' employees due to the categorisation.
The Class-I classification is for gazetted officers while Class-II refers to mainly the non-gazetted officers, though there are some gazetted officers in this category too.
Class-III comprises clerical staff and Class-IV (which is now subsumed in Class III or Group C) includes peons and helps or multi-tasking staff in the government hierarchy.
Source : http://economictimes.indiatimes.com/
Lok Sabha passes Bonus Bill; benefits to accrue from April 2014
Tuesday, 22 December 2015 - 9:00pm IST | Place: New Delhi | Agency: PTI
The Lok Sabha on Tuesday passed a bill allowing doubling of wage ceiling for calculating bonus to Rs 7,000 per month for factory workers with establishments with 20 or more workers, with the benefits being applicable retrospectively from April 2014.
The Payment of Bonus (Amendment) Bill, 2015, was passed by a voice vote, with some members objecting to the raising of eligibility limit for payment of bonus from a salary of Rs 10,000 per month to Rs 21,000.
Replying to a debate on the legislation, Labour Minister Bandaru Dattatreya said the Government has ensured that the interest of workers are protected and there is no infringement on their rights.
"Because of Bihar Elections this bill got delayed... The Prime Minister spoke to me and asked why should the benefits of this Act should accrue to workers from 2015. It should be made available from the April 2014," he said while moving an official amendment to the Bill.
The official amendment provides that the benefits of the Act would be deemed to have come into force on April 1, 2014, instead of April 1, 2015. Dattatreya said the Ministry has held 21 tripartite meetings with all central trade unions while arriving at a decision.
The Bill provides for enhancing monthly bonus calculation ceiling to Rs 7,000 per month from the existing Rs 3,500. It also seeks to enhance the eligibility limit for payment of bonus from Rs 10,000 per month to Rs 21,000 per month.
"The Government's paramount intention is to safeguard the interest of workers... There is no infringement of workers' rights and whatever the government does will be in the interest of workers," Dattatreya said.
After the bill was passed, Deputy Speaker M Thambidurai, who was in the Chair, said the government should be congratulated for bringing the measure as also for effecting the benefits retrospectively.
Terming the legislation as historic, Dattatreya said the outgo from government coffers would be about Rs 6,203 crore.
The Minister said the Bill would benefit crores of organised sector worker. He said unorganised sector constitute 93 per cent of the workforce or about 40 crore people.
Participating in the discussion, Mumtaz Sanghamita (TMC) said "it will benefit vast majority of poor workers. Bonus is the thing which is extra and over regular pay". She, however, wanted to know whether the increase in ceiling was commensurate to the inflation rate.
M Srinivas Rao (TDP) observed that labour laws in India were very weak and government should ensure safety and security for workers.
K Visheweshwar Reddy (TRS) said the sharp cut off of Rs 21,000 per month was flawed and added that contractual workers in factories are overworked and underpaid.
Sankar Prasad Datta (CPI-M) too echoed similar views saying that Rs 21,000 per month ceiling should not be there. Jaiprakash Narayan Yadav (SP) said there should be a special provision for women workers while providing bonus.
Prahlad Singh Patel (BJP) asked the government to fix a minimum ceiling and not the maximum one. "We can also think of linking it with the Pay Commission, so that we do not have to come again and again to Parliament to make changes". He said bonus should not be linked to profit or losses.
The Payment of Bonus Act, 1965, is applicable to every factory and other establishment in which 20 or more persons are employed on any day during an accounting year. The last amendment to the eligibility limit and the calculation ceiling was carried out in 2007 and made effective from April 1, 2006.
This amendment in the Act to increase wage ceiling and bonus calculation ceiling was one of the assurances given by the Centre after 10 day central trade unions went on one-day strike on September 2.
Source : http://www.dnaindia.com/
Tuesday, 15 December 2015
Monday, 30 November 2015
ROLL OUT OF PLI MC CAMISH AT NAYAGARH HO ON 30.11.2015
Inagurated by ASP HQ Puri Divion Mr.Niranjan Mohanty,Postmaster Nayagarh HO Mr.Aswini Kumar Swain ,IP East Nayagarh Mr.Satyabrata Gahan & all office staffs , Special efforts and dedication by Mr.Bibhuprasad Mishra,Kabiraj Nayak ,Brahmananda Das,Durgaprasad Behera & Sachichidanand Kumar .Its the labour of the whole team.
Subscribe to:
Posts (Atom)