SQL Server - SQL Server Database Setup - Almost Newbie First db

Asked By Templar

08-Jan-10 11:47 AM

-- My Form Solicits The Following:
Type of Pet: (radio button selection)
First Name (text)
Last Name (text)
Street Address (text/numeric)
City (text)
State (text)
Zip Code: (numeric)
Email: (text)
Phone: (numeric)
Name of Pet (Text)
Age (numeric)
Weight (numeric)
Breed (text)
Color (text)
Gender (radio button selection)
Spayed (radio button selection)
Rabies Vacine (radio button selection)
Pet Information (text box)
Photo (upload)
OptIn (Checkbox Yes/No)

The SQL table CREATION TOOL at my host has the following columns
KEY - Column - Type - Length - Prec. - Scale - Nullable - Default - ID. -
Id.Incr. -
Id. seed - Row GUID

I am presuming the field name goes into the "Column" column.  However, I am
seeking guidance in understanding how to respone/what to enter in the other
columns beginning with KEY and ending with Row GUID with the TYPE column
appearing to be the most significant.  I would presume that VarChar would be
appropriate for the text fields and Int. appropriate for the numbers (zip
code etc) fields..............but who knows.  The TYPLE Column provides a
drop down menu which provides the following list from which to choose:

BigInt, Binary, Bit, Char, DataTime, Decimal, Float, Image, Int, Money,
NChar, None,
NText. Numeric. NVarChar, NVarCharMax, Real, SmallDateTime, SmallInt,
SmallMoney, SysName, Text, TimeStamp, TinyInt, UniqueIdentifer, VarBinary
VarBinaryMax, VarChar, VarCharMax, Variant, XML

Can you direct me to a handy "jump start" learning aid/resource/cheat
sheet...................whatever..........that will get me "up and running".

PS:  I wish there was a way of including an attachment with this question.

Thanks.


Templar

08-Jan-10 12:23 PM

am
er
ld be
a
=A0
g".
on.

This a broad question and it looks like you will need a beginner's book
on SQL Server to really get started. I can tell you that tinyints work
well to represent the radio button selections (as they usually
translate to enumerated values in the code), the photos would be a
varbinary, checkboxes transate to bits as they are 0 or 1

Hope this helps in some way

Carl

08-Jan-10 02:55 PM

Thank you Carl.  Do you have any particular beginners book in mind?
Templar

08-Jan-10 04:40 PM

D. -
r, I am
other
umn
would be
(zip
ides a
y,
nary
nning".
estion.

Both of these got good ratings on Amazon

Beginning SQL Server 2008 for Developers: From Novice to Professional

Murach's SQL Server 2008 for Developers

Carl