Viewing 15 posts - 5,656 through 5,670 (of 7,484 total)
Lynn Pettis (8/8/2011)
@SQLFRNDZ (8/8/2011)
I understood Lynn, that I did not mention any where that I want to become MVP.
Actually, you did:
@SQLFRNDZ (8/5/2011)
Thanks Kraig and I will be an upcoming...
August 8, 2011 at 6:39 am
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
Viewing 15 posts - 5,656 through 5,670 (of 7,484 total)