is case sensitive & normalization

[joshguru]

1. sql server 2005 is case sensitive or not......
2. do sql have normalization concept like oracle.........

[ck9663]

1. sql server 2005 is case sensitive or not......
2. do sql have normalization concept like oracle.........

1. Can be either, depending on your configuration. By default, I believe (read: not sure), is no, it's not case sensitive.

2. Am not into terms, but if you're talking about normalization on your db and tables, yes, SQL-Server, by design, is a relational database. But it still depends on your implementation. If you just create a table without implementing these features, then it's just serving as storage.

-- CK

[joshguru]

-- CK[/QUOTE]
thank u sir...

1.what is the difference between oracle and sql server.....

[amitpatel66]

YES, Normalization is very important in terms of database design. In order to avoid data redunduncy, better performance, proper space usage, etc Normalization concepts needs to be considered for database design.

[ck9663]

-- CK

thank u sir...

1.what is the difference between oracle and sql server.....[/QUOTE]

Your question would require a course in a university :)