469,645 Members | 1,150 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

is case sensitive & normalization

1. sql server 2005 is case sensitive or not......
2. do sql have normalization concept like oracle.........
Mar 6 '08 #1
4 986
ck9663
2,878 Expert 2GB
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
Mar 6 '08 #2
-- CK[/quote]
thank u sir...

1.what is the difference between oracle and sql server.....
Mar 7 '08 #3
amitpatel66
2,367 Expert 2GB
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.
Mar 7 '08 #4
ck9663
2,878 Expert 2GB
-- CK
thank u sir...

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

Your question would require a course in a university :)
Mar 7 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

32 posts views Thread by Elliot Temple | last post: by
2 posts views Thread by Matthew Louden | last post: by
2 posts views Thread by J. Muenchbourg | last post: by
5 posts views Thread by satish mullapudi | last post: by
38 posts views Thread by Bart | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.