Showing posts with label Microsoft. Show all posts
Showing posts with label Microsoft. Show all posts

11/22/13

Posted by Doddy Prima
0 Comments
,

Windows Keyboard Shotcuts




Keyboard Shorcuts (Microsoft Windows) 
1. CTRL+C (Copy) 
2. CTRL+X (Cut) 
3. CTRL+V (Paste) 
4. CTRL+Z (Undo) 
5. DELETE (Delete) 
6. SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin) 
7. CTRL while dragging an item (Copy the selected item) 
8. CTRL+SHIFT while dragging an item (Create a shortcut to the selected item) 
9. F2 key (Rename the selected item) 
10. CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word) 
11. CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word) 
12. CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph) 
13. CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph) 
14. CTRL+SHIFT with any of the arrow keys (Highlight a block of text) SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document) 
15. CTRL+A (Select all) 
16. F3 key (Search for a file or a folder) 
17. ALT+ENTER (View the properties for the selected item) 
18. ALT+F4 (Close the active item, or quit the active program) 
19. ALT+ENTER (Display the properties of the selected object) 
20. ALT+SPACEBAR (Open the shortcut menu for the active window) 
21. CTRL+F4 (Close the active document in programs that enable you to have multiple documents opensimultaneou sly) 
22. ALT+TAB (Switch between the open items) 
23. ALT+ESC (Cycle through items in the order that they had been opened)
24. F6 key (Cycle through the screen elements in a window or on the desktop) 
25. F4 key (Display the Address bar list in My Computer or Windows Explorer) 
26. SHIFT+F10 (Display the shortcut menu for the selected item) 27. ALT+SPACEBAR (Display the System menu for the active window) 
28. CTRL+ESC (Display the Start menu) 
29. ALT+Underlined letter in a menu name (Display the corresponding menu) Underlined letter in a command name on an open menu (Perform the corresponding command) 
30. F10 key (Activate the menu bar in the active program) 
31. RIGHT ARROW (Open the next menu to the right, or open a submenu) 
32. LEFT ARROW (Open the next menu to the left, or close a submenu) 
33. F5 key (Update the active window) 
34. BACKSPACE (View the folder onelevel up in My Computer or Windows Explorer) 
35. ESC (Cancel the current task) 
36. SHIFT when you insert a CD- ROMinto the CD-ROM drive (Prevent the CD-ROM from automatically playing) 

Dialog Box - Keyboard Shortcuts 

1. CTRL+TAB (Move forward through the tabs) 
2. CTRL+SHIFT+TAB (Move backward through the tabs) 
3. TAB (Move forward through the options) 
4. SHIFT+TAB (Move backward through the options) 
5. ALT+Underlined letter (Perform the corresponding command or select the corresponding option) 
6. ENTER (Perform the command for the active option or button) 
7. SPACEBAR (Select or clear the check box if the active option is a check box) 
8. Arrow keys (Select a button if the active option is a group of option buttons) 
9. F1 key (Display Help) 
10. F4 key (Display the items in the active list) 
11. BACKSPACE (Open a folder one level up if a folder is selected in the Save As or Open dialog box) 

Microsoft Natural Keyboard Shortcuts 
1. Windows Logo (Display or hide the Start menu) 
2. Windows Logo+BREAK (Display the System Properties dialog box) 
3. Windows Logo+D (Display the desktop) 
4. Windows Logo+M (Minimize all of the windows) 
5. Windows Logo+SHIFT+M (Restorethe minimized windows) 
6. Windows Logo+E (Open My Computer) 
7. Windows Logo+F (Search for a file or a folder) 
8. CTRL+Windows Logo+F (Search for computers) 
9. Windows Logo+F1 (Display Windows Help) 
10. Windows Logo+ L (Lock the keyboard) 
11. Windows Logo+R (Open the Run dialog box) 
12. Windows Logo+U (Open Utility Manager) 
13. Accessibility Keyboard Shortcuts 
14. Right SHIFT for eight seconds (Switch FilterKeys either on or off) 
15. Left ALT+left SHIFT+PRINT SCREEN (Switch High Contrast either on or off) 
16. Left ALT+left SHIFT+NUM LOCK (Switch the MouseKeys either on or off)
17. SHIFT five times (Switch the StickyKeys either on or off) 
18. NUM LOCK for five seconds (Switch the ToggleKeys either on or off) 
19. Windows Logo +U (Open Utility Manager) 
20. Windows Explorer Keyboard Shortcuts 
21. END (Display the bottom of the active window) 
22. HOME (Display the top of the active window) 
23. NUM LOCK+Asterisk sign (*) (Display all of the subfolders that are under the selected folder) 
24. NUM LOCK+Plus sign (+) (Display the contents of the selected folder) 

