stewartc-708166 (5/25/2010)

---

Tricky

Requires some knowledge of collations

malleswarareddy_m (5/24/2010)

---

hi ,

like operator will search for _ only.and return any characters. then it does not return any rows.because i worked many times using like...

Hugo Kornelis (5/25/2010)

---

malleswarareddy_m (5/24/2010)

---

hi ,

like operator will search for _ only.and return any characters. then it does not return any rows.because i worked many times using like operator.but if we...

hi ,

like operator will search for _ only.and return any characters. then it does not return any rows.because i worked many times using like operator.but if we use '%_%' or...

honza.mf (5/20/2010)

---

malleswarareddy_m (5/20/2010)

---

Thanks for reply.I know that there are different types out put for xml.

Includes For Xml 1)path 2)auto 3)raw 4)explicit.

But when i saved this output and opened with IE...

honza.mf (5/20/2010)

---

malleswarareddy_m (5/20/2010)

---

Hi,

after for xml i executed but it opened on SSMS.But i saved it in the form XML.With IE i am unable to open.With for xml it shows...

Hi,

When I run this it will success fully executed.I changed it @i+=1 to @i=@i+1;

but it will show result as with out using for xml.

after for xml i executed but...

thanks for quick reply.This is the interview question i had faced in two interviews. and i told to interviewer that we can acheive that using For XML.but i did not...

I thought that want to put insert scripts but the table is available.that's why i copy & pasted.sorry for wasting your time.next time i will put complete script for...

You are good.I thought that with For Xml it will work.

But i did not applied that logic.Beacause i did not written that queries using for xml.so did not got the...

Really its a good question about square brackets.we can use square brackets efficiently at any time.

Hi,I checked this query by using estimated execution plan(graphical). there is one inner join between one index seek on email address and another index seek on Qotdid .but i done...

Iam not using sql server 2008.

so I learned one new thing today.

Hi,

I can able set model database to read_only by using query or database properties -->

option-->state--Database read only property to true and also when we create a new database by default...

ok,

I want Particular departmant only.Just i copy and pasted this.next time i will post the sample data with proper format.not just for single update statement.It need to verify if that...

john.arnott (4/6/2010)

---

malleswarareddy_m (4/5/2010)

---

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...