Viewing 15 posts - 451 through 465 (of 819 total)
Nick Doyle (8/22/2013)
August 22, 2013 at 7:06 am
In the past 10 years, I played a lot with SET identity_insert. I'm a specialist!
August 22, 2013 at 6:54 am
Hugo Kornelis (8/19/2013)
Mike Dougherty-384281 (8/19/2013)
August 19, 2013 at 3:24 pm
cschlieve (8/13/2013)
dhober (8/13/2013)
Silly semantics....Being able to have only one catalog is still technically having one or more catalogs 🙂
That kind of thinking can get you into a lot of trouble....
August 13, 2013 at 8:57 am
Very good explanation!
Here is why the first select may return 1,-1,negative and the second only 1 and negative.
The same side effect of "C" macros:
#define abs(a) (a < 0?...
August 8, 2013 at 2:21 am
Good! It's good practise to remember basic concepts!
😀
August 6, 2013 at 1:05 am
Easy qotd, but explanation is really confused.
Schemabinding doesn't hide the definition and users of the database could still view the definition if TDE is enabled.
Why do you think that...
August 1, 2013 at 12:53 am
sneumersky (7/24/2013)
That said, there are probably other potential uses for indexed views (BI or non-BI related) than I can think of at this moment in time.
I use indexed view to...
July 25, 2013 at 1:55 am
Before ALTERing an INDEXED VIEW is better to save its list of indexes, because they'll be dropped.
It would be better putting a comment in the view with the command to...
July 24, 2013 at 3:12 am
Hugo Kornelis (7/23/2013)
...
In other words - if the statement causes a trigger to fire, it should have either no OUTPUT clause or an OUTPUT clause with an INTO keyword....
July 24, 2013 at 1:08 am
mickyT (7/17/2013)
I think it also provides a good argument for the use of statement terminators or formatting scripts in a clear manor (with comments:-D).
Batch...
July 17, 2013 at 11:57 pm
kapil_kk (7/16/2013)
as per the explanation- The stmt "return (select 5)" gives error because in a batch RETURN with integer_expression is not admitted (note: PARENTHESIS cast the SELECT to an integer_expression...
July 17, 2013 at 2:49 am
L' Eomot Inversé (7/9/2013)
However, introducing a weird ODBC function into T-SQL seems to me a...
July 9, 2013 at 3:52 am
Hugo Kornelis (7/9/2013)
Carlo Romagnano (7/9/2013)
select concat(null + 'Hello','testString') as a, null+'testString' as b
It simply returns 'testString', NULL
😀
Yup. If you wanted to get 'HellotestString', you'd use...
July 9, 2013 at 3:16 am
Viewing 15 posts - 451 through 465 (of 819 total)