john.arnott (4/5/2010)

---

malleswarareddy_m (4/4/2010)

---

Good QOD.This Question gives good information about bit datatypes.

when we use space or all zero it bit will convert it into zero.If we give numeric(numbers) it will convert...

Yes it will give zero as ouptut. Some typing mistake.

Good QOD.This Question gives good information about bit datatypes.

when we use space or all zero it bit will convert it into zero.If we give numeric(numbers) it will convert it into...

Hi,

When I using SQL Server it show default of SQL Server as 1900-01-01.I thought that it was the least date.

But my answer is wrong.

I also lost 7 points.Happy april fools day.

Hi Steve jones,

I have created the table as given in question.but it will not given an error or warning message.I shows

commands executed sucess fully.Even though I put SET ANSI_WARNINGS ON.

I...

Hi,

I got wrong to this question.because that url part was commented.

Without comments it will work fine.but with in comments how will it work i do not know.

the author of this...

Hi,

from SSMS i put new query window.but how can i restore using query or by right click on database/restore option.Itried both that not worked.

by using command propmt it worked.

using sqlcmd...

when x is 0 then y =10

when x is 1 then y =9.33

when x is 2 then y =8.66

when x is 3 then y =7.99

when x is 4 then y...

I got wrong.

But the question is good.

ok.Its working fine

Hi thanks for reply,

this above code is fine but it will take the average time not full datetime.

I want to calculate time not average of date.

Hi pual ,

i got suceeded with pivot and unpivot.But i First transpose this to unpivot then pivot the table.I take two steps for this.

But you have done this in single...

Hi i got my result .but i did not got my result directly with combination of pivot and unpivot result.first i unpivot the result into temp

then pivot the temp table.

finally...

correct answer is currentdate()+2;

i had choosen the answer as currentdate()+2;

but the answer is wrong.then i copy and paste the code in browser and executed the same result

as currentdate()+2;

I did...