Viewing 15 posts - 451 through 465 (of 812 total)
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
Some formatting with CONCAT:
SELECT
concat
(
'Name: ',t.name
...
July 9, 2013 at 1:55 am
select concat(null + 'Hello','testString') as a
, null+'testString' as b
It simply returns 'testString', NULL
😀
July 9, 2013 at 1:25 am
Wonderfull!
You gave me a good Idea.
😀
July 8, 2013 at 1:13 am
Iggy-SQL (7/2/2013)
Statement 1 : The SQL Database Engine converted the Val value to...
July 3, 2013 at 1:08 am
Hugo Kornelis (6/19/2013)
L' Eomot Inversé (6/19/2013)
June 20, 2013 at 1:01 am
matthew.flower (6/19/2013)
June 19, 2013 at 3:29 am
Viewing 15 posts - 451 through 465 (of 812 total)