Viewing 15 posts - 706 through 720 (of 1,048 total)
EASY ONE!!
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 18, 2013 at 11:52 pm
simple basic question for the day...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 18, 2013 at 10:19 pm
good explanation John....
the error is coming due to incompatibility of datatypes in UNION....
but if we do like this -
DECLARE @id varchar(10)
set @id = 'A'
select isnumeric(@id)
It always gives 1
why?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 15, 2013 at 11:01 pm
good question...
very good discussion by experties 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 15, 2013 at 9:52 pm
THANKS RALS,
the query that you posted will make effect through EXECUTE but the EXECUTE statement that is post in the today's QOD is not making any effect it...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 15, 2013 at 12:44 am
At first line of query its written as Use Master, so all statement stating SELECT db_name() gives master, execute statement will not make any effect here.....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 14, 2013 at 11:06 pm
good question 🙂
+1
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 13, 2013 at 4:59 am
easy one +1:-)
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 12, 2013 at 10:42 pm
Really Gud Question....
Alas, I confused so first I ran the code and then answer it :crying:
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 12, 2013 at 10:33 pm
Good basic question to start the week..... 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 10, 2013 at 10:17 pm
easy basic question 🙂
+1
But still 23% answer are incorrect ;-):w00t:
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 5, 2013 at 10:23 pm
GOOD basic question 🙂
ALso good explanation by Lokesh 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 4, 2013 at 12:43 am
GOOD QUESTION..
+1
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 29, 2013 at 3:31 am
nice basic question 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 28, 2013 at 5:18 am
basic question for +2 :w00t:
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 28, 2013 at 5:16 am
Viewing 15 posts - 706 through 720 (of 1,048 total)