Viewing 15 posts - 976 through 990 (of 1,048 total)
easy question.....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 11, 2012 at 4:03 am
good and easy question..
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 11, 2012 at 3:52 am
I heard a lot a word 'FORCESEEk' can anyone explain me what is this?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 11, 2012 at 2:15 am
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
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 11, 2012 at 2:07 am
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...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 11, 2012 at 1:59 am
thanks,
Its good to know this....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 11, 2012 at 1:53 am
just a wild guess n get +1 for that 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 11, 2012 at 1:49 am
How can we see the privileges assigned to a particular sql agent roles?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 11, 2012 at 1:41 am
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?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 11, 2012 at 1:39 am
Dont aware of this Output clause...
worng answer 🙁
can anyone explain this well with a example?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 11, 2012 at 1:21 am
Easy question for the Thursday...
+1 :-):-P
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 11, 2012 at 12:53 am
thanks for your suggestion Hugo
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 10, 2012 at 5:13 am
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...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 10, 2012 at 4:03 am
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?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 10, 2012 at 3:56 am
thanks Hugo...
I am daily learning new things from your comments...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 10, 2012 at 3:54 am
Viewing 15 posts - 976 through 990 (of 1,048 total)