Viewing 15 posts - 1,966 through 1,980 (of 3,347 total)
L' Eomot Inversé (10/19/2012)
October 19, 2012 at 12:48 pm
arthur.teter (10/19/2012)
While I know you are not supposed to be able to add multiple GUIDs to any table
Why not? What if a table has to store foreign keys into multiple...
October 19, 2012 at 9:20 am
Very good question overall.
Only (minor) issue - picking 6 out of 17 answer options is a task that appears daunting at first sight. The answer options were luckily well organized...
October 19, 2012 at 4:39 am
cfradenburg (10/18/2012)
October 19, 2012 at 1:27 am
L' Eomot Inversé (10/18/2012)
@Cassie (10/18/2012)
L' Eomot Inversé (10/18/2012)
But the explanation is very poor, inaccurate. For example the length of the expression "123.45" is 6, but str(123.45,4,2) is not...
October 18, 2012 at 4:24 am
(It's a good thing I remember to copy my reply to the clipboard before posting it - I ran once more in the issue [probably timeout related, I always get...
October 18, 2012 at 4:15 am
I knew about the STR function, but was not entirely sure what the optional arguments meant, so I decided to check Books Online before answering.
I must say that I was...
October 18, 2012 at 2:38 am
L' Eomot Inversé (10/17/2012)
October 17, 2012 at 3:19 am
I was almost hesitant to answer the question, thinking there might be a trick thaht I was overlooking. Fortunately, I wasn't.
The explanation is wrong, though. The innermost COALESCE does NOT...
October 17, 2012 at 2:23 am
okbangas (10/16/2012)
kapil190588 (10/15/2012)
As sql server version was not specified so I selected NoiseList but got wrong...I think version should be mentioned in question..
learn new thing today.......
If it were different in...
October 16, 2012 at 2:48 am
Richard Warr (10/15/2012)
Would there also be a difference between dbo.c_view and dbo.C_view if you had case sensitive collation set?
Yes, if your database uses case sensitive collation, "c_view" is different from...
October 15, 2012 at 3:55 am
At first sight, I thought this was a question to check whether indexed views can have their own statistics. I did not know that, so I set out to research...
October 15, 2012 at 3:01 am
L' Eomot Inversé (10/11/2012)
the consequences for concurrency and performance of requiring the seed to be rolled back would be intolerable.
That's not even the biggest issue. Consider this scenario:
Transaction 1 starts,...
October 11, 2012 at 4:14 am
A.jafari (10/10/2012)
Thanks For Answer, sorry "Try Except" is wrong ,it is Commad Of Delphi ,,i Want to say Diffrent Bettween "Begin Tran" And "Begin Catch"
BEGIN TRAN .......
October 11, 2012 at 4:03 am
kapil190588 (10/11/2012)
Can any give an example of this?
Yesterday, when you asked for resources to learrn about SQL Server, one of the suggestions I gave (the first, to be precise) is...
October 11, 2012 at 3:45 am
Viewing 15 posts - 1,966 through 1,980 (of 3,347 total)