Viewing 15 posts - 5,656 through 5,670 (of 7,483 total)
Nice simple question. Thanks for a gentle start to the week.
Uses an "undocumented" (maybe Paul Randall's blog entries is generally documentation as reliable as BoL, so maybe...
Tom
August 8, 2011 at 5:30 am
vision59 (8/7/2011)
problem passing output as select @student id = @@identity if I coment it it works fine without error. Looking for...
Tom
August 7, 2011 at 9:19 pm
Ninja's_RGR'us (8/7/2011)
vision59 (8/7/2011)
It is user definition with Uniqueid(numeric(16,0) and passing as output still seeing this error.That's well over the limit of an int and even a bigint..
Well, no. The...
Tom
August 7, 2011 at 8:48 pm
I don't think there is a built in datatype called uniqueid in T-SQL, so presumably this is a user defined type. Can you post the type definition, please?
Tom
August 7, 2011 at 6:27 pm
Your first problem will be converting data in dd-mm-yyyy format to datetime. I think you will have to call "set language='British' " or "set dateformat = 'dmy' " before...
Tom
August 7, 2011 at 6:14 pm
I don't recommend any books on Sql Server; I don't think I've ever read one, and it wouldn't be ethical to recommend something I've never read. There are several...
Tom
August 7, 2011 at 5:46 pm
bitbucket-25253 (8/7/2011)
Jeff Moden (8/7/2011)
sqlfriends (8/5/2011)
Our production server will be enterprise version
For the license issue, can I just use...
Tom
August 7, 2011 at 4:15 pm
The where clause is very straightforward.
WHERE (b.WITHDRAW_CODE IS NULL OR @IncludeWithdrawnStudents = 1)
means that the action will not be done unless either the student is not withdrawn (b.withdraw_code is null)...
Tom
August 7, 2011 at 4:09 pm
john.arnott (8/6/2011)
Perhaps put off by the apparent snarkiness ("I would hope that most...") of Tom's refutal of my post questioning the use of Float for monetary values, ....
You must have...
Tom
August 7, 2011 at 8:45 am
Cliff Jones (8/6/2011)
SQLkiwi (8/5/2011)
Tom.Thomson (8/5/2011)
Tom
August 6, 2011 at 12:41 pm
mtillman-921105 (8/5/2011)
Tom.Thomson (8/5/2011)
Revenant (8/5/2011)
bopeavy (8/5/2011)
crookj (8/5/2011)
bopeavy (8/5/2011)
--------------------------------------------------------------------------------
WEEKEND!
At Bernie's ------ Darn, here we go again....
Party ------Yep Pee!
Beers!
Wines!!
Song
Women!!!
Why are the last two in the...
Tom
August 5, 2011 at 7:49 pm
Jack Corbett (8/5/2011)
Tom
August 5, 2011 at 12:13 pm
Stefan Krzywicki (8/5/2011)
GSquared (8/5/2011)
Stefan Krzywicki (8/5/2011)
GSquared (8/5/2011)
Stefan Krzywicki (8/5/2011)
Tom
August 5, 2011 at 12:08 pm
I've done it, but I made very sure I tooke a backup immediately before changing from read only to allow write, and again immediately after changing back. Maybe paranoia...
Tom
August 5, 2011 at 12:01 pm
john.arnott (8/5/2011)
Cliff Jones (8/5/2011)
I thought this question was about using approximate data types so got it right for the wrong reason.
I would hope that most viewers of this understand that...
Tom
August 5, 2011 at 11:53 am
Viewing 15 posts - 5,656 through 5,670 (of 7,483 total)