November 11, 2015 at 10:11 pm
Comments posted to this topic are about the item User Defined Data Type Alias
November 11, 2015 at 10:12 pm
This was removed by the editor as SPAM
November 12, 2015 at 1:59 am
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 12, 2015 at 2:41 am
A cool trivia question,
thanks Steve.
November 12, 2015 at 5:28 am
I haven't had to create custom types yet, so I learned something new. Thanks.
November 12, 2015 at 6:19 am
Got it wrong. I've only used user defined table types, for which you need AS not FROM. I wonder why the syntax is different?
November 12, 2015 at 6:55 am
Thanks for the question but I wasn't so sure of the answer, had to do some research. But learned something.
November 12, 2015 at 7:41 am
Nice question Steve. I knew the answer without thinking about it and realized as the button was being clicked I had the wrong one selected.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 12, 2015 at 8:04 am
This was removed by the editor as SPAM
November 12, 2015 at 9:16 am
Sean Lange (11/12/2015)
Nice question Steve. I knew the answer without thinking about it and realized as the button was being clicked I had the wrong one selected.
Yeah, I clicked AS as well. I then looked it up and learned something I thought I already knew.
November 12, 2015 at 10:38 am
Toreador (11/12/2015)
Got it wrong. I've only used user defined table types, for which you need AS not FROM. I wonder why the syntax is different?
different people/teams that don't talk is my guess.
November 17, 2015 at 5:11 am
Oh dear, brain not working today, it seems to have entered lazy mode. Just answered last weeks create type question (correctly) and commented on the terminology (which MS seems to have somewhat muddled). The looked at this question and picked the first "create type" I saw without checking the following syntax - the first option made me think only the second word would count. I must remember to read teh whold statement (and probably read all the otions) in future.
Tom
November 18, 2015 at 5:36 am
Thanks for this easy question because there are very few modifications in the syntax of CREATE TYPE since its appearance with SQL Server 2005.
I have begun to use SQL Server with SQL Server 6.5 full included in the upgrade of my VB/C++ 5.0 towards the Entreprise Edition around 1998. I was pleased to see the 1st SQL Server 2005 Express ( and VB/VC# Visual Studio ) , I used it and I begun to post on the MSDN forums . On the beginning , it was only to get information about problems I was facing , afterwards , to share my experience and to try to help the original posters. And CREATE TYPE was the topic of some of my posts and it is why I wrote "easy question".
Now , even if I am appearing always on forums , my main source of information is the QOD/articles and forums of SQL Server Central. So thank you very much for all people who replied to me and helped to rectify my errors.
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply