which is NULL and equals to 0

Well, yes but i wanted to delete this.. dont know how.. How do i do it??

My requirement is to

-Get the value stored in...

Sorry but I dint understand how the solution u provided will answer my question..

I have no doubt about the coalesce function i used... But the string comparision is my...

[:)] [:)] [:)] [:)]

mm, I have to replace the 'blank' term which appeared twice with some functions or keywords like PARSE, convert or CAST to get the result like that.. I couldn't...

Thanks for the info.. I am now subscribed to your newsletters..I will wait for monday...

Can you please explain or answer the 1st question in your sample test create database objects......

KatieAndEmil (3/31/2013)

---

Hi

For those avoiding brain dumps (I hope everyone! 😉 and looking for practice tests which can help you get used to style of Microsoft Exams so you can prepare...

Just got my book Guys.. Its a Treat for me over the weekend

I think I did not understand ur requirement properly

Is this what u want???

Update LOTTERY_MY_NUM set NUM1= LOTTERY_WINNING_NUM.NUM1,

NUM2= LOTTERY_WINNING_NUM.NUM2,

NUM3= LOTTERY_WINNING_NUM.NUM3,

NUM4= LOTTERY_WINNING_NUM.NUM4,

NUM5= LOTTERY_WINNING_NUM.NUM5

from LOTTERY_MY_NUM...

Lowell (3/21/2013)

---

you create multiple roles which contain the permissions you want to be able to assign;

adding a user and granting permissions are a three part process.

first you really needed to...

You can programatically do it with dynamic SQL or you can copy paste a bunch of lines only changing the table name (Object name)..

Simplified syntax for GRANT

GRANT { ALL [...

TRUNCATE TABLE removes all rows from a table, but the table structure and its columns, constraints, indexes and so on remain..

Thanks.. It costs 150 for all the exams.. I found the details here

http://www.register.prometric.com/Exam.asp

Yah We have been doing the same code in different ways all the tymm... Until...