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...

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.)

vineet_dubey1975 (9/8/2014)

---

in sql server 2012 I am able to create the synoname also I am able to select the rows from the table.

so this means this is only true in...

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...

twin.devil (9/4/2014)

---

DrKiller (9/4/2014)

---

I think the explanation need some work.

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 *

...

+1

Thank you for the post, Shiva, good one.

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...

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...

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,...

Thanks, that...

Thanks Keon, I saw that in the local_help after posting, just missed it.

Hope you can add some light...

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...

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...

Thank you for the post, Steve, simple and nice.