Viewing 15 posts - 136 through 150 (of 552 total)
Thanks for the post, SJ, nice one.
(I have read all the posts, and I see it; and I also wondered by seeing the score stats... what went wrong - see...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 9, 2014 at 7:34 am
Thank you, SJ, interesting one.
(I had selected 2nd choice, but still I wrote the code to test my analysis... I succeed :-). To be honest, never tried this explicitly.)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 8, 2014 at 2:03 am
vineet_dubey1975 (9/8/2014)
so this means this is only true in...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 8, 2014 at 2:00 am
Thanks for the post, SJ, good one.
(Actually, I used two, one Visual SourceSafe 6.0 with came with Visual Studio 6.0 in year 1999, and then (I don't remember that...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 5, 2014 at 8:39 am
twin.devil (9/4/2014)
DrKiller (9/4/2014)
CTEs doesn't ALWAYS need a semi-colon in front.
This for example works fine:
DECLARE @tmpVariable INT
WITH cte
AS
(
SELECT 1/0 as 'Result'
)
SELECT *
...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 4, 2014 at 4:25 am
Carlo Romagnano (9/4/2014)
pmadhavapeddi22 (9/4/2014)
When I work with CTE, I get this error when I dont give smicolon, so it was easy to answer 🙂Thanks for the question
+1
+1
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 4, 2014 at 1:55 am
Thank you for the post, Shiva, good one.
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 4, 2014 at 1:54 am
One thing I like in SQL at the moment is, how the references are transferred or carried further....
for example; "TVP.Address" is the main TYPE structure and then a variable is...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 3, 2014 at 11:56 am
Dana Medley (9/3/2014)
Great question. Thanks.
Seriously, I am one step away from swatting my laptop screen, every time I see your avatar automatically my hand raises from the keyboard... and then...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 3, 2014 at 7:42 am
Thank you for the post ,Stewart , very interesting one and also highlighting the new way of using them. Great.
while executing the last script block, I got this error,...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 3, 2014 at 7:13 am
Koen Verbeeck (9/2/2014)
This is indeed when you alter the column definition.With ADD PERSISTED you add the property to the column, but you are not modifying the column definition itself.
Thanks, that...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 2, 2014 at 1:43 am
Koen Verbeeck (9/2/2014)
You forgot the ADD keyword.
ALTER TABLE MyTest
ALTER COLUMN third ADD PERSISTED
Thanks Keon, I saw that in the local_help after posting, just missed it.
Hope you can add some light...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 2, 2014 at 1:24 am
Thanks for the post, SJ, good one
but, not sure if I am missing here anything, I tried using ALTER TABLE ALTER COLUMN, it gives the error.
ALTER TABLE MyTest
ALTER COLUMN...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 2, 2014 at 1:06 am
Thank you for the post, SJ, interesting one. Initially there were lot of confusion for me after reading QToD, as knowing May 1 as International Worker's Day and so it...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 1, 2014 at 5:02 am
Thank you for the post, Steve, simple and nice.
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
August 29, 2014 at 2:34 am
Viewing 15 posts - 136 through 150 (of 552 total)