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