Build me an SQL - SQL Server Forums

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

Other Forums

Other Topics

Build me an SQL

Author

Topic

HEARDBOY
Starting Member

5 Posts

Posted - 2005-04-15 : 13:03:51

SQL

We need a very simple SQL database and web form created which will allow users to enter their mailing information and contact info. The database will be used for a contest. PLEASE CONTACT ME…

denis@theheard.org
416-907-3215

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2005-04-15 : 14:02:20

Here you go. Where do I send the bill?

create table T_USER
(
USER_ID					int		not null
					identity(1,1)primary key clustered,
USER_NAME				varchar(100)	not null,
USER_FIRST_NAME				varchar(100)	null,
USER_MIDDLE_NAME			varchar(100)	null,
USER_LAST_NAME				varchar(100)	null,
USER_MAIL_ADDRESS_LINE_1		varchar(50)	null,
USER_MAIL_ADDRESS_LINE_2		varchar(50)	null,
USER_MAIL_ADDRESS_LINE_3		varchar(50)	null,
USER_MAIL_ADDRESS_LINE_14		varchar(50)	null,
USER_MAIL_ADDRESS_CITY			varchar(50)	null,
USER_MAIL_ADDRESS_STATE_CODE		varchar(10)	null,
USER_MAIL_ADDRESS_POSTAL_CODE		varchar(10)	null,
USER_PHONE_1				varchar(30)	null,
USER_PHONE_2				varchar(30)	null,
USER_PHONE_3				varchar(30)	null,
USER_PHONE_4				varchar(30)	null,
USER_PHONE_5				varchar(30)	null,
USER_EMAIL_1				varchar(200)	null,
USER_EMAIL_2				varchar(200)	null,
USER_EMAIL_3				varchar(200)	null,
USER_EMAIL_4				varchar(200)	null,
USER_EMAIL_5				varchar(200)	null
)

CODO ERGO SUM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources