I will executes With Exists operaot insetead of using =?

The is error is throwing due to subquery subquery will not return multiple rows.but using exists we can return multiple rows.

if...

for testing folating point the same can be written as

DECLARE @i float,@rc int

set @i = 0

while @i <> 1

begin

set @i = @i + 0.1

end

select @i

then the loop never...

I also did not under stand the question properly.

Again good question on same round function.Thanks hugo

I also got wrong.thinking that asked about esimated execution .it will run without the query.I also ran this estimated execution plan.But i forgot to check Actual execution plan.This question is...

I also choose profiler as answer.beacuse tracing of all objects will have more impact on server.

Good question.Learned some usefull point

I also got wrong because of not understanding properly.First i think that

using is a clause that shows the destination table

but after completly reading the question i got wrong.but i...

I also got wrong.but i think answer DDL trigger folder is in server objects.

database triggers are in programabilty -- triggers folder.

Please correct the answer or please explain the same in...

hi,

I know that we can add explicit values to an identity column using

Identity_Insert on. but i thought that identify column will not allow duplicate columns.good question.lost one point but...

I did not any thing about SQL 6.5 ,7.0.Also i did little work on SQL server 2000.Worked mostly on 2005 and 2008.This question is almost ten years old.

I know the partitoned table and partioned indexes.but frankly saying

that i thought that with out group by it will work in 2008.but my guess is wrong when i executed in...

Hi ,

I guessed correctly as 4.but i executed the script it is throwing error in the last statement.because group by is not there in the last statement.

Is it working for...

I know that but some one of friend told that its take more time to execute.that why i posted if there is another way which executing faster than using row_number

Nice question.

I did not notice the variable length.that's why i got wrong.I had answered 1.