Viewing 15 posts - 766 through 780 (of 1,114 total)
Adrian,
You are correct. But i don't have the permission to create functions. Can you provide some other alternate ways ?
April 25, 2008 at 5:28 am
Hi Adrian,
Thanks. I have modified your code.it is working perfectly.
------------------------------------------------------
CREATE TABLE #results
(
empNo INT,
accNo VARCHAR(50),
salary VARCHAR(50)
)
insert into #results values(100, '1000', '10000')
insert into #results values(100, '2000', '20000')
insert into #results values(100,...
April 25, 2008 at 4:28 am
When SQL uses a variable in a where clause it uses the contents of the variable as a literal value. Not as a reference to a table/column/database/any other object.
This is...
April 25, 2008 at 3:29 am
Thanks a lot Ryan ! Really it opens my eyes broadly.
CBAC - Context Based Access Control which is related to Network protocols.
what do you mean by TBAT ? I am...
April 25, 2008 at 1:46 am
It means
select @Null = count(*) from #t1 where 'Age' is null
Not Age as a column name, 'Age' as a string literal. Which IS NOT NULL
why and How...
April 25, 2008 at 1:40 am
Jeff,
Ok. No problem.
As you said, He used N as a column name.Please take a look at below the code.
SELECT TOP 11000 --thanks to Jeff Moden for this technique
...
April 24, 2008 at 7:33 am
I would like to add some more things.
if i execute the below one, it is giving 3 as the output.
Declare @Nm varchar(25),@Null int
--select @Nm = 'Age'
select @Null = count(*) from...
April 24, 2008 at 7:22 am
Yes.
what will happen internally is
Declare @Nm varchar(25)
select @Nm = 'Age'
select @Null = count(*) from #t1 where @Nm is null
it means select @Null = count(*) from #t1 where Age...
April 24, 2008 at 7:18 am
rbarry,
Thanks a lot.
what do you mean by 'N Between N' ?
I tried out it in a sample query. It is showing NULL in the first Row.Remaining rows are showing...
April 24, 2008 at 7:12 am
can we use master..spt_values table to avoid RBAR logic ?
April 24, 2008 at 7:03 am
Gila,
it's simply going to evaluate it as a scalar value.
what it means ?
April 24, 2008 at 7:02 am
Thanks Raja.
karthikeyan (4/23/2008)
--------------------------------------------------------------------------------
Carl Federl
select @Nm = 'Age'
select @Null = count(*) from #t1 where (@Nm) is null
As "where (@Nm) is null" will always be false, zero rows will meet the...
April 24, 2008 at 6:11 am
karthikeyan (4/23/2008)
Carl Federl
select @Nm = 'Age'
select @Null = count(*) from #t1 where (@Nm) is null
As "where (@Nm) is null" will always be false, zero rows will meet the
restriction....
April 24, 2008 at 3:07 am
Viewing 15 posts - 766 through 780 (of 1,114 total)