T-SQL limit SP return(for testing)

ROWCOUNT is pretty cool.

SET ROWCOUNT 5 --This limits not just SELECT but EXEC return…

ROWID for T-SQL

Place this in your output:

DECLARE @RUN_PARMS    TABLE
( [SVN]                   VARCHAR(04)
...
INSERT  INTO @RUN_PARMS
SELECT  '1362' AS SVN
...
SELECT  ROW_NUMBER() OVER(PARTITION BY [SVN] ORDER BY [SVN]) AS ROWID
,   RP.[SVN]
...

If you add this code using [SVN](in this case a static subversion number) it will add a rowid - uniquely identifying sequential number to your output.

Cnt.hta_

Example of...



-Page based CSS style

-Determining X ~ Y in Internet Explorer


Download

Quick launch tools

I've got my definitive set of Quicklaunch apps
...these are .au3 scripts I use most:

[EditPlus],[WinSQL],make_unc,[Crystal Reports XI R2],backup.au3


For which I need:

7Zip

AutoIt

EditPlus

WinSQL

SVN command line

I've been using Subversion command line on a network. In that context I've found it faster than the Tortoise SVN client (& more configurable).


In order to make this easier I created an HTA and .CMD file to configure a user and apply it in the command line parms.


Stores your SVN user & Pass in registry:

svn_cfg.cmd_


Fetchs SVN user & Pass for use with command line parms:

svn_cfg.hta_


Google 'SlikSVN'(check the download links):

Google SlikSVN


Useful configurability:

Changelists

WinSQL .wwb from toolbar not menu

It's been a little while since I'd been in WinSQL. I'd forgotten this. When you have a work book file (.wwb) to open -- you have to open, it appears, from the toolbar vs. the menu.

Setting up multiple browser profiles

Multiple browser profiles can be very useful -- whether because you use a shared computer - or like to keep your browsing habits & interested 'sandboxed'. Google Chrome has additional strengths here in that it allows you to truly have independent profiles. You can login using different profiles multiple times to different services(say GMail or Yahoo). 

For more try search on 'ChromeStart'

For Google Chrome Vista - home directory is:

C:\Users\<username>\

AppData\

Local\

Google\

Chrome\

Application

To make profile:

-Close all Google Chrome sessions

-Open local appdata folder & copy

-"..\User Data\Default" to "..\User Data\xyz"

-Run [	"C:\Users\
	<username>
	AppData\
	Local\
	Google\
	Chrome\
	Application\
	chrome.exe"
	--User_Data_Dir="..\User Data\xyz"	]

For Firefox - you'll need to:

-Close all Firefox sessions

-Run [ "C:\Program Files\

Mozilla Firefox\

firefox.exe"

-ProfileManager" ]

-Create "xyz"

-Run [ "C:\Program Files\

Mozilla Firefox\

firefox.exe"

-p "xyz" ]

My Reading list for April 2009

http://twitter.com/ReadingEmma

Google Chrome Cool feature #01

You can setup separate profiles to perform different tasks.  The cookies, history, other items are kept separate.  This gives you freedom say to create a profile for different emails on the same service, example, michael.t.bee@gmail.com and michael.t.bee.mde@gmail.com or mikebee_home@yahoo.com and mikebee_work@yahoo.com -- and browse ~ manager them independently.  For more: Try Google: 'Browser profiles'

Google Chrome Cool #02

Another cool chrome thing.  When you ^Fstring the browser not only colorizes that string on the page -- it gives you an occurrence list on the left elevator bar.  Clicking these positions you on the page to that item.

Psa34.hta_

To download & use : Right-click ~ "save as" (without the trailing "_"):

Psa34.hta_

If you use VLC -- this application demonstrates the "--play-and-exit" parameter:

...also of divs to create layers...