Viewing 15 posts - 40,306 through 40,320 (of 59,072 total)
shannonjk (1/7/2010)
Jeff Moden (1/7/2010)
Only if it's a constant... in 2k5, it'll take any variable datatype that's implicitly convertable to NText and that includes VARCHAR.
Jeff can you show an example of...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2010 at 11:09 pm
Heh... it WAS a pointer! Seriously... why do you want to be a DBA?
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2010 at 11:03 pm
Code-1029433 (1/7/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2010 at 9:22 pm
Never mind, Lynn... I see why you're subtracting from 10... I did a validation of a full number and you're calculating the check digit.
Modification of my code will change it...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2010 at 9:09 pm
I don't know which will be faster nor which you prefer to read nor am I sure which is correct (I don't subtract my result from 10 like Lynn did......
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2010 at 9:04 pm
Lynn Pettis (1/7/2010)
declare @ TestData varchar(12);
set @TestData = '03EA12J77';
select
(10 - (sum(
...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2010 at 8:45 pm
The "better mousetrap" requires a "better pipe".
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2010 at 8:11 pm
jmiaebrown (1/7/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2010 at 8:08 pm
ddlawal (1/7/2010)
I am a rookie sql jr dba preparing for a phone interview. Would appreciate any input on what kind of questions to expect.
I am as rookie as can...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2010 at 7:58 pm
Only if it's a constant... in 2k5, it'll take any variable datatype that's implicitly convertable to NText and that includes VARCHAR.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2010 at 7:36 pm
Greg Martin-419640 (1/7/2010)
I've looked in the thread and not managed to see an answer to this. I use SQL server.
If I have a Customers table,...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2010 at 7:20 pm
bear in a box (6/24/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2010 at 7:11 pm
Steve Jones - Editor (1/7/2010)
We'll never eliminate bias.
Heh... I found a way... I wake up hating everyone and make exceptions from there. Pork chops for everyone! 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2010 at 6:58 pm
imani_technology (1/7/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2010 at 6:51 pm
All that's good but I don't understand what you understand. Please read and heed the article located at the first link in my signature line below so we can...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 7, 2010 at 6:45 pm
Viewing 15 posts - 40,306 through 40,320 (of 59,072 total)