I'm using Self Test Software Practice questions to prepare for my 70-433 exam. When I practise in certification mode the software gives me 90 mins to complete 55 questions. Although...

Those who have already appeared for exams 70-433 and 70-451 can you please tell us how many questions where asked for each exams and how much time is given...

How valuable your employer will consider these certs are for their employees.

Does going for certs stand you apart from the crowd. Does it help in this economic climate?

DECLARE @i AS INT = 100,@msg AS VARCHAR(5)= '11',@Date AS DATE=GETDATE()

will generate error "Cannot assign a default value to a local variable."

Thanks will do it

Lynn Pettis (7/10/2009)

---

Here is one solution, but I had to upload it as an attachment. I am really getting tired of this intermittent issue of not being able to...

Mark (7/14/2009)

---

Try changing

SELECT R.nref.value('@ExpressionRef', 'INT') AS ExpressionRef,

R.nref.value('@ErrorResult', 'VARCHAR(50)') AS...

Yes this helped but I am not sure about the performance of my query with huge amount of data. I'll post back about...

Thanks for your reply.

Lowell (6/29/2009)

---

yeah i agree; either fix the data, or the one parameter raising the issue. I would not try to change hundreds of other parameters...to many things for the QA...

Lowell (6/29/2009)

---

@Param1 NUMERIC(2, 0)---this says the definition is 2 digits, none after the decimal....but you are assigning a 5 digit number to it: @Param1 = 92229.0

since the...