MMC COnsole Windows Shortcut keys 
1. SHIFT+F10 (Display the Action shortcut menu for the selected item) 
2. F1 key (Open the Help topic, if any, for the selected item) 
3. F5 key (Update the content of all console windows) 
4. CTRL+F10 (Maximize the active console window) 
5. CTRL+F5 (Restore the active console window) 
6. ALT+ENTER (Display the Properties dialog box, if any, for theselected item) 
7. F2 key (Rename the selected item) 
8. CTRL+F4 (Close the active console window. When a console has only one console window, this shortcut closes the console) 

Remote Desktop Connection Navigation 
1. CTRL+ALT+END (Open the Microsoft Windows NT Security dialog box) 
2. ALT+PAGE UP (Switch between programs from left to right) 
3. ALT+PAGE DOWN (Switch between programs from right to left) 4. ALT+INSERT (Cycle through the programs in most recently used order) 
5. ALT+HOME (Display the Start menu) 
6. CTRL+ALT+BREAK (Switch the client computer between a window and a full screen) 
7. ALT+DELETE (Display the Windows menu) 
8. CTRL+ALT+Minus sign (-) (Place a snapshot of the active window in the client on the Terminal server clipboard and provide the same functionality as pressing PRINT SCREEN on a local computer.) 
9. CTRL+ALT+Plus sign (+) (Place asnapshot of the entire client window area on the Terminal server clipboardand provide the same functionality aspressing ALT+PRINT SCREEN on a local computer.) 

Microsoft Internet Explorer Keyboard Shortcuts 
1. CTRL+B (Open the Organize Favorites dialog box) 
2. CTRL+E (Open the Search bar) 
3. CTRL+F (Start the Find utility) 
4. CTRL+H (Open the History bar) 
5. CTRL+I (Open the Favorites bar) 
6. CTRL+L (Open the Open dialog box) 
7. CTRL+N (Start another instance of the browser with the same Web address) 
8. CTRL+O (Open the Open dialog box,the same as CTRL+L) 
9. CTRL+P (Open the Print dialog box) 
10. CTRL+R (Update the current Web )

9/11/13

Posted by Doddy Prima
0 Comments
,

SQL Server - Date Formats




SQL Server Date Formats

One of the most frequently asked questions in SQL Server forums is how to format a datetime value or column into a specific date format.  Here's a summary of the different date formats that come standard in SQL Server as part of the CONVERT function.  Following the standard date formats are some extended date formats that are often asked by SQL Server developers.

It is worth to note that the output of these date formats are of VARCHAR data types already and not of DATETIME data type.  With this in mind, any date comparisons performed after the datetime value has been formatted are using the VARCHAR value of the date and time and not its original DATETIME value.


Standard Date Formats
Date FormatStandardSQL StatementSample Output
Mon DD YYYY 1
HH:MIAM (or PM)		DefaultSELECT CONVERT(VARCHAR(20), GETDATE(), 100)Jan 1 2005 1:29PM 1
MM/DD/YYUSASELECT CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY]11/23/98
MM/DD/YYYYUSASELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS [MM/DD/YYYY]11/23/1998
YY.MM.DDANSISELECT CONVERT(VARCHAR(8), GETDATE(), 2) AS [YY.MM.DD]72.01.01
YYYY.MM.DDANSISELECT CONVERT(VARCHAR(10), GETDATE(), 102) AS [YYYY.MM.DD]1972.01.01
DD/MM/YYBritish/FrenchSELECT CONVERT(VARCHAR(8), GETDATE(), 3) AS [DD/MM/YY]19/02/72
DD/MM/YYYYBritish/FrenchSELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY]19/02/1972
DD.MM.YYGermanSELECT CONVERT(VARCHAR(8), GETDATE(), 4) AS [DD.MM.YY]25.12.05
DD.MM.YYYYGermanSELECT CONVERT(VARCHAR(10), GETDATE(), 104) AS [DD.MM.YYYY]25.12.2005
DD-MM-YYItalianSELECT CONVERT(VARCHAR(8), GETDATE(), 5) AS [DD-MM-YY]24-01-98
DD-MM-YYYYItalianSELECT CONVERT(VARCHAR(10), GETDATE(), 105) AS [DD-MM-YYYY]24-01-1998
DD Mon YY 1-SELECT CONVERT(VARCHAR(9), GETDATE(), 6) AS [DD MON YY]04 Jul 06 1
DD Mon YYYY 1-SELECT CONVERT(VARCHAR(11), GETDATE(), 106) AS [DD MON YYYY]04 Jul 2006 1
Mon DD, YY 1-SELECT CONVERT(VARCHAR(10), GETDATE(), 7) AS [Mon DD, YY]Jan 24, 98 1
Mon DD, YYYY 1-SELECT CONVERT(VARCHAR(12), GETDATE(), 107) AS [Mon DD, YYYY]Jan 24, 1998 1
HH:MM:SS-SELECT CONVERT(VARCHAR(8), GETDATE(), 108)03:24:53
Mon DD YYYY HH:MI:SS:MMMAM (or PM) 1Default +
milliseconds		SELECT CONVERT(VARCHAR(26), GETDATE(), 109)Apr 28 2006 12:32:29:253PM 1
MM-DD-YYUSASELECT CONVERT(VARCHAR(8), GETDATE(), 10) AS [MM-DD-YY]01-01-06
MM-DD-YYYYUSASELECT CONVERT(VARCHAR(10), GETDATE(), 110) AS [MM-DD-YYYY]01-01-2006
YY/MM/DD-SELECT CONVERT(VARCHAR(8), GETDATE(), 11) AS [YY/MM/DD]98/11/23
YYYY/MM/DD-SELECT CONVERT(VARCHAR(10), GETDATE(), 111) AS [YYYY/MM/DD]1998/11/23
YYMMDDISOSELECT CONVERT(VARCHAR(6), GETDATE(), 12) AS [YYMMDD]980124
YYYYMMDDISOSELECT CONVERT(VARCHAR(8), GETDATE(), 112) AS [YYYYMMDD]19980124
DD Mon YYYY HH:MM:SS:MMM(24h) 1Europe default + millisecondsSELECT CONVERT(VARCHAR(24), GETDATE(), 113)28 Apr 2006 00:34:55:190 1
HH:MI:SS:MMM(24H)-SELECT CONVERT(VARCHAR(12), GETDATE(), 114) AS [HH:MI:SS:MMM(24H)]11:34:23:013
YYYY-MM-DD HH:MI:SS(24h)ODBC CanonicalSELECT CONVERT(VARCHAR(19), GETDATE(), 120)1972-01-01 13:42:24
YYYY-MM-DD HH:MI:SS.MMM(24h)ODBC Canonical
(with milliseconds)		SELECT CONVERT(VARCHAR(23), GETDATE(), 121)1972-02-19 06:35:24.489
YYYY-MM-DDTHH:MM:SS:MMMISO8601SELECT CONVERT(VARCHAR(23), GETDATE(), 126)1998-11-23T11:25:43:250
DD Mon YYYY HH:MI:SS:MMMAM 1KuwaitiSELECT CONVERT(VARCHAR(26), GETDATE(), 130)28 Apr 2006 12:39:32:429AM 1
DD/MM/YYYY HH:MI:SS:MMMAMKuwaitiSELECT CONVERT(VARCHAR(25), GETDATE(), 131)28/04/2006 12:39:32:429AM
Here are some more date formats that does not come standard in SQL Server as part of the CONVERT function.
Extended Date Formats
Date FormatSQL StatementSample Output
YY-MM-DD
SELECT SUBSTRING(CONVERT(VARCHAR(10), GETDATE(), 120), 3, 8) AS [YY-MM-DD]
SELECT REPLACE(CONVERT(VARCHAR(8), GETDATE(), 11), '/', '-') AS [YY-MM-DD]
99-01-24
YYYY-MM-DD
SELECT CONVERT(VARCHAR(10), GETDATE(), 120) AS [YYYY-MM-DD]
SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 111), '/', '-') AS [YYYY-MM-DD]
1999-01-24
MM/YYSELECT RIGHT(CONVERT(VARCHAR(8), GETDATE(), 3), 5) AS [MM/YY]
SELECT SUBSTRING(CONVERT(VARCHAR(8), GETDATE(), 3), 4, 5) AS [MM/YY]		08/99
MM/YYYYSELECT RIGHT(CONVERT(VARCHAR(10), GETDATE(), 103), 7) AS [MM/YYYY]12/2005
YY/MMSELECT CONVERT(VARCHAR(5), GETDATE(), 11) AS [YY/MM]99/08
YYYY/MMSELECT CONVERT(VARCHAR(7), GETDATE(), 111) AS [YYYY/MM]2005/12
Month DD, YYYY 1SELECT DATENAME(MM, GETDATE()) + RIGHT(CONVERT(VARCHAR(12), GETDATE(), 107), 9) AS [Month DD, YYYY]July 04, 20061
Mon YYYY1SELECT SUBSTRING(CONVERT(VARCHAR(11), GETDATE(), 113), 4, 8) AS [Mon YYYY]Apr 2006 1
Month YYYY 1SELECT DATENAME(MM, GETDATE()) + ' ' + CAST(YEAR(GETDATE()) AS VARCHAR(4)) AS [Month YYYY]February 2006 1
DD Month1SELECT CAST(DAY(GETDATE()) AS VARCHAR(2)) + ' ' + DATENAME(MM, GETDATE()) AS [DD Month]11 September 1
Month DD1SELECT DATENAME(MM, GETDATE()) + ' ' + CAST(DAY(GETDATE()) AS VARCHAR(2)) AS [Month DD]September 11 1
DD Month YY 1SELECT CAST(DAY(GETDATE()) AS VARCHAR(2)) + ' ' + DATENAME(MM, GETDATE()) + ' ' + RIGHT(CAST(YEAR(GETDATE()) AS VARCHAR(4)), 2) AS [DD Month YY]19 February 72 1
DD Month YYYY 1SELECT CAST(DAY(GETDATE()) AS VARCHAR(2)) + ' ' + DATENAME(MM, GETDATE()) + ' ' + CAST(YEAR(GETDATE()) AS VARCHAR(4)) AS [DD Month YYYY]11 September 2002 1
MM-YYSELECT RIGHT(CONVERT(VARCHAR(8), GETDATE(), 5), 5) AS [MM-YY]
SELECT SUBSTRING(CONVERT(VARCHAR(8), GETDATE(), 5), 4, 5) AS [MM-YY]		12/92
MM-YYYYSELECT RIGHT(CONVERT(VARCHAR(10), GETDATE(), 105), 7) AS [MM-YYYY]05-2006
YY-MMSELECT RIGHT(CONVERT(VARCHAR(7), GETDATE(), 120), 5) AS [YY-MM]
SELECT SUBSTRING(CONVERT(VARCHAR(10), GETDATE(), 120), 3, 5) AS [YY-MM]		92/12
YYYY-MMSELECT CONVERT(VARCHAR(7), GETDATE(), 120) AS [YYYY-MM]2006-05
MMDDYYSELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 1), '/', '') AS [MMDDYY]122506
MMDDYYYYSELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 101), '/', '') AS [MMDDYYYY]12252006
DDMMYYSELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 3), '/', '') AS [DDMMYY]240702
DDMMYYYYSELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 103), '/', '') AS [DDMMYYYY]24072002
Mon-YY 1SELECT REPLACE(RIGHT(CONVERT(VARCHAR(9), GETDATE(), 6), 6), ' ', '-') AS [Mon-YY]Sep-02 1
Mon-YYYY1SELECT REPLACE(RIGHT(CONVERT(VARCHAR(11), GETDATE(), 106), 8), ' ', '-') AS [Mon-YYYY]Sep-2002 1
DD-Mon-YY 1SELECT REPLACE(CONVERT(VARCHAR(9), GETDATE(), 6), ' ', '-') AS [DD-Mon-YY]25-Dec-05 1
DD-Mon-YYYY 1SELECT REPLACE(CONVERT(VARCHAR(11), GETDATE(), 106), ' ', '-') AS [DD-Mon-YYYY]25-Dec-20051
1 To make the month name in upper case, simply use the UPPER string function.
source: http://www.sql-server-helper.com/tips/date-formats.aspx

5/30/12

Posted by Doddy Prima
0 Comments
,

Displays a list of files and subdirectories in a directory


Example : DIR  /C /O:N > filename.txt
->get list of files with file size and put into text file

enjoy IT.


DIR [drive:][path][filename] [/A[[:]attributes]] [/B] [/C] [/D] [/L] [/N]
  [/O[[:]sortorder]] [/P] [/Q] [/R] [/S] [/T[[:]timefield]] [/W] [/X] [/4]

  [drive:][path][filename]
              Specifies drive, directory, and/or files to list.

  /A          Displays files with specified attributes.
  attributes   D  Directories                R  Read-only files
               H  Hidden files               A  Files ready for archiving
               S  System files               I  Not content indexed files
               L  Reparse Points             -  Prefix meaning not
  /B          Uses bare format (no heading information or summary).
  /C          Display the thousand separator in file sizes.  This is the
              default.  Use /-C to disable display of separator.
  /D          Same as wide but files are list sorted by column.
  /L          Uses lowercase.
  /N          New long list format where filenames are on the far right.
  /O          List by files in sorted order.
  sortorder    N  By name (alphabetic)       S  By size (smallest first)
               E  By extension (alphabetic)  D  By date/time (oldest first)
               G  Group directories first    -  Prefix to reverse order
  /P          Pauses after each screenful of information.
  /Q          Display the owner of the file.
  /R          Display alternate data streams of the file.
  /S          Displays files in specified directory and all subdirectories.
  /T          Controls which time field displayed or used for sorting
  timefield   C  Creation
              A  Last Access
              W  Last Written
  /W          Uses wide list format.
  /X          This displays the short names generated for non-8dot3 file
              names.  The format is that of /N with the short name inserted
              before the long name. If no short name is present, blanks are
              displayed in its place.
  /4          Displays four-digit years

Switches may be preset in the DIRCMD environment variable.  Override
preset switches by prefixing any switch with - (hyphen)--for example, /-W.
Subscribe to: Posts (Atom)