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
Go to Top of Page
   

- Advertisement -