Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Address Question

Author  Topic 

Danny4003
Starting Member

40 Posts

Posted - 2006-10-26 : 15:10:21
Is there a way to put City,State,and Zip all on one column? Please respond thanx in advance.
Danny Dubroc

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-10-26 : 15:20:31
Yes there is, but you shouldn't do that as that's bad design.

Tara Kizer
Go to Top of Page

Danny4003
Starting Member

40 Posts

Posted - 2006-10-26 : 15:28:07
Thank you for your advice.
Danny D :)
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-10-26 : 21:15:08
Read about Normalisation

http://www.datamodel.org/NormalizationRules.html


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -