Viewing 15 posts - 226 through 240 (of 429 total)
Lokesh Vij (6/4/2013)
An easy one for the day.SET ANSI_NULLS ON --> enforces SQL-92 standard which says that all equal to and not equal to with NULL evaluates to FALSE.
I think...
June 5, 2013 at 7:07 am
Great question!
I did spot the difference in the two columns, but messed up the logic when answering. :crazy:
May 30, 2013 at 8:20 am
It really depends on what you are trying to do and how you want to manage it.
Here are some things to consider:
Are these tasks dependent on each other?
Can any of...
May 23, 2013 at 10:32 am
Thank you for this question. It was quite timely for me, as I've been looking into setting up this exact scenario for auditing server connections. It took me...
May 22, 2013 at 6:57 am
I almost got caught up on the primary key, as I knew clustered index columns needed to be included but didn't know the columns would be added automatically when they...
May 16, 2013 at 6:51 am
ammon.poage (5/13/2013)
May 13, 2013 at 2:02 pm
Interesting, I knew it was carried over for simple select queries, but would not have expected the IDENTITY to be included for a query including a GROUP BY.
May 13, 2013 at 7:55 am
Argh, I figured the answers were accidentally inverted, but went by the wording of the question anyway when I answered.
Interesting that ForceScan and ForceSeek seem to work without "WITH" though,...
April 29, 2013 at 10:34 am
I was surprised this was your question Hugo. I didn't think it was yours when I saw the Count(*) in the trigger! 😉
April 25, 2013 at 7:00 am
Great question! Thank you for keeping the code clear and focused.
April 24, 2013 at 6:22 am
kapil_kk (4/15/2013)
select COUNT(convert(int,NULL)) from #temp
It will return 0 because when you execute the query:
SELECT CONVERT(int,NULL) it will return NULL and as the return type of COUNT is...
April 16, 2013 at 6:42 am
Mighty (4/12/2013)
Shouldn't TCP in the answers be TSQL?TCP is one of the two protocols that can be used, TSQL is a payload type.
I was wondering this myself. The documentation...
April 12, 2013 at 7:37 am
Arrrr, ya got me. I fell for the logic error and completely missed the TEXT data type.
:blink::blink:
April 9, 2013 at 7:29 am
Christian Buettner-167247 (4/8/2013)
CASE WHEN COALESCE(
TRY_CAST(@input AS numeric)
,TRY_CAST(@input AS bigint)
,TRY_CAST(@input AS money)
,TRY_CAST(@input AS smallint)
,TRY_CAST(@input AS smallmoney)
...
April 8, 2013 at 9:40 am
Chrissy321 (4/4/2013)
Yes, its called a data driven subscription.http://msdn.microsoft.com/en-us/library/ms169673.aspx
I believe you need Enterprise Edition for this.
Fantastic, thanks Chrissy321! Where were you 6 months ago? :-P:-D
April 4, 2013 at 8:45 am
Viewing 15 posts - 226 through 240 (of 429 total)