Saturday 26 November 2011

How to Find Number of Record in All Table in SQL SERVER


DECLARE @name VARCHAR(500)
DECLARE @sql VARCHAR(1000)

CREATE TABLE #TableRecordCount
( TableName VARCHAR(100),
  RecordCount INT
)

DECLARE dbCursor CURSOR FAST_FORWARD
FOR SELECT T.NAME FROM SYSOBJECTS T WHERE T.XTYPE = 'U' AND LEFT(T.NAME,1)<>'_' AND NOT T.NAME='Timeline' ORDER BY T.NAME

OPEN dbCursor
FETCH NEXT FROM dbCursor INTO @name
WHILE @@FETCH_STATUS = 0
BEGIN
      SET @sql = 'INSERT INTO #TableRecordCount (TableName, RecordCount) '
      SET @sql = @sql + 'SELECT ''' + @Name + ''' AS TableName, COUNT(*) AS CNT '
      SET @sql = @sql + 'FROM [' + @name + ']'
      EXEC (@sql)
      FETCH NEXT FROM dbCursor INTO @name
END

CLOSE dbCursor
DEALLOCATE dbCursor

SELECT SUM(RecordCount) FROM #TableRecordCount
SELECT * FROM #TableRecordCount WHERE RecordCount>50 ORDER BY RecordCount DESC

DROP TABLE #TableRecordCount

Friday 17 June 2011

Delete An undeletable File


Open a Command Prompt window and leave it open.
Close all open programs.
Click Start, Run and enter TASKMGR.EXE
Go to the Processes tab and End Process on Explorer.exe.
Leave Task Manager open.
Go back to the Command Prompt window and change to the directory the AVI (or other undeletable file) is located in.
At the command prompt type DEL <filename> where <filename> is the file you wish to delete.
Go back to Task Manager, click File, New Task and enter EXPLORER.EXE to restart the GUI shell.
Close Task Manager.


Or you can try this

Open Notepad.exe

Click File>Save As..>

locate the folder where ur undeletable file is

Choose 'All files' from the file type box

click once on the file u wanna delete so its name appears in the 'filename' box

put a " at the start and end of the filename
(the filename should have the extension of the undeletable file so it will overwrite it)

click save,

It should ask u to overwrite the existing file, choose yes and u can delete it as normal


Here's a manual way of doing it. I'll take this off once you put into your first post zain.

1. Start
2. Run
3. Type: command
4. To move into a directory type: cd c:\*** (The stars stand for your folder)
5. If you cannot access the folder because it has spaces for example Program Files or Kazaa Lite folder you have to do the following. instead of typing in the full folder name only take the first 6 letters then put a ~ and then 1 without spaces. Example: cd c:\progra~1\kazaal~1
6. Once your in the folder the non-deletable file it in type in dir - a list will come up with everything inside.
7. Now to delete the file type in del ***.bmp, txt, jpg, avi, etc... And if the file name has spaces you would use the special 1st 6 letters followed by a ~ and a 1 rule. Example: if your file name was bad file.bmp you would type once in the specific folder thorugh command, del badfil~1.bmp and your file should be gone. Make sure to type in the correct extension.

Saturday 4 June 2011

Five Exercise Tips for Weight Loss

If you are planning to exercise and gain back the pretty shapes, here are some tips which really help a lot of people to start and keep up with the activity losing weight and getting back in shape:
  • Sport almost always requires a partner. One might not plan to play soccer or basketball, but even simple jogging brings more fun when done with a friend, family member or even neighbor. Remember, that positive emotions are very important in sport. It is also recommended to have a partner in case of weak days. Everybody has times when they want to quit or at least skip one workout, this is the time when a partner is the best stimulant to get up and go even in the day seems windy, rainy and dark or the couch feels too comfortable to be left alone.

  • Competition is another important factor in sport and it also requires a partner. If you have a friend who plans to lose some weight too, keep the charts together and see who does a better job. Sometimes you can find groups of people working on weight loss together. Competition with them will provoke you to do a better job.

  • Make a schedule. It works towards several things: schedules are harder to give up and it is easier to remember the sequence of different activities if they are well set and written.

  • Achievable goals are easier to go to. Maybe the end result should be 10 or 20 pounds, but this is not what one should start with. Think of one pound at first. Intensiveness or length of exercises can also be your goals. Success will help you work toward a greater goal.

  • Think of a gift for achieving the goal. Food should not be one of them because this is exactly the thing that you are trying to reduce. Visit a movie theatre, buy a flower or call your friend and spend a whole evening talking.


Wednesday 4 May 2011

Stored Procedure for backup database in MS-SQL Server


In this stored procedure you have to send parameter to @path variable as your backup location.

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


CREATE PROCEDURE [dbo].[sp_Database_Backup]
@path nvarchar(500)
AS
BEGIN


EXEC master.sys.xp_create_subdir @path
Set @path = @path + '\db_name.bak'
BACKUP DATABASE db_name
TO DISK = @path
  WITH FORMAT;
END

Monday 2 May 2011

Steps for Add Google Maps API Into Website

1. Open http://maps.google.com/ Click on My Maps at Left side


2. Now Click on Get started


3. Now login window will appear. Here you can log in with your gmail ID/Password.


4. Now following screen will appear.


5. Now Search your location for google map script. Right click of mouse where you want to add a placemark and click on “Add a placemark”


6. Now Set the title of your placemark and give address of location in Description.


7. Now Click on Ok button then Click on Link button of right side of your browser screen.


8. Copy the iframe code and paste in your website.

Saturday 9 April 2011

IPL Cricket Match 2011 Schedule (Time Table)


Apr 08 8PM .        Chennai Super Kings vs Kolkata Knight Riders Chennai
Apr 09 4PM .        Deccan Chargers vs Rajasthan Royals Hyderabad
Apr 09 8PM .        Kochi v Royal Challengers Bangalore Kochi
Apr 10 4PM .        Delhi Daredevils vs Mumbai Indians Delhi
Apr 10 8PM .        Pune Warriors vs Kings XI Punjab Navi Mumbai
Apr 11 8PM .        Kolkata Knight Riders vs Deccan Chargers Kolkata
Apr 12 4PM .        Rajasthan Royals vs Delhi Daredevils Jaipur
Apr 12 8PM .        Royal Challengers Bangalore vs Mumbai Indians Bangalore
Apr 13 4PM .        Pune Warriors vs Kochi Navi Mumbai
Apr 13 8PM .        Kings XI Punjab vs Chennai Super Kings Mohali
Apr 14 8PM .        Deccan Chargers vs Royal Challengers Bangalore Hyderabad
Apr 15 4PM .        Mumbai Indians v Kochi Mumbai
Apr 15 8PM .        Delhi Daredevils v Kolkata Knight Riders Delhi
Apr 16 4PM .        Chennai Super Kings v Royal Challengers Bangalore Chennai
Apr 16 8PM .        Deccan Chargers v Kings XI Punjab Hyderabad
Apr 17 4PM .        Rajasthan v Kolkata Knight Riders Jaipur
Apr 17 8PM .        Pune Warriors v Delhi Daredevils Navi Mumbai
Apr 18 8PM .        Kochi v Chennai Super Kings Kochi
Apr 19 4PM .        Delhi Daredevils vs Deccan Chargers Delhi
Apr 19 8PM .        Royal Challengers Bangalore v Rajasthan Royals Bangalore
Apr 20 4PM .        Mumbai Indians v Pune Warriors Mumbai
Apr 20 8PM .        Kolkata Knight Riders v Kochi Kolkata
Apr 21 8PM .        Kings XI Punjab v Rajasthan Royals Mohali
Apr 22 8PM .        Mumbai Indians v Chennai Super Kings Mumbai
Apr 23 4PM .        Kolkata Knight Riders v Royal Challengers Bangalore Kolkata
Apr 23 8PM .        Delhi Daredevils v Kings XI Punjab Delhi
Apr 24 4PM .        Deccan Chargers v Mumbai Indians Hyderabad
Apr 24 8PM .        Rajasthan Royals v Kochi Jaipur
Apr 25 8PM .        Chennai Super Kings v Pune Warriors Chennai
Apr 26 8PM .        Delhi Daredevils v Royal Challengers Bangalore Delhi
Apr 27 4PM .        Pune Warriors v Chennai Super Kings Navi Mumbai
Apr 27 8PM .        Kochi v Deccan Chargers Kochi
Apr 28 4PM .        Kolkata Knight Riders v Kings XI Punjab Kolkata
Apr 28 8PM .        Rajasthan Royals v Mumbai Indians Jaipur
Apr 29 8PM .        Royal Challengers Bangalore v Pune Bangalore
Apr 30 4PM .        Kochi v Delhi Daredevils Kochi
Apr 30 8PM .        Mumbai Indians v Kings XI Punjab Mumbai
May 01 4PM .       Rajasthan Royals v Pune Warriors Jaipur
May 01 8PM .       Chennai Super Kings v Deccan Chargers Chennai
May 02 8PM .       Delhi Daredevils v Kochi Delhi
May 03 8PM .       Deccan Chargers v Kolkata Knight Riders Hyderabad
May 04 4PM .       Chennai Super Kings v Rajasthan Royals Chennai
May 04 8PM .       Pune Warriors v Mumbai Indians Navi Mumbai
May 05 4PM .       Kochi v Kolkata Knight Riders Kochi
May 05 8PM .       Deccan Chargers v Delhi Daredevils Hyderabad
May 06 8PM .       Royal Challengers Bangalore v Kings XI Punjab Bangalore
May 07 4PM .       Kolkata Knight Riders v Chennai Super Kings Kolkata
May 07 8PM .       Mumbai Indians v Delhi Daredevils Mumbai
May 08 4PM .       Royal Challengers Bangalore v Kochi Bangalore
May 08 8PM .       Kings XI Punjab v Pune Warriors Mohali
May 09 8PM .       Rajasthan Royals v Chennai Super Kings Jaipur
May 10 4PM .       Kings XI Punjab v Mumbai Indians Mohali
May 10 8PM .       Deccan Chargers v Pune Warriors Hyderabad
May 11 8PM .       Rajasthan Royals v Royal Challengers Bangalore Jaipur
May 12 8PM .       Chennai Super Kings v Delhi Daredevils Chennai
May 13 8PM .       Kochi v Kings XI Punjab Indore
May 14 4PM .       Mumbai Indians v Deccan Chargers Mumbai
May 14 8PM .       Royal Challengers Bangalore v Kolkata Knight Riders Bangalore
May 15 4PM .       Kings XI Punjab v Delhi Daredevils Dharamsala
May 15 8PM .       Kochi v Rajasthan Royals Indore
May 16 8PM .       Kolkata Knight Riders v Mumbai Indians Kolkata
May 17 8PM .       Pune Warriors v Deccan Chargers Pune
May 18 4PM .       Kings XI Punjab v Royal Challengers Bangalore Dharamsala
May 18 8PM .       Chennai Super Kings v Kochi Chennai
May 19 8PM .       Pune Warriors v Kolkata Knight Riders Pune
May 20 8PM .       Mumbai Indians v Rajasthan Royals Mumbai
May 21 4PM .       Kings XI Punjab v Deccan Chargers Dharamsala
May 21 8PM .       Delhi Daredevils v Pune Warriors Delhi
May 22 4PM .       Royal Challengers Bangalore v Chennai Super Kings Bangalore
May 22 8PM .       Kolkata Knight Riders v Rajasthan Royals Kolkata

May 24            8PM .              Qualifier 1 Mumbai
May 25            8PM .              Eliminator Mumbai
May 27            8PM .              Qualifier 2 Chennai

May          28 8PM .           Final Chennai


Sunday 3 April 2011

Websites for Online Earning by click on Ads



twodollarclick.com

neodollar.com


neobux.com


onbux.com


infinitybux.com


Coloursbux.com


TenAdsPlus.com


BirdyBux.com


IncraseBux.com



Saturday 2 April 2011

Top 10 interview question for Oracle PL/SQL ?


1.          How can delete duplicate rows from table ?
Delete from table_name where rowid not in( Select max(rowid) from table_name
Group by duplicate_value_fields)

2.          How can find Max 5th Salary from Salary table ?
Select * From (Select Column1, Column2 from table_name
Order by Column_Name) Where rownum <=5)

3.          What is NVL function into Oracle ?
In Oracle PL/SQL, the NVL function lets us substitute a value when a null value is encountered.
The syntax of NVL function is:
NVL( str1, replaceWith )
str1 is the string to test for a null value.
replaceWith is the value returned if str1 is null.

4.          What is Triggers ?
Triggers are similar to procedures, in that they are named PL/SQL blocks with declarative, executable, and exception-handling sections. However, a procedure is executed explicitly from another block via a procedure call, with can also pass arguments. A trigger is executed implicitly whenever the triggering event happens, and a trigger doesn’t accept arguments. The act of executing a trigger is known as firing the trigger. The triggering event is a DML (INSERT, UPDATE, or DELETE) operation on database table.

Triggers can be used for many things, including
§ Maintaining complex integrity constraints not possible through declarative constraints enabled at table creation
§ Auditing information in a table by recording the changes made and who made them
§ Automatically signaling other programs that action needs to take place when changes are made to a table

5.       What is Synonyms ?
Table references can be complicated, especially if a schema and/or database link is included. In order to make maintenance easier, Oracle allows you to create a synonym for a complicated reference. The synonym essentially renames the table reference, similar to an alias for a select list item. However, a synonym is a data dictionary object and is created by the CREATE SYNONYM DDL statement:
            CREATE SYNONYM synonym_name FOR reference;

6.       What is Cursor ?
A cursor is a handle, or pointer, to the context area. Through the cursor, a PL/SQL program can control the context area and what happens to it as the statements is processed. Types of cursor
§     Explicit cursor (%Found, %NotFound, %RowCount & %IsOpen)
§     Implicit cursor (%Found, %NotFound, %RowCount & %IsOpen)

7.       What is Identifiers ?
Identifiers are used to name PL/SQL objects, such as variables, cursors, and subprograms. Identifiers consist of a letter optionally followed by any sequence of characters including letters, numbers, dollar signs, underscores, and pound signs. Other characters are illegal. The maximum length for an identifier is 30 characters, and all characters are significant. For example
X
V_studentId
TempVar

8.       What is View ?
A simple view can be thought of as a subset of a table. It can be used for retrieving data, as well as updating or deleting rows.
      Example
CREATE VIEW v_Emp
AS SELECT First_Name, Last_Name, Phone, Country
FROM Emp_Master

9.       What is Sign Function ?
Its’ check the numeric value and return followings:
                     1 – for Positive value
                     0 – for Zero
                   -1 – for Negative value

10.   Exceptions into PL/SQL ?
1.       Too_many_rows
2.       No_data_found
3.       Value_Error
4.       Zero_Error
5.       Others

Friday 25 March 2011

Windows Shortcuts


Run Commands:

Quote:
compmgmt.msc - Computer management
devmgmt.msc - Device manager
diskmgmt.msc - Disk management
dfrg.msc - Disk defrag
eventvwr.msc - Event viewer
fsmgmt.msc - Shared folders
gpedit.msc - Group policies
lusrmgr.msc - Local users and groups
perfmon.msc - Performance monitor
rsop.msc - Resultant set of policies
secpol.msc - Local security settings
services.msc - Various Services
msconfig - System Configuration Utility
regedit - Registry Editor
msinfo32 _ System Information
sysedit _ System Edit
win.ini _ windows loading information(also system.ini)
winver _ Shows current version of windows
mailto: _ Opens default email client
command _ Opens command prompt


Run Commands to access the control panel:

Quote:
Add/Remove Programs control appwiz.cpl
Date/Time Properties control timedate.cpl
Display Properties control desk.cpl
FindFast control findfast.cpl
Fonts Folder control fonts
Internet Properties control inetcpl.cpl
Keyboard Properties control main.cpl keyboard
Mouse Properties control main.cpl
Multimedia Properties control mmsys.cpl
Network Properties control netcpl.cpl
Password Properties control password.cpl
Printers Folder control printers
Sound Properties control mmsys.cpl sounds
System Properties control sysdm.cpl



Command Prompt:

Quote:
ANSI.SYS Defines functions that change display graphics, control cursor movement, and reassign keys.
APPEND Causes MS-DOS to look in other directories when editing a file or running a command.
ARP Displays, adds, and removes arp information from network devices.
ASSIGN Assign a drive letter to an alternate letter.
ASSOC View the file associations.
AT Schedule a time to execute commands or programs.
ATMADM Lists connections and addresses seen by Windows ATM call manager.
ATTRIB Display and change file attributes.
BATCH Recovery console command that executes a series of commands in a file.
BOOTCFG Recovery console command that allows a user to view, modify, and rebuild the boot.ini
BREAK Enable / disable CTRL + C feature.
CACLS View and modify file ACL's.
CALL Calls a batch file from another batch file.
CD Changes directories.
CHCP Supplement the International keyboard and character set information.
CHDIR Changes directories.
CHKDSK Check the hard disk drive running FAT for errors.
CHKNTFS Check the hard disk drive running NTFS for errors.
CHOICE Specify a listing of multiple options within a batch file.
CLS Clears the screen.
CMD Opens the command interpreter.
COLOR Easily change the foreground and background color of the MS-DOS window.
COMP Compares files.
COMPACT Compresses and uncompress files.
CONTROL Open control panel icons from the MS-DOS prompt.
CONVERT Convert FAT to NTFS.
COPY Copy one or more files to an alternate location.
CTTY Change the computers input/output devices.
DATE View or change the systems date.
DEBUG Debug utility to create assembly programs to modify hardware settings.
DEFRAG Re-arrange the hard disk drive to help with loading programs.
DEL Deletes one or more files.
DELETE Recovery console command that deletes a file.
DELTREE Deletes one or more files and/or directories.
DIR List the contents of one or more directory.
DISABLE Recovery console command that disables Windows system services or drivers.
DISKCOMP Compare a disk with another disk.
DISKCOPY Copy the contents of one disk and place them on another disk.
DOSKEY Command to view and execute commands that have been run in the past.
DOSSHELL A GUI to help with early MS-DOS users.
DRIVPARM Enables overwrite of original device drivers.
ECHO Displays messages and enables and disables echo.
EDIT View and edit files.
EDLIN View and edit files.
EMM386 Load extended Memory Manager.
ENABLE Recovery console command to enable a disable service or driver.
ENDLOCAL Stops the localization of the environment changes enabled by the setlocal command.
ERASE Erase files from computer.
EXIT Exit from the command interpreter.
EXPAND Expand a M*cros*ft Windows file back to it's original format.
EXTRACT Extract files from the M*cros*ft Windows cabinets.
FASTHELP Displays a listing of MS-DOS commands and information about them.
FC Compare files.
FDISK Utility used to create partitions on the hard disk drive.
FIND Search for text within a file.
FINDSTR Searches for a string of text within a file.
FIXBOOT Writes a new boot sector.
FIXMBR Writes a new boot record to a disk drive.
FOR Boolean used in batch files.
FORMAT Command to erase and prepare a disk drive.
FTP Command to connect and operate on a FTP server.
FTYPE Displays or modifies file types used in file extension associations.
GOTO Moves a batch file to a specific label or location.
GRAFTABL Show extended characters in graphics mode.
HELP Display a listing of commands and brief explanation.
IF Allows for batch files to perform conditional processing.
IFSHLP.SYS 32-bit file manager.
IPCONFIG Network command to view network adapter settings and assigned values.
KEYB Change layout of keyboard.
LABEL Change the label of a disk drive.
LH Load a device driver in to high memory.
LISTSVC Recovery console command that displays the services and drivers.
LOADFIX Load a program above the first 64k.
LOADHIGH Load a device driver in to high memory.
LOCK Lock the hard disk drive.
LOGON Recovery console command to list installations and enable administrator login.
MAP Displays the device name of a drive.
MD Command to create a new directory.
MEM Display memory on system.
MKDIR Command to create a new directory.
MODE Modify the port or display settings.
MORE Display one page at a time.
MOVE Move one or more files from one directory to another directory.
MSAV Early M*cros*ft Virus scanner.
MSD Diagnostics utility.
MSCDEX Utility used to load and provide access to the CD-ROM.
NBTSTAT Displays protocol statistics and current TCP/IP connections using NBT
NET Update, fix, or view the network or network settings
NETSH Configure dynamic and static network information from MS-DOS.
NETSTAT Display the TCP/IP network protocol statistics and information.
NLSFUNC Load country specific information.
NSLOOKUP Look up an IP address of a domain or host on a network.
PATH View and modify the computers path location.
PATHPING View and locate locations of network latency.
PAUSE Command used in batch files to stop the processing of a command.
PING Test / send information to another network computer or network device.
POPD Changes to the directory or network path stored by the pushd command.
POWER Conserve power with computer portables.
PRINT Prints data to a printer port.
PROMPT View and change the MS-DOS prompt.
PUSHD Stores a directory or network path in memory so it can be returned to at any time.
QBASIC Open the QBasic.
RD Removes an empty directory.
REN Renames a file or directory.
RENAME Renames a file or directory.
RMDIR Removes an empty directory.
ROUTE View and configure windows network route tables.
RUNAS Enables a user to execute a program on another computer.
SCANDISK Run the scandisk utility.
SCANREG Scan registry and recover registry from errors.
SET Change one variable or string to another.
SETLOCAL Enables local environments to be changed without affecting anything else.
SETVER Change MS-DOS version to trick older MS-DOS programs.
SHARE Installs support for file sharing and locking capabilities.
SHIFT Changes the position of replaceable parameters in a batch program.
SHUTDOWN Shutdown the computer from the MS-DOS prompt.
SMARTDRV Create a disk cache in conventional memory or extended memory.
SORT Sorts the input and displays the output to the screen.
START Start a separate window in Windows from the MS-DOS prompt.
SUBST Substitute a folder on your computer for another drive letter.
SWITCHES Remove add functions from MS-DOS.
SYS Transfer system files to disk drive.
TELNET Telnet to another computer / device from the prompt.
TIME View or modify the system time.
TITLE Change the title of their MS-DOS window.
TRACERT Visually view a network packets route across a network.
TREE View a visual tree of the hard disk drive.
TYPE Display the contents of a file.
UNDELETE Undelete a file that has been deleted.
UNFORMAT Unformat a hard disk drive.
UNLOCK Unlock a disk drive.
VER Display the version information.
VERIFY Enables or disables the feature to determine if files have been written properly.
VOL Displays the volume information about the designated drive.
XCOPY Copy multiple files, directories, and/or drives from one location to another.
TRUENAME When placed before a file, will display the whole directory in which it exists
TASKKILL It allows you to kill those unneeded or locked up applications




Windows XP Shortcuts:

Quote:
ALT+- (ALT+hyphen) Displays the Multiple Document Interface (MDI) child window's System menu
ALT+ENTER View properties for the selected item
ALT+ESC Cycle through items in the order they were opened
ALT+F4 Close the active item, or quit the active program
ALT+SPACEBAR Display the System menu for the active window
ALT+TAB Switch between open items
ALT+Underlined letter Display the corresponding menu
BACKSPACE View the folder one level up in My Computer or Windows Explorer
CTRL+A Select all
CTRL+B Bold
CTRL+C Copy
CTRL+I Italics
CTRL+O Open an item
CTRL+U Underline
CTRL+V Paste
CTRL+X Cut
CTRL+Z Undo
CTRL+F4 Close the active document
CTRL while dragging Copy selected item
CTRL+SHIFT while dragging Create shortcut to selected iteM
CTRL+RIGHT ARROW Move the insertion point to the beginning of the next word
CTRL+LEFT ARROW Move the insertion point to the beginning of the previous word
CTRL+DOWN ARROW Move the insertion point to the beginning of the next paragraph
CTRL+UP ARROW Move the insertion point to the beginning of the previous paragraph
SHIFT+DELETE Delete selected item permanently without placing the item in the Recycle Bin
ESC Cancel the current task
F1 Displays Help
F2 Rename selected item
F3 Search for a file or folder
F4 Display the Address bar list in My Computer or Windows Explorer
F5 Refresh the active window
F6 Cycle through screen elements in a window or on the desktop
F10 Activate the menu bar in the active program
SHIFT+F10 Display the shortcut menu for the selected item
CTRL+ESC Display the Start menu
SHIFT+CTRL+ESC Launches Task Manager
SHIFT when you insert a CD Prevent the CD from automatically playing
WIN Display or hide the Start menu
WIN+BREAK Display the System Properties dialog box
WIN+D Minimizes all Windows and shows the Desktop
WIN+E Open Windows Explorer
WIN+F Search for a file or folder
WIN+F+CTRL Search for computers
WIN+L Locks the desktop
WIN+M Minimize or restore all windows
WIN+R Open the Run dialog box
WIN+TAB Switch between open items




Windows Explorer Shortcuts:

Quote:
ALT+SPACEBAR - Display the current window’s system menu
SHIFT+F10 - Display the item's context menu
CTRL+ESC - Display the Start menu
ALT+TAB - Switch to the window you last used
ALT+F4 - Close the current window or quit
CTRL+A - Select all items
CTRL+X - Cut selected item(s)
CTRL+C - Copy selected item(s)
CTRL+V - Paste item(s)
CTRL+Z - Undo last action
CTRL+(+) - Automatically resize the columns in the right hand pane
TAB - Move forward through options
ALT+RIGHT ARROW - Move forward to a previous view
ALT+LEFT ARROW - Move backward to a previous view
SHIFT+DELETE - Delete an item immediately
BACKSPACE - View the folder one level up
ALT+ENTER - View an item’s properties
F10 - Activate the menu bar in programs
F6 - Switch between left and right panes
F5 - Refresh window contents
F3 - Display Find application
F2 - Rename selected item




Internet Explorer Shortcuts:

Quote:
CTRL+A - Select all items on the current page
CTRL+D - Add the current page to your Favorites
CTRL+E - Open the Search bar
CTRL+F - Find on this page
CTRL+H - Open the History bar
CTRL+I - Open the Favorites bar
CTRL+N - Open a new window
CTRL+O - Go to a new location
CTRL+P - Print the current page or active frame
CTRL+S - Save the current page
CTRL+W - Close current browser window
CTRL+ENTER - Adds the http://www. (url) .com
SHIFT+CLICK - Open link in new window
BACKSPACE - Go to the previous page
ALT+HOME - Go to your Home page
HOME - Move to the beginning of a document
TAB - Move forward through items on a page
END - Move to the end of a document
ESC - Stop downloading a page
F11 - Toggle full-screen view
F5 - Refresh the current page
F4 - Display list of typed addresses
F6 - Change Address bar and page focus
ALT+RIGHT ARROW - Go to the next page
SHIFT+CTRL+TAB - Move back between frames
SHIFT+F10 - Display a shortcut menu for a link
SHIFT+TAB - Move back through the items on a page
CTRL+TAB - Move forward between frames
CTRL+C - Copy selected items to the clipboard
CTRL+V - Insert contents of the clipboard
ENTER - Activate a selected link
HOME - Move to the beginning of a document
END - Move to the end of a document
F1 - Display Internet Explorer Help

How to Back Up the Registry


Before you edit the registry, export the keys in the registry that you plan to edit, or back up the whole registry. If a problem occurs, you can then follow the steps how-to restore the registry to its previous state.


How to Export Registry Keys

Click Start, and then click Run.

In the Open box, type regedit, and then click OK.

On the File menu, click Export.

In the Save in box, select the boxs at the bottom the bottom according to weather you want to export all or only selected branches of the registry.

Next select a location in which to save the backup .reg file. In the File name box, type a file name, and then click Save.


How to Restore the Registry

To restore registry keys that you exported, double-click the .reg file that you saved.

Sunday 20 February 2011

India v Bangladesh ICC Cricket World Cup 2011 / Scorecard


ICC Cricket World Cup - 1st match, Group B
Bangladesh v India
India won by 87 runs
ODI no. 3100 | 2010/11 season
Played at Shere Bangla National Stadium,
Mirpur
19 February 2011 - day/night (50-over match)

India innings (50 overs maximum)                                               R          B          4s         6s         SR
V Sehwag              b Shakib Al Hasan                                               175         140          14            5              125.00
SR Tendulkar       run out (Shakib Al Hasan/Mushfiqur Rahim)       28           29            4              0              96.55
G Gambhir            b Mahmudullah                                                    39           39            3              0              100.00
V Kohli                   not out                                                                100         83            8              2              120.48
YK Pathan             c Mushfiqur Rahim b Shafiul Islam                      8              10            0              0              80.00
Extras                      (b 1, lb 2, w 16, nb 1)                                        20
Total                      (4 wickets; 50 overs)                                          370         (7.40 runs per over)

Did not bat Yuvraj Singh, MS Dhoni*†, Harbhajan Singh, Z Khan, S Sreesanth, MM Patel

Fall of wickets 1-69 (Tendulkar, 10.5 ov), 2-152 (Gambhir, 23.2 ov), 3-355 (Sehwag, 47.3 ov), 4-370 (Pathan, 49.6 ov)

Bowling                                    O          M         R          W         Econ
Shafiul Islam                                        7              0              69            1              9.85         (1nb, 2w)
Rubel Hossain                                      10            0              60            0              6.00         (5w)
Abdur Razzak                                      9              0              74            0              8.22         (1w)
Shakib Al Hasan                                  10            0              61            1              6.10         (3w)
Naeem Islam                                       7              0              54            0              7.71
Mahmudullah                                       7              0              49            1              7.00         (3w)

Bangladesh innings (target: 371 runs from 50 overs)            R          B          4s         6s         SR
Tamim Iqbal                        c Yuvraj Singh b Patel                      70           86              3              1              81.39
Imrul Kayes                         b Patel                                              34           29             7              0              117.24
Junaid Siddique                    st †Dhoni b Harbhajan Singh          37           52             1              1              71.15
Shakib Al Hasan*                c Harbhajan Singh b Pathan            55           50             5              0              110.00
Mushfiqur Rahim                c sub (SK Raina) b Khan                   25           30             2              0              83.33
Raqibul Hasan                     not out                                             28           28            0              1              100.00
Mahmudullah                      b Patel                                              6              6              0              0              100.00
Naeem Islam                      lbw b Patel                                        2              8              0              0              25.00
Abdur Razzak                     lbw b Khan                                        1              5              0              0              20.00
Shafiul Islam                      run out (Harbhajan Singh)                0              1              0              0              0.00
Rubel Hossain                   not out                                               1              6              0              0              16.66
Extras                                   (lb 10, w 13, nb 1)                             24
Total (9 wickets; 50 overs)                                                            283         (5.66 runs per over)

Fall of wickets 1-56 (Imrul Kayes, 6.5 ov), 2-129 (Junaid Siddique, 23.1 ov), 3-188 (Tamim Iqbal, 32.1 ov),
4-234 (Shakib Al Hasan, 39.4 ov), 5-248 (Mushfiqur Rahim, 42.3 ov), 6-261 (Mahmudullah, 44.3 ov),
7-275 (Naeem Islam, 46.3 ov), 8-279 (Abdur Razzak, 47.6 ov), 9-280 (Shafiul Islam, 48.3 ov)

Bowling                                    O          M         R          W         Econ
S Sreesanth                                         5               0              53            0              10.60       (1nb, 1w)
Z Khan                                                   10             0              40            2              4.00         (4w)
MM Patel                                              10             0              48            4              4.80
Harbhajan Singh                                10             0              41            1              4.10         (1w)
YK Pathan                                             8              0              49            1              6.12         (2w)
Yuvraj Singh                                        7              0              42            0              6.00         (1w)

Match details
Toss Bangladesh, who chose to field
Points India 2, Bangladesh 0

Player of the match V Sehwag (India)

Umpires SJ Davis (Australia) and HDPK Dharmasena (Sri Lanka)
TV umpire BR Doctrove (West Indies)
Match referee RS Madugalle (Sri Lanka)
Reserve umpire Asad Rauf (Pakistan)