Viewing 15 posts - 226 through 240 (of 499 total)
You may have to strip out the 'nd', 'rd' from April 2nd, April 3rd etc using REPLACE.
See CAST AND CONVERT in MSDN for a full description
April 19, 2010 at 3:27 am
Tom.Thomson (4/16/2010)
Tom Brown (4/16/2010)
incidentally:Na tog mi gun tuit mi ach ma thuiteas tog!
Thig crìoch air an t-saoghal ach mairidh gaol is ceòl
Welsh? Cornish? Celtic? Gaelic?
Gaelic (Scottish).
Ach du...
April 16, 2010 at 5:26 am
Interesting. Under the covers when you right-click an object and generate script I SMSS probably takes the object_id and passes it to some internal generate-script procedure together with parameters...
April 16, 2010 at 5:15 am
Quick suggestion - I'm not sure it will work though - just a shot in the dark really.
Try defining the field value with a leading @ character - outside the...
April 16, 2010 at 4:49 am
I have 2000, 2005 and 2008 on my development machine.
I can run SMSS 2005 or SMSS 2008 (and even Query Analyser if I want - though it has nothing to...
April 16, 2010 at 4:35 am
good question.
I thought it couldn't possibly be the object_id of the column
as I looked at some of the columns it would have been creating stats on. - How...
April 16, 2010 at 4:25 am
Put it down to experience: I've had similar problems with connections, and I still get caught out, and have to go investigating all those settings - in fact it bugged...
April 16, 2010 at 3:47 am
Greg Edwards-268690 (4/15/2010)
Jack of all trades....don't know that I'm master of any.
But that fish looks pretty impressive Greg
April 16, 2010 at 3:34 am
Roy Ernest (4/15/2010)
I am just gonna take a break, go home and relax with my family... And then come back fresh tomorrow morning and try out the ideas... 🙂
On a...
April 16, 2010 at 3:31 am
Tom.Thomson (4/15/2010)
Whiffletree, Whippletree, Swingletree, Singletree
obsolete
incidentally:
Na tog mi gun tuit mi ach ma thuiteas tog!
Thig crìoch air an t-saoghal ach mairidh gaol is ceòl
Welsh? Cornish? Celtic? Gaelic?
April 16, 2010 at 3:21 am
-- to test code posting from another connection.
-- if this posts OK then it's the web police at work
SELECT something
INTO doom
FROM nowhere AS N
JOIN somewhere AS S ON...
April 16, 2010 at 12:18 am
Steve Jones - Editor (4/15/2010)
So much for "ignore this"
Hey haven't you gone skiing ?
April 16, 2010 at 12:08 am
It doesn't work for me - it has worked in the past - but not in the past few weeks
IE just goes away for ages and comes back with 'cannot...
April 15, 2010 at 7:19 am
Viewing 15 posts - 226 through 240 (of 499 total)