Viewing 15 posts - 51,451 through 51,465 (of 59,072 total)
Gregg Walker (3/28/2008)
March 28, 2008 at 1:40 pm
Jim Russell (3/28/2008)
Since nulls will group together in a...
March 28, 2008 at 1:37 pm
kaspencer (3/28/2008)
However, I do not consider the NULL to be "missing data". The NULL must simply be considered as either "no value", or "value not [yet] assigned".
Heh... what the heck...
March 28, 2008 at 1:35 pm
Mike C (2/25/2006)
NULL is not a value...
Spot on! Hence the T-Shirt that says "NULL Is NOT Nothing!" 😀
March 28, 2008 at 1:31 pm
Matt Miller (3/28/2008)
Jeff Moden (3/28/2008)
Bad test, I think, Matt. You would never use 1 = NULL... not sure how that applies.
I'm drawing a comparison (or rather - highlighting the...
March 28, 2008 at 1:27 pm
Matt Miller (3/28/2008)
Jeff Moden (3/28/2008)
I normally don't work NULLs against "TRUE/FALSE" values even in WHERE clauses... I normally work them against...
March 28, 2008 at 12:48 pm
...and so is WHERE <>...
--===== Now, do a WHERE <> and check the execution plan... INDEX SEEK!!!
SELECT * FROM jbmtest WHERE RowNum <> 3
March 28, 2008 at 12:45 pm
Mike C (2/27/2006)
Both of which, by the way, are non-SARGable in WHERE clauses...
??? :blink: Maybe I'm reading this wrong, but WHERE NOT IN most certainly IS...
March 28, 2008 at 12:43 pm
dfalso (3/28/2008)
blahknow (3/28/2008)
This is how it works
"myPhones" is a stored procedure to supply the telemarketing personnel phone numbers to make phone calls.
phone numbers are stored in various tables of...
March 28, 2008 at 12:32 pm
Good article... and I realize it's a couple years old...
I normally don't work NULLs against "TRUE/FALSE" values even in WHERE clauses... I normally work them against some form of data......
March 28, 2008 at 7:58 am
vmsbalaji (3/28/2008)
Suppose i am having 10 tables in a database.in that 10 tables,5 tables are having the column value as 'cat'.i need 5 tables name alone.more over it must...
March 28, 2008 at 6:16 am
Here's a couple of facts for you...
Creating a temp table that holds 750000 rows of primary keys of rows to be deleted takes 2.1 seconds using SELECT/INTO.
Adding a primary key...
March 28, 2008 at 6:08 am
blahknow (3/25/2008)
My stored procedure accepts 2 parameters: names, number of names like this: (name1, name2, name3,3) Problem is: the number of names changes each time i want to run...
March 28, 2008 at 4:59 am
Mahesh Bote (3/28/2008)
Better you go for XML.
A well formed UDF or open code that uses a Tally table to do the split will blow the doors off of any form...
March 28, 2008 at 4:53 am
If it's for a join, as you say... why are you concerned with converting it back to a number? Just join to it...
March 28, 2008 at 4:42 am
Viewing 15 posts - 51,451 through 51,465 (of 59,072 total)