skip to main
|
skip to sidebar
sevenwires
Tuesday, June 26, 2007
[sql] Generate Random Numbers
Good trick (and very nicely put together article) that Mike found
http://www.sql-server-helper.com/tips/generate-random-numbers.aspx
SELECT ABS(CAST(CAST(NEWID() AS VARBINARY) AS INT))
Double casts with absolute value. Awesome.
Newer Post
Older Post
Home
wandy sae-tan
sevenwires.com
View my complete profile
labels
code
(20)
eats
(15)
log
(6)
muse
(23)
play
(12)
recipe
(37)
sql
(21)
story
(8)
tool
(25)
util
(3)
web
(9)
blogroll
pierre
cynthia
eileen
jessica
james
dave
jeff
russ
shoey
sis
archive
►
2011
(4)
►
September
(1)
►
July
(3)
►
2010
(4)
►
April
(3)
►
January
(1)
►
2009
(33)
►
December
(1)
►
November
(1)
►
October
(3)
►
September
(1)
►
August
(2)
►
July
(3)
►
June
(1)
►
May
(2)
►
April
(4)
►
March
(4)
►
February
(7)
►
January
(4)
►
2008
(64)
►
December
(1)
►
November
(1)
►
October
(4)
►
September
(6)
►
August
(3)
►
July
(7)
►
June
(11)
►
May
(4)
►
April
(2)
►
March
(5)
►
February
(10)
►
January
(10)
▼
2007
(147)
►
December
(8)
►
November
(1)
►
October
(7)
►
September
(13)
►
August
(6)
►
July
(11)
▼
June
(18)
[log] i18n, L10n, g11n, p13n
[util] FireFox 2 Config Tweaks
[sql] Generate Random Numbers
[twiki] How to Install SectionalEditPlugin
[twiki] How to Install MultiEditPlugin
[css] Page Break Attribute
[log] M&M's
[muse] Smart, Motivated, Nice
[util] Pivot Stickfigure Animator
[sql] SQL Server Date Formats
[web] From Application to Platform
[eats] Ummba Grill (Century City, CA)
[web] Money Widgets
[outing] Dandy Don's Catered Sundae Bar
[muse] Urgent vs Important
[web] Local Events App
[web] The Killer App - Fresh, Relevant Content
[muse] Google Gear
►
May
(18)
►
April
(24)
►
March
(10)
►
February
(14)
►
January
(17)
►
2006
(92)
►
December
(9)
►
November
(5)
►
October
(9)
►
September
(8)
►
August
(12)
►
July
(9)
►
June
(12)
►
May
(9)
►
April
(2)
►
March
(1)
►
February
(10)
►
January
(6)
►
2005
(59)
►
December
(5)
►
November
(4)
►
October
(5)
►
September
(4)
►
August
(7)
►
July
(9)
►
June
(2)
►
May
(2)
►
April
(7)
►
March
(1)
►
February
(6)
►
January
(7)
►
2004
(24)
►
December
(24)