May 28, 2016 at 11:21 am
Comments posted to this topic are about the item Variable datatype DDL
May 28, 2016 at 10:21 pm
One remark:
`... and varchar defaults to 30 if not specified` ?
Default value is 1 for the char and varchar data types
Default value is 30 when the char or varchar data types are used with the CAST and CONVERT functions
May 29, 2016 at 11:20 pm
Nice easy one to start the week, thanks.
...
May 29, 2016 at 11:30 pm
This was removed by the editor as SPAM
May 30, 2016 at 7:08 am
sabinweb (5/28/2016)
One remark:`... and varchar defaults to 30 if not specified` ?
Default value is 1 for the char and varchar data types
Default value is 30 when the char or varchar data types are used with the CAST and CONVERT functions
Not only that:
' the property must be enabled for the database and table' ?
That has not been true for any release later than SQL server 2005. The question explicity specifies SQL server 2012. Fortunately (unlike about 3 weeks ago) this time explaining as if the system didn't change in 2008 only impacts the explanation, not the question and answer.
Tom
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply