Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2008 Expand / Collapse
Author
Message
Posted Saturday, January 9, 2010 11:42 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, October 21, 2013 11:43 PM
Points: 945, Visits: 1,234
Comments posted to this topic are about the item SQL Server 2008

Amol Naik
Post #844943
Posted Sunday, January 10, 2010 11:00 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, July 4, 2014 8:50 AM
Points: 250, Visits: 428
Hi ,

Sorry but i do not agree with the answer on this one ,Please could some one shed some light on the fact that according to BOL s that :

A DEFAULT value cannot be specified in the definition of a user-defined table type.


(The question is making specific reference to udf table types and not udf types as the refrence in the question specifies)[size="2"][/size]


Please see the correct reference according to me :

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_1devconc/html/99cbdb5c-589c-47e9-887a-0039db7f104a.htm

The correct answer to this question is in fact "False"
Post #845184
Posted Sunday, January 10, 2010 11:05 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, July 4, 2014 8:50 AM
Points: 250, Visits: 428
Sorry my bad , I see that there has been a change according to msdn

http://msdn.microsoft.com/en-us/library/bb522526.aspx

In the Change History updated content was provided :

Removed the following statement from Restrictions: A DEFAULT value cannot be specified in the definition of a user-defined table type.


I obviously need to updater my BOL


Post #845186
Posted Monday, January 11, 2010 4:36 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 5, 2013 6:08 AM
Points: 1,079, Visits: 591
Can't complain...

What you don't know won't hurt you but what you know will make you plan to know better
Post #845286
Posted Monday, January 11, 2010 8:36 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:41 PM
Points: 31,080, Visits: 15,525
That's one reason we try to only refer to the online BOL version. It changes quarterly, and local help can easily be out of date if you're not paying attention.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #845456
Posted Monday, January 11, 2010 10:14 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:53 PM
Points: 1,388, Visits: 3,039
Cedric,

Thanks for the link about Table Types.

The QOD asks about table types, but the BOL link in the explanation refers to user defined data types. I find nothing about table types in the 2005 BOL entry for "Create Type", so may i assume this is a feature new to 2008?
Post #845553
Posted Monday, January 11, 2010 10:50 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, October 21, 2013 11:43 PM
Points: 945, Visits: 1,234
This is a new feature in SQL Server 2008.

Amol Naik
Post #845568
Posted Monday, January 11, 2010 10:49 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, July 4, 2014 8:50 AM
Points: 250, Visits: 428
As per Previous Post ,yes this is a new feasture in SQL Server 2008.But thanks for the questions.Makes one think and also do a bit of investigation before just answering .That will teach me to rather use the online version or update my BOL more regularly.
Post #845865
Posted Tuesday, March 16, 2010 11:29 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, June 13, 2014 3:03 PM
Points: 594, Visits: 655
Yay! Thanks BOL! I taught that last week... but with the wrong information that I learned from BOL... lol ... I guess I need to pay more attention to the changes in BOL.

Man, even when I am right I am wrong sometimes...


Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
Post #884033
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse