|
|
Posted by David Portas on 10/02/81 11:47
Nasir wrote:
> So going back to my original question - seems like it really does not
> support at the server level setting of SQL 2005, to achieve table and column
> names insensitive and chacter data to be sensitive. Is that correct?
>
> To get the character data sensitive I have to modify each column with
> collate, what a mess! I'm surprised that so many people are OK/fine with
> Oracle way of dictionary insensitve and data sensitive, but it's so hard to
> get thatin SQL. There got to be a btter way!
>
If you use design tools and scripts to generate schemas (as surely most
of us do) then the fact that the schema is part of the column
definition shouldn't cause you any problem. You are really looking for
a syntax shortcut. You can always propose it at:
http://lab.msdn.microsoft.com/ProductFeedback/
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
Navigation:
[Reply to this message]
|