Viewing 15 posts - 781 through 795 (of 3,221 total)
Have you looked at the RAND function (Random number generation) for example to generate your Id value ?:
DECLARE @I DECIMAL(10,8)
SET @I = RAND( (DATEPART(mm, GETDATE()) * 100000 )
...
December 22, 2011 at 12:05 pm
Sarath Vellampalli (12/21/2011)
Hi,What is the meaning of WHERE *= COLUMN NAME in a select query.
please explain me and also provide some examples.
Regards,
Sarath Babu Vellampalli.
From BOL (2008)
Multiplies by an amount and...
December 21, 2011 at 7:30 pm
Jan Van der Eecken
And yes, I do remember punchcards (but not paper tapes)! Biggest fun was when my female colleague at varsity came down the stairs with two drawers full...
December 20, 2011 at 7:27 am
A lot of reading, but a nice question which will certainly teach those who answer incorrectly.
Thanks
December 19, 2011 at 11:15 pm
john.arnott Posted Today @ 7:02 PM
Ron (AKA Bitbucket),
You were spoiled having as much as 32K (I assume bytes) to work with, let alone be able to chain...
December 19, 2011 at 5:33 pm
Evil Kraig F (12/19/2011)
I'm not even going to get in this old fogie contest, best I can offer is starting out...
December 19, 2011 at 2:57 pm
Stefan Krzywicki Posted Today @ 10:55 AM
Those of you who have been talking about the first machines you used in the industry, what was it that got you to that...
December 19, 2011 at 9:13 am
LutzM Posted Today @ 9:07 AM
Hmmm.... interesting....
Based on the (almost public available) age of the two fellows you're somewhat between 14 and 16 years old. Hard to believe that you've...
December 19, 2011 at 8:49 am
Revenant (12/18/2011)
bitbucket-25253 (12/18/2011)
. . . Next moved on to a 1401, where the installed language was Autocoder (anyone remember that obscenity ?).
As in MLCM, IOCTL and the rest of...
December 18, 2011 at 12:34 pm
Revenant (12/17/2011)
I have started on 2 September 1970, on an IBM 360/40 installation that was pride of the town: 128k of memory, 8 tape drives, and 8 2311 disk drives...
December 18, 2011 at 11:31 am
SQL Kiwi (12/17/2011)
DECLARE @Example TABLE (col1 VARCHAR(10))
INSERT @Example VALUES ('X'), ('X' + SPACE(1)), ('X' + SPACE(2))
SELECT COUNT_BIG(*) FROM @Example AS...
December 18, 2011 at 9:33 am
Why settle for an approximate date. Create a table calendar and use the value of interval to return a exact date.
CREATE TABLE #Calendar
(xdate SMALLDATETIME NOT NULL, Interval...
December 16, 2011 at 4:33 pm
SQLQuest29 (12/16/2011)
But my problem is that the data is integer and I get it as 465, 356, etc .. I need to convert it into meaning full data.
I...
December 16, 2011 at 2:31 pm
Viewing 15 posts - 781 through 795 (of 3,221 total)