easy question.....

good and easy question..

I heard a lot a word 'FORCESEEk' can anyone explain me what is this?

just ware of the fact that MERGE statement should end up with ;

never used Instead OF trigger, its good if anyone you can explain it with an example

We can also use any no. of semicolon before WITH also -

;;;with CTE as (select * from LocationMaster)

select LocationName from CTE

So, semicolon doesnt make any effect that how many semicolons...

thanks,

Its good to know this....

just a wild guess n get +1 for that 🙂

How can we see the privileges assigned to a particular sql agent roles?

Ahhh... 🙁

I thought Recovery mode has effect while rolling back the transaction.

well new thing to learn today...

Can any give an example of this?

Dont aware of this Output clause...

worng answer 🙁

can anyone explain this well with a example?

Easy question for the Thursday...

+1 :-):-P

thanks for your suggestion Hugo

Hi Hugo,

Ya i got the answer now..

So if a column is dropped from a base table which is using in view then it will throw an error..

but if after deleting...

hi Hugo,

thanks a lot....

I am new in area of DBA so can you plz suggest how can i improve my skills in sql area..

any site or books?

thanks Hugo...

I am daily learning new things from your comments...