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...
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...
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...
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?
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...
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...
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...
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)...
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...
August 7, 2011 at 8:45 am
Cliff Jones (8/6/2011)
SQLkiwi (8/5/2011)
Tom.Thomson (8/5/2011)
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...
August 5, 2011 at 7:49 pm
Jack Corbett (8/5/2011)
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)
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...
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...
August 5, 2011 at 11:53 am
Viewing 15 posts - 5,656 through 5,670 (of 7,483 total)