Thursday, May 19, 2011

List of keyboard shortcuts in Mozilla Firefox

Navigation

Command________________

Shortcut____________

Back

Altcommand+Left Arrow
BackspaceCtrlcommand+[
Delete

Forward

Altcommand+Right Arrow
Shift+BackspaceCtrlcommand+]
Shift+Delete

Home

AltOpt+Home

Open File

Ctrlcommand+O

Reload

F5
Ctrlcommand+R

Reload (override cache)

Ctrl+F5
Ctrlcommand

+Shift+R

Stop

command+.
Esc

Current Page

Command________________

Shortcut____________

Go to Bottom of Page

End

Go to Top of Page

Home

Move to Next Frame

F6

Move to Previous Frame

Shift+F6

Page Info


Ctrlcommand+

I

Page Source

Ctrlcommand+U

Print

Ctrlcommand+P

Save Page As

Ctrlcommand+S

Zoom In

Ctrlcommand++

Zoom Out

Ctrlcommand+-

Zoom Reset

Ctrlcommand+0

Editing

Command________________

Shortcut____________

Copy

Ctrlcommand+C

Cut

Ctrlcommand+X

Delete

Delete

Paste

Ctrlcommand+V

Redo

Ctrlcommand+YShift+Z

Select All

Ctrlcommand+A

Undo

Ctrlcommand+Z

Search

Command________________

Shortcut____________

Find

Ctrlcommand+F

Find Again

F3
Ctrlcommand+G

Find Previous

Shift+F3
Ctrlcommand+Shift+G

Find As You Type Link

'

Find As You Type Text

/

Search bar

Ctrlcommand+K
Ctrl+EJ

Windows & Tabs

See also Tabbed browsing

Command________________

Shortcut____________

Close Tab

Ctrlcommand+W
Ctrl+F4

Close Window

Ctrlcommand+Shift+W
Alt+F4

Move Tab in focus Left

Ctrlcommand+Left Arrow
Ctrlcommand+Up Arrow

Move Tab in focus Right

Ctrlcommand+Right Arrow
Ctrlcommand+Down Arrow

Move Tab in focus to start

Ctrlcommand+Home

Move Tab in focus to end

Ctrlcommand+End

New Tab

Ctrlcommand+T

New Window

Ctrlcommand+N

Next Tab

Ctrl+Tab
command+Opt+Right Arrow
command+}
Ctrl
+Page Down

Open Address in New Tab

AltOpt+EnterReturn

- from Location Bar or Search Bar

Previous Tab

CtrlCtrl+Shift+Tab
command+Opt+Left Arrow
command+{

Ctrl+Page Up

Undo Close Tab

Ctrlcommand+Shift+T

Undo Close Window

Ctrlcommand+Shift+N

Select Tab (1 to 8)

CtrlAltcommand+(1 to 8)

Select Last Tab

CtrlAltcommand+9

Tab Groups View


Ctrlcommand+

Shift+E

History

Command________________

Shortcut____________

History sidebar

Ctrlcommand+shift+H

Library window (History)

Ctrl + Shift + H

Bookmarks

Command________________

Shortcut____________

Bookmark All Tabs

Ctrlcommand+

Shift+D

Bookmark This Page

Ctrlcommand+D

Bookmarks sidebar

Ctrlcommand+B
Ctrl+I

Library window (Bookmarks)

Ctrlcommand+Shift+BO

Tools

Command________________

Shortcut____________

Downloads

Ctrl + JCtrl + Shift + Ycommand + J

Add-ons


Ctrl + Shift + Acommand + Shift + A

Error Console

Ctrl + Shift + Jcommand + Shift + J

Web Console


Ctrl + Shift + Kcommand + Shift + K

Toggle Private Browsing

Ctrl + Shift + Pcommand + Shift + P

Clear Recent History

Ctrl + Shift + Del

command + Shift + delete

Miscellaneous

Command________________

Shortcut____________

Complete .com Address

Ctrlcommand+EnterReturn

Complete .net Address

Shift+EnterReturn

Complete .org Address

Ctrlcommand+Shift+EnterReturn

Delete Selected Autocomplete Entry

Shift+

Del

Toggle Full Screen

command+Shift+FF11

HelpHelp

F1command+?

Toggle Menu Bar (when hidden)

Alt
F10Ctrl + F2Alt (KDE)
F10 (GNOME)

Show/Hide Add-on Bar


Ctrl + /command + /

Caret Browsing

F7

Select Location Bar

Alt+D
F6


Ctrlcommand+L

Select or Manage Search Engines

AltOpt+Up Arrow
AltOpt+Down Arrow
F4

- when Search Bar is focused

Media shortcuts (Ogg and WebM Videos Only)

Command________________

Shortcut____________

Toggle Play / Pause

Space

Decrease volume

Arrow down

Increase volume

Arrow up

Mute audio

Ctrl+Down Arrowcommand+Down Arrow

Unmute audio

Ctrl+Arrow upcommand+Up Arrow

Seek back 15 seconds

Left Arrow

Seek back 10 %

Ctrl+Left Arrowcommand+Left Arrow

Seek forward 15 seconds

Right Arrow

Seek forward 10 %

Ctrl+Right Arrowcommand+Right Arrow

Seek to the beginning

Home

Seek to the end

End

Monday, May 9, 2011

Function Split

T-sql function :

CREATE FUNCTION [dbo].[ufn_Split](@String nvarchar(4000), @Delimiter char(1))
RETURNS @Results TABLE (value nvarchar(4000))
AS

--this function takes two parameters; the first is the delimited string, the second is the delimiter
-- Example how to use it >> IN (select value from dbo.ufn_Split(ltrim(rtrim(@CaseNumber)),','));
BEGIN
DECLARE @INDEX INT
DECLARE @SLICE nvarchar(4000)
-- HAVE TO SET TO 1 SO IT DOESNT EQUAL Z
-- ERO FIRST TIME IN LOOP
SELECT @INDEX = 1

IF @String IS NULL RETURN
WHILE @INDEX !=0


BEGIN
-- GET THE INDEX OF THE FIRST OCCURENCE OF THE SPLIT CHARACTER
SELECT @INDEX = CHARINDEX(@Delimiter,@STRING)
-- NOW PUSH EVERYTHING TO THE LEFT OF IT INTO THE SLICE VARIABLE
IF @INDEX !=0
SELECT @SLICE = LEFT(@STRING,@INDEX - 1)
ELSE
SELECT @SLICE = @STRING
-- PUT THE ITEM INTO THE RESULTS SET
INSERT INTO @Results(value) VALUES(@SLICE)
-- CHOP THE ITEM REMOVED OFF THE MAIN STRING
SELECT @STRING = RIGHT(@STRING,LEN(@STRING) - @INDEX)
-- BREAK OUT IF WE ARE DONE
IF LEN(@STRING) = 0 BREAK
END

RETURN
END