Well Thanks to all this are the things that i have doubt about it.specialy number 4:

1- i have table with 40 fields that it have 10 image Type field (varbinary(max)).image...

i want when no data is available (on where statement no data is exist) return nothing not null value

select

SUM(isnull([TedadTarhModiriatTafzili],0))as TedadTarhModiriatTafzili

, SUM(isnull([TedadTarhModiriatJame],0))as TedadTarhModiriatJame

, SUM(isnull([TedadKhodro],0))as TedadKhodro

, SUM(isnull([TedadMotorcycle],0))as TedadMotorcycle

, SUM(isnull([TedadGhayegh],0))as TedadGhayegh

, SUM(isnull([TedadBisim],0))as TedadBisim

,...

where can i check this?and change this?i want both of this:

on win 7 and win XP service pack2

i want to create backup on desktop.i test it give that error and i check c drive it give me error.i want to exactly put file in desktop.what can...

i have userid pk and i want also make username and password field uniqe.how can i do that?

vinu512 (4/24/2012)

---

One table for User Details is fine. You just need to check if the data that the table houses is in Normalized Form.

From what I understand you should have...

how can i do that?