Good post Div 🙂

:-):-P

didn't get your problem....

Hi,

These are different different programs for the diff application like SSMA, Sql native client for services etc.....

When I reun the query Select * from test. I got the 2 rows in result while in poll reuslt it mentioned that Query will return 0 rows.

Worng post...

oops bad one!! got the wrong answer

Thanks a lot Wayne for the valuable information.

+1 🙂

Nice question...

Easy one 😛

It will be

A

A,A :-):-P

thanks a lot Hugo it clears to me now!!

hi,

I am a newbie in filed of DBa. Can anyone plz explain me how the 41,80 coming while executing--

DECLARE @nvarchar nvarchar(40)

DECLARE @nchar nchar(40)

SET @nvarchar =...

when i run that query I got answer as 1,1 and in poll its showing 1,0 as correct answer.

I dont know why...

Not clear with the question that you ask...

can you plzz attach a screenshot

Hi maida,

here is the query wch list out all the dates 1 year less than the current date..

Select LTRating ,RHDate from Accounts and If LTRating ='D' then RHDate < DATEadd(YY,-1,getdate())

Hope...