Skip to Content
Beginning ASP.NET 3.5: In C# and VB
book

Beginning ASP.NET 3.5: In C# and VB

by Imar Spaanjaars
March 2008
Intermediate to advanced content levelIntermediate to advanced
766 pages
21h 15m
English
Wrox
Content preview from Beginning ASP.NET 3.5: In C# and VB

11.4. Creating Your Own Tables

Creating tables in a SQL Server 2005 database is easy using the built-in database tools that are part of VWD. You'll see how you can create your own tables in the database after the next section that briefly introduces you to the data types you have at your disposal in SQL Server 2005 and up.

11.4.1. Data Types in SQL Server

Just as with programming languages like Visual Basic .NET and C#, a SQL Server database uses different data types to store its data. SQL Server 2005 supports almost 30 different data types, most of which look similar to the types used in .NET. The following table lists the most common SQL Server data types together with a description and their .NET counter parts.

SQL 2005 Data TypeDescription.NET Data Type
bitStores Boolean values in a 0 / 1 formatSystem.Boolean
char / ncharContains fixed-length text. When you store text shorter than the defined length, the text is padded with spaces. The nchar stores the data in Unicode format, which allows you to store data for many foreign languages.System.String
datetimeStores a date and a time.System.DateTime
decimalAllows you to store large, fractional numbers.System.Decimal
floatAllows you to store large, fractional numbers.System.Double
imageAllows you to store large binary objects such as files. Although the name suggests that you can only use it to store images, this is not the case. You can use it to store any kind of document or other binary object.System.Byte[]
tinyintUsed to store integer ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Beginning ASP.NET 4: in C# and VB

Beginning ASP.NET 4: in C# and VB

Imar Spaanjaars
Professional ASP.NET 3.5 SP1 Edition: In C# and VB

Professional ASP.NET 3.5 SP1 Edition: In C# and VB

Bill Evjen, Scott Hanselman, Devin Rader

Publisher Resources

ISBN: 9780470187593Purchase